Database Architect — Oracle & PostgreSQL, Cloud Migration

📋 Description

• Own the end-to-end data-tier architecture for enterprise migration and modernization programs
• Design and lead Oracle-to-PostgreSQL migrations, including schema conversion, PL/SQL-to-PL/pgSQL
• Evaluate and defend critical technical choices such as conversion versus rewrite versus retirement
• Design low-downtime migration approaches using CDC replication, dual-run strategies, output
• Personally investigate database performance issues using execution plans, traces, statistics, SQL
• Design database infrastructure covering sizing, high availability, failover, backup and recovery

🎯 Requirements

• 10+ years of experience in database engineering, administration, data platforms, or related
• Deep hands-on knowledge of Oracle and PL/SQL, including packages, procedures, functions, triggers
• Strong production experience with PostgreSQL and PL/pgSQL, including EXPLAIN ANALYZE, indexing
• Proven expertise in both Oracle and PostgreSQL is essential; significant depth in only one database
• Demonstrated experience architecting Oracle-to-PostgreSQL migrations through production, with the
• Strong cloud infrastructure knowledge, ideally within AWS, including RDS, Aurora PostgreSQL, RDS

🎁 Benefits

• Competitive compensation: CAD $160,000–$180,000 per year.
• Retirement savings: RRSP matching program.
• Remote-first environment: Work remotely with flexibility around location.
• Flexible schedule: Flexible working hours designed to support work-life balance.
• Paid parental leave: Parental leave options to support employees and families.
• Health & dental: Employer-paid health and dental premiums.