Code Conversion: Manually and programmatically translate complex Oracle PL/SQL code (including Packages and Triggers) into high-performance PostgreSQL PL/pgSQL.
ETL Refactoring: Re-engineer complex Data Warehouse ETL logic for optimal performance in a PostgreSQL environment.
Schema Migration: Translate data types, constraints, and indexes while optimizing for PostgreSQL’s architectural strengths.
Performance Tuning: Identify and resolve bottlenecks in the migrated code using query plan analysis and advanced indexing.
Data Integrity: Develop and execute rigorous validation scripts to ensure 100% data consistency between source and target systems.
Collaboration: Work as part of a high-capability development team, reporting to the Team Lead and coordinating with application developers.
Documentation: Maintain detailed documentation of architectural changes and mapping logic.

Expertise in Oracle: 5+ years of experience (12c/19c) with deep proficiency in PL/SQL.
Expertise in PostgreSQL: 3+ years of experience developing in PL/pgSQL.
Migration Experience: Proven track record of at least one full-lifecycle Oracle to PostgreSQL migration.
Advanced SQL: Mastery of ANSI SQL and deep knowledge of the nuances between Oracle and Postgres dialects.
Linux/Scripting: Proficiency in Shell scripting (Bash) or Python for automation.
Languages: Fluency in English is required; French is a strong asset.

Flexibility: Willingness to maintain at least 4 hours of overlap with the team based in Montreal (Eastern Time Zone).

Database Migration Engineer

Key skills