Senior Oracle DBA & Cloud Migration Lead

Astra-North Infoteck Inc.; Toronto; On-site; CAD 120,000 - 180,000; Full time

Job summary

Astra-North Infoteck Inc. in Toronto is seeking an experienced Senior Oracle Application DBA to optimize, scale, and maintain mission-critical database applications, partnering with development and engineering teams to ensure high availability.

You will drive SQL/PL-SQL performance, database modernization, and cloud migration initiatives, including on-premises to AWS migrations and disaster recovery design.

Qualifications

• 8+ years specializing in Oracle Database (12c/19c+) application support, advanced PL/SQL programming, execution plan analysis, and performance diagnostics.
• Experience administering managed database services including Amazon RDS and Amazon Aurora.
• Hands-on PostgreSQL architecture, schema design, and performance optimization.
• Proven track record migrating on-premises databases to AWS environments using DMS, SCT, or native tools.
• CI/CD integration for database deployments in Agile environments.

Responsibilities

• Collaborate with development teams on data modeling, schema design, and deployment of PL/SQL packages, procedures, triggers, and views.
• Analyze execution plans, tune SQL queries, and optimize index structures to remove bottlenecks in high-throughput environments.
• Lead database release automation, code reviews, and schema migrations across development, staging, and production.
• Monitor database health, resolve deadlocks, and troubleshoot latency issues.
• Partner with infrastructure and cloud teams to design and execute on-premises to AWS migrations.
• Participate in capacity planning, failover drills, and DR design.

Skills

Oracle DBA

PL/SQL

Query Tuning

AWS Cloud

CI/CD

Tools

AWS DMS

SCT

RDS

Aurora

ADDM

Job description

Astra-North Infoteck Inc. in Toronto is seeking an experienced Senior Oracle Application DBA to optimize, scale, and maintain mission-critical database applications, partnering with development and engineering teams to ensure high availability.

You will drive SQL/PL-SQL performance, database modernization, and cloud migration initiatives, including on-premises to AWS migrations and disaster recovery design.