Senior Oracle DBA — Cloud Migrations & Performance

Realign Llc; Toronto; Hybrid; CAD 110,000 - 150,000; Full time

Job summary

Realign Llc in Toronto, ON, is seeking an experienced Oracle DBA for a hybrid role. You will manage Oracle 12c/19c+ environments, optimize performance, and lead deployment automation with CI/CD practices.

You will work closely with cloud, infrastructure, and development teams to migrate on-premises databases to AWS, perform DR planning, and support production activities, including weekend maintenance as needed.

Qualifications

• 8-10 years of experience in Oracle Database Administration.
• Expertise in Oracle Database (12c/19c+) application support and PL/SQL.
• Experience with AWS cloud databases and on-premises to AWS migrations.
• Strong CI/CD collaboration and offshore/support experience.

Responsibilities

• Collaborate 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 for high-throughput environments.
• Lead database release automation, code reviews, and schema migrations across environments.
• Monitor health, resolve deadlocks, and troubleshoot latency; support capacity planning and DR design.
• Engage with offshore teams for maintenance and production support activities.

Skills

Oracle DBA

PL/SQL

Shell scripting

Python

AWS

DMS

SCT

Tools

AWS RDS

Oracle Exadata

AWS SCT

Job description

Realign Llc in Toronto, ON, is seeking an experienced Oracle DBA for a hybrid role. You will manage Oracle 12c/19c+ environments, optimize performance, and lead deployment automation with CI/CD practices.

You will work closely with cloud, infrastructure, and development teams to migrate on-premises databases to AWS, perform DR planning, and support production activities, including weekend maintenance as needed.