Senior Oracle Database Administrator

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 don’t 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