Senior Oracle Database Administrator

Donna Cona Inc.; Ottawa; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A leading consulting firm in Ontario is seeking a Senior Oracle Database Administrator to maintain performance of complex databases. The ideal candidate has over 10 years of experience, SQL query expertise, and a Federal Government Enhanced Reliability Security Clearance. This remote position offers the opportunity to work on mission-critical database performance and troubleshooting.

Qualifications

• 10+ years of experience with Oracle databases.
• Valid Federal Government of Canada Enhanced Reliability Security Clearance.
• Deep understanding of database objects and performance improvement tools.

Responsibilities

• Maintain performance of mission-critical databases.
• Analyze SQL query performance and rewrite for better efficiency.
• Monitor overall database performance metrics and diagnose issues.

Skills

Performance tuning

SQL query writing

Database statistics management

Education

Oracle Database Certification

Tools

Oracle GoldenGate

Job description

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