Senior Oracle Database Administrator

4 weeks ago


Ottawa, Canada Donna Cona Full time

Overview Reference # : 8074 Location : Ottawa Type : Sub-contract Donna Cona Inc. is currently seeking an experienced Senior Oracle Database Administrator, for one of our key government clients. Background 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 be monitoring overall database performance metrics and diagnosing performance issues, doing in depth analysis of SQL Query performance, analyzing query access plan for potential problems, rewriting SQLs for better performance and developing solutions for problematic and slow queries, and performing SQL plan management. Responsibilities The role focuses on ensuring high database performance and resolving performance issues for a complex, mission-critical Oracle database. Key activities include: 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 SQL statements for better performance and develop solutions for slow queries. Perform SQL plan management. Qualifications Candidate MUST have the following : Valid Federal Government of Canada Enhanced Reliability Security Clearance; Oracle Database Certified with over ten (10+) years or more experience; Advanced expertise in performance tuning and troubleshooting database performance issues; Advance 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; and Knowledge of best practices for good database performance. Assets Experience with Oracle Golden Gate Knowledge of Oracle Multitenant (CDB / PDB) Bonus – Bilingual (English / French) EEO Statement 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. #J-18808-Ljbffr



  • Ottawa, Canada Donna Cona Inc. Full time

    OverviewReference #: 8074Location: Ottawa – RemoteType: Sub-contractDonna Cona Inc. is currently seeking an experienced Senior Oracle Database Administrator for one of our key clients.ResponsibilitiesA Database and SQL performance expert whose primary responsibility will be to maintain good performance of a complex and mission critical database.Capability...


  • Ottawa, Canada Donna Cona Inc. Full time

    Overview Reference #: 8074Location: Ottawa – RemoteType: 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....


  • Ottawa, Canada Donna Cona Inc. Full time

    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...


  • Ottawa, Canada Stantec Full time

    Database Administrator, Oracle E-Business Suite Join to apply for the Database Administrator, Oracle E-Business Suite role at Stantec Database Administrator, Oracle E-Business Suite 2 weeks ago Be among the first 25 applicants Join to apply for the Database Administrator, Oracle E-Business Suite role at Stantec Get AI-powered advice on this job and more...


  • Ottawa, Canada Stantec Full time

    Database Administrator, Oracle E-Business SuiteJoin to apply for the Database Administrator, Oracle E-Business Suite role at StantecDatabase Administrator, Oracle E-Business Suite2 weeks ago Be among the first 25 applicantsJoin to apply for the Database Administrator, Oracle E-Business Suite role at StantecGet AI-powered advice on this job and more exclusive...


  • Ottawa, Canada Stantec Full time

    Database Administrator, Oracle E-Business SuiteJoin to apply for the Database Administrator, Oracle E-Business Suite role at StantecDatabase Administrator, Oracle E-Business Suite2 weeks ago Be among the first 25 applicantsJoin to apply for the Database Administrator, Oracle E-Business Suite role at StantecGet AI-powered advice on this job and more exclusive...


  • Ottawa, Canada Procom Full time

    Senior Database Administrator / Developer. ONSITE (OTTAWA) THIS CONTRACT HAS A TBD START DATE AND GOES FOR 1 YEAR LATER 4 OPTION PERIOD OF 1 YEAR EACH LOCATION : ONSITE (THE CLIENT IS IN THE OTTAWA AREA) LANGUAGE : ENGLISH CLEARANCE : SECRET (MUST HOLD AND BE ELIGIBLE FOR TS) REFERENCES : ALL PROJECTS CITED Mandatory Skills Must hold University degree or...


  • Ottawa, Canada Procom Full time

    Senior Database Administrator / Developer. ONSITE (OTTAWA) THIS CONTRACT HAS A TBD START DATE AND GOES FOR 1 YEAR LATER 4 OPTION PERIOD OF 1 YEAR EACH LOCATION : ONSITE (THE CLIENT IS IN THE OTTAWA AREA) LANGUAGE : ENGLISH CLEARANCE : SECRET (MUST HOLD AND BE ELIGIBLE FOR TS) REFERENCES : ALL PROJECTS CITED Mandatory Skills Must hold University degree or...


  • Ottawa, Canada Procom Full time

    Senior Database Administrator / Developer. ONSITE (OTTAWA) THIS CONTRACT HAS A TBD START DATE AND GOES FOR 1 YEAR LATER 4 OPTION PERIOD OF 1 YEAR EACH LOCATION : ONSITE (THE CLIENT IS IN THE OTTAWA AREA) LANGUAGE : ENGLISH CLEARANCE : SECRET (MUST HOLD AND BE ELIGIBLE FOR TS) REFERENCES : ALL PROJECTS CITED Mandatory Skills Must hold University degree or...


  • Ottawa, Canada BITSUMMIT Full time

    **Position Summary** We are seeking an experienced Database Administrator to join our team. In this role, you will be responsible for designing, implementing, and maintaining high-availability database solutions using Oracle Database and Microsoft SQL Server. You will play a critical role in ensuring database security, optimizing performance, and managing...