Oracle Application DBA (AWS Cloud Migration)

Position: Oracle Application DBA (AWS Cloud Migration)

Location: Hybrid- Toronto, ON

Job type: Full-time/Permanent hiring

As the Oracle Application DBA & Cloud Migration Engineer, you will act as the core bridge between database administration, enterprise application development, and modern cloud architecture. This is a highly technical role requiring 8–10 years of robust Oracle Database Administration experience, featuring deep specialization in Oracle 12c/19c+ application support, advanced PL/SQL engineering, and high-scale performance tuning. You will not simply manage database installations; you will collaborate directly with engineering teams to optimize transactional code, lead database CI/CD release automation, and spearhead complex on-premises migrations to AWS cloud environments (Amazon RDS & Aurora).

Key Responsibilities

• Application Data Engineering: Collaborate daily with application development teams on physical data modeling, database schema designs, and the development/deployment of complex PL/SQL packages, procedures, triggers, and views.
• Performance Tuning & Diagnostics: Deeply analyze database execution plans, perform advanced SQL query tuning, and optimize complex index structures using AWR, ASH, and ADDM to eliminate bottlenecks in high-throughput transactional environments.
• Database Release Automation: Lead database release automation strategies, conduct comprehensive database code reviews, and manage schema migrations across all Dev, Staging, and Production environments using CI/CD pipelines.
• Production Telemetry & Troubleshooting: Monitor runtime database application health, identify lock contentions, proactively resolve deadlocks, and troubleshoot complex system latency issues.
• AWS Cloud Migrations: Partner closely with infrastructure and cloud engineering teams to design, test, and execute seamless on-premises to AWS cloud database migrations.
• Resiliency & Capacity Management: Participate actively in database capacity planning, architectural failover drills, and disaster recovery design strategy.
• Global Operations & Support: Coordinate efficiently with offshore teams for maintenance and production support activities. Provide support for critical production deployments and maintenance windows during weekend or "after-office" hours as required.

Required Qualifications

• Total Seniority: 8–10 years of dedicated, hands-on experience in Oracle Database Administration.
• Application DBA Specialization: 8+ years explicitly focused on Oracle Database (12c/19c+) application support, advanced PL/SQL programming, execution plan analysis, and system diagnostics.
• AWS Cloud Infrastructure: Practical administrative experience managing cloud-native database services, specifically Amazon RDS (Oracle/PostgreSQL) and Amazon Aurora.
• PostgreSQL Ecosystem: Concrete working knowledge of PostgreSQL architecture, schema design models, and query performance optimization.
• Migration Track Record: Proven experience migrating large-scale on-premises databases to AWS cloud ecosystems using utilities like AWS DMS (Database Migration Service), SCT (Schema Conversion Tool), or native export tools.
• CI/CD & Delivery: Strong background integrating database schema changes into automated CI/CD deployment pipelines within Agile engineering teams.

Preferred Skills (Added Advantage)

• Hands-on experience with Oracle Exadata administration and optimization features (Smart Scan, Hybrid Columnar Compression / HCC).
• Proficiency in infrastructure automation using Shell Scripting (Bash) and Python.
• Active professional certifications: AWS Certified Database – Specialty or advanced Oracle credentials.