Database Administrator (DBA) – Specialist (Oracle GoldenGate / SQL Azure)

Apex Systems; Toronto; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A leading technology services firm is seeking a Database Administrator Specialist. This hybrid role, based in downtown Toronto, demands strong expertise in Oracle GoldenGate and SQL Azure. The successful candidate will manage critical database systems, optimize performance, and support enterprise-level applications across Capital Markets and Retail Banking. Qualifications include 5–7 years of database administration experience and proficiency in PostgreSQL. This position also involves incident management and collaboration with other technical teams.

Qualifications

• 5–7 years of experience in Oracle GoldenGate or Azure Cloud database administration.
• 2+ years of experience with PostgreSQL.
• Strong skills in database setup, installation, and configuration.
• Expertise in tuning, query optimization, monitoring, and troubleshooting.
• Experience with cloud migration projects.
• Knowledge of backup, restore, and recovery strategies.

Responsibilities

• Lead technical resolutions for production incidents and communicate complex issues to stakeholders.
• Install, configure, and maintain Oracle and SQL Server databases.
• Optimize database performance through indexing, query tuning, and resource management.
• Implement and maintain database security policies.
• Support RAC, high availability, and disaster recovery strategies.
• Automate database monitoring and maintenance tasks.
• Participate in incident management, change control, and root cause analysis.
• Provide on-call rotational support and collaborate with teams.

Skills

Oracle GoldenGate

SQL Azure

PostgreSQL

Database Performance Tuning

Cloud Migration

Tools

Microsoft SQL Server

ServiceNow

SolarWinds

Job description

Location: Hybrid – in-office every Tuesday. Downtown Toronto.

Duration of Contract/Perm: 6-month contract (possibility of extension or conversion to FTE based on performance and budget).

Hours/week: 37.5 hrs

Job Overview

We are looking for a Database Administrator Specialist with expertise in Oracle GoldenGate and SQL Azure, and experience supporting enterprise-level databases. This role involves working on critical projects for Capital Markets, PBBT, and Retail Banking, including Oracle builds, migrations, performance tuning, and incident resolution. You will join a close-knit team of 20 DBAs, divided into specialized groups, supporting complex troubleshooting and BAU activities across multiple lines of business.

Key Responsibilities

• Lead technical resolutions for production incidents and communicate complex issues to stakeholders.
• Install, configure, and maintain Oracle and SQL Server databases.
• Optimize database performance through indexing, query tuning, and resource management.
• Implement and maintain database security policies, including Oracle features (TDE, Data Redaction, Database Vault) and SQL Server features (TDE, Always Encrypted).
• Support RAC, high availability (HA), and disaster recovery (DR) strategies.
• Automate database monitoring and maintenance tasks.
• Participate in incident management, change control, disaster recovery exercises, and root cause analysis (RCA).
• Ensure compliance with organizational standards for change control and security.
• Provide on-call rotational support and collaborate with Solution Design, DB Engineering, Information Security, and external vendors.

Must-Have Qualifications

• 5–7 years of experience in Oracle GoldenGate or Azure Cloud database administration.
• 2+ years of experience with PostgreSQL.
• Strong skills in database setup, installation, and configuration.
• Expertise in tuning, query optimization, monitoring, and troubleshooting.
• Experience with cloud migration projects.
• Knowledge of backup, restore, and recovery strategies.

Nice-to-have Skills

• Experience with Microsoft SQL Server.
• Familiarity with ServiceNow ticketing system and SolarWinds performance tools.
• Financial industry experience.

EEO Employer

Apex is an Equal Employment Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [e-mail] or 844-463-6178.