Oracle AWS Cloud DBA – Migration & Amazon RDS Specialist

Astra-North Infoteck Inc.; Toronto; Hybrid; CAD 120,000 - 170,000; Full time

Job summary

Astra-North Infoteck Inc. in Toronto seeks an experienced Oracle AWS Cloud DBA to lead migrations to AWS RDS/Aurora and manage Oracle DB environments in a hybrid setup.

The role requires 8–10 years of Oracle DBA experience, strong PL/SQL, and cloud database migration expertise, with on-call support after hours. Hybrid work arrangement with 3 days in-office and occasional weekend/on-call duties are expected.

Qualifications

• 8–10 years of Oracle Database Administration experience.
• Oracle 12c/19c+ application support, advanced PL/SQL programming, execution plan analysis, and performance diagnostics (AWR, ASH, ADDM).
• Experience administering managed database services including Amazon RDS (Oracle/PostgreSQL) and Amazon Aurora.
• Hands-on PostgreSQL architecture, schema design, and performance optimization.
• Cloud migration experience to AWS environments using DMS, SCT, or native utilities.
• CI/CD integration for database deployments alongside Agile engineering teams.
• Ability to work with offshore teams for maintenance and production support.

Responsibilities

• Collaborate with application development teams on data modeling, schema design, and deployment of complex PL/SQL packages, procedures, triggers, and views.
• Analyze execution plans, perform SQL query tuning, and optimize index structures to eliminate bottlenecks in high-throughput transactional environments.
• Lead database release automation, code reviews, and schema migrations across development, staging, and production environments.
• Monitor database application health, identify lock contention, resolve deadlocks, and troubleshoot latency issues.
• Partner with infrastructure and cloud teams to design, test, and execute on-premises to AWS cloud database migrations.
• Participate in database capacity planning, failover drills, and disaster recovery design.
• Support production deployment and other maintenance activities over weekends and after office hours on weekdays, as needed.

Skills

Data modeling

Schema design

PL/SQL development

Query tuning

CI/CD for DB deployments

Cloud migrations

Offshore collaboration

Tools

Amazon RDS

Amazon Aurora

SCT

AWS DMS

AWR/ASH/ADDM

Job description

Oracle AWS Cloud DBA – Migration & Amazon RDS Specialist

Location: Toronto, ON

Work Arrangement: Hybrid (3 Days WFO)

Experience Required: 8–10 Years

Role Descriptions

• Collaborate with application development teams on data modeling, schema design, and deployment of complex PL/SQL packages, procedures, triggers, and views.
• Analyze execution plans, perform SQL query tuning, and optimize index structures to eliminate bottlenecks in high-throughput transactional environments.
• Lead database release automation, code reviews, and schema migrations across development, staging, and production environments.
• Monitor database application health, identify lock contention, resolve deadlocks, and troubleshoot latency issues.
• Partner with infrastructure and cloud teams to design, test, and execute on-premises to AWS cloud database migrations.
• Participate in database capacity planning, failover drills, and disaster recovery design.
• Support production deployment and other maintenance activities over weekends and after office hours on weekdays, as needed.

Required Experience

• 8–10 years of experience in Oracle Database Administration.
• Oracle Application DBA Expertise: 8 years specializing in Oracle Database (12c/19c+) application support, advanced PL/SQL programming, execution plan analysis, and performance diagnostics (AWR, ASH, ADDM).
• AWS & Cloud Databases: Practical experience administering managed database services, including Amazon RDS (Oracle/PostgreSQL) and Amazon Aurora.
• PostgreSQL: Hands-on working knowledge of PostgreSQL architecture, schema design, and performance optimization.
• Cloud Migration Experience: Strong, proven track record of migrating on-premises databases to AWS environments using tools such as AWS DMS, SCT, or native utilities.
• Collaboration & Release Management: Solid background in CI/CD integration for database deployments and working alongside Agile engineering teams.
• Ability to work with offshore teams for maintenance and production support activities.

Nice-to-Have Skills

• Experience with Oracle Exadata administration and performance tuning features (Smart Scan, Hybrid Columnar Compression).
• Proficiency in shell scripting (Bash) and automation using Python.
• Relevant AWS (e.g., AWS Certified Database – Specialty) or Oracle certifications.