Senior Oracle DBA

Flexstaf I.T. Inc.; Toronto; On-site; CAD 90,000 - 130,000; Full time

Job summary

Flexstaf I.T. Inc. seeks an experienced Oracle Database Administrator to design, optimize, and manage high-availability database environments in AWS. You will lead schema migrations, automate releases, and partner with cross-functional teams to ensure performance and reliability.

Responsibilities include tuning PL/SQL, monitoring health, and supporting on-premises to AWS migrations while coordinating with offshore teams and providing after-hours support as needed.

Qualifications

• 8-10 years of Oracle Database Administration experience.
• Strong expertise with Oracle Database 12c/19c+.

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.

Skills

Oracle DBA

PL/SQL

SQL Tuning

AWR

ASH

ADDM

AWS RDS for Oracle

AWS SCT

DMS

CI/CD

High Availability

Disaster Recovery

Troubleshooting

Tools

Native Migration Utilities

Job description

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

• Knowledge of Exadata performance features including Smart Scan and Hybrid Columnar Compression.