Job Title

Overview Reference #: 8074 Location: Ottawa Remote Type: Sub-contract Donna Cona Inc. is currently seeking an experienced Senior Oracle Database Administrator for one of our key clients. Responsibilities A Database and SQL performance expert whose primary responsibility will be to maintain good performance of a complex and mission critical database. Capability and aptitude for deep diving into complex database performance issues is critical for success in this role. The Oracle DBA will monitor overall database performance metrics and diagnose performance issues, perform in-depth analysis of SQL query performance, analyze query access plans for potential problems, rewrite SQLs for better performance, develop solutions for problematic and slow queries, and perform SQL plan management. Qualifications Valid Federal Government of Canada Enhanced Reliability Security Clearance; Oracle Database Certified with 10+ years of experience; Advanced expertise in performance tuning and troubleshooting database performance issues; Advanced SQL query writing skills; Deep understanding of database objects and tools to improve performance; Database statistics management; AWR analysis; Server-level stats analysis related to CPU, memory and network; Good understanding of database views to mine performance data; Knowledge of best practices for good database performance. Assets Experience with Oracle GoldenGate Knowledge of Oracle Multitenant (CDB/PDB) Company and EEO Donna Cona is committed to a diverse, equitable and inclusive workplace. We are an equal opportunity employer. We dont discriminate on the basis of gender, gender identity, sexual orientation, race, national origin, disability, age, or any other protected status. We are committed to maintaining a barrier-free recruitment process by providing equal employment opportunities through recruiting and retention of individuals. How to apply To apply for this position please complete the form below. Name First Last Email * Daytime Phone * City * Province/State * Attach Cover Letter and Resume * Max. file size: 20 MB. Please note that these must be in one document, and can be in .docx, .doc, .pdf or .rtf formats #J-18808-Ljbffr