Senior Oracle DBA

Toronto, ON
On-site
Posted Nov 4, 2026
1 position

Opens LinkedIn

Employment type: Contract
Experience level: Lead · 10+ years
Posting language: English
Working hours: 40 hours per week
Seniority: Mid-Senior level
Application method: Apply on LinkedIn (LinkedIn sign-in required)

Job summary

Design and optimize Oracle and PostgreSQL databases, develop and deploy PL/SQL components, and manage database releases, migrations, monitoring, and performance troubleshooting. Support AWS database environments, high availability and disaster recovery, CI/CD integration, and production maintenance in collaboration with application, infrastructure, cloud, and offshore teams.

Job details

Key Responsibilities Collaborate with application teams on data modeling, schema design, and deployment of complex PL/SQL packages, procedures, triggers, and views. Analyze execution plans, tune SQL queries, and optimize indexes for high-throughput transactional environments. Lead database release automation, code reviews, and schema migrations across Development, Staging, and Production. Monitor database health and troubleshoot lock contention, deadlocks, latency, and performance issues. Partner with infrastructure and cloud teams to design and execute on-premises to AWS database migrations. Support Oracle and PostgreSQL databases within AWS environments. Participate in database capacity planning, failover testing, and disaster recovery design. Integrate database deployments with CI/CD pipelines and Agile delivery processes. Collaborate with offshore teams for maintenance and production support. Provide occasional weekend and after-hours support for deployments and maintenance activities. Core Qualifications 8-10 years of Oracle Database Administration experience. Strong expertise with Oracle Database 12c/19c+. Advanced experience with: PL/SQL Execution Plan Analysis SQL Performance Tuning AWR ASH ADDM Hands-on experience administering AWS database services, including: Amazon RDS for Oracle Amazon RDS for PostgreSQL Amazon Aurora Hands-on knowledge of PostgreSQL architecture, schema design, and performance optimization. Proven experience migrating on-premises databases to AWS. Experience with AWS migration tools such as: AWS DMS AWS SCT Native Database Migration Utilities Strong experience with database release management and CI/CD integration. Experience supporting high-availability and disaster recovery environments. Strong troubleshooting, analytical, and performance optimization skills. Preferred Qualifications Oracle Exadata administration experience. Knowledge of Exadata performance features including Smart Scan and Hybrid Columnar Compression. Bash/Shell scripting experience. Python automation experience. AWS database-related certifications. Oracle database certifications. Key Skills Oracle Database 12c/19c+ Oracle DBA PL/SQL SQL Performance Tuning AWR / ASH / ADDM PostgreSQL AWS Amazon RDS Amazon Aurora AWS DMS AWS SCT Database Migration Oracle Exadata CI/CD Database Automation Disaster Recovery High Availability Bash Python Agile

What you’ll do

Requirements

Requires 8–10 years of Oracle Database Administration experience, strong Oracle 12c/19c+ and PL/SQL expertise, and advanced SQL performance tuning and diagnostic skills. Candidates should also have hands-on AWS RDS and Aurora experience, PostgreSQL knowledge, on-premises-to-AWS migration experience, and database release, CI/CD, high-availability, and disaster-recovery experience.