Database Migration Engineer

TELUS Digital

3d • Remote

About The Position

We are seeking two highly skilled Database Migration Engineers for a critical, long-term (2-year) project focused on migrating a large-scale enterprise database environment from Oracle to PostgreSQL. The environment includes both OLTP and Data Warehouse (OLAP) components. The primary focus of this role is the manual and programmatic refactoring of a significant codebase from PL/SQL to PL/pgSQL, ensuring performance parity, data integrity, and operational excellence.

The bulk of the work involves the conversion of programming logic between database dialects. This includes converting legacy Oracle packages, stored procedures, functions, and triggers to PostgreSQL equivalents; transitioning SQLPlus scripts to psql/PostgreSQL procedures; schema redesign; and ETL orchestration for massive datasets.

Requirements

• 5+ years of experience (12c/19c) with deep proficiency in PL/SQL.
• 3+ years of experience developing in PL/pgSQL.
• Proven track record of at least one full-lifecycle Oracle to PostgreSQL migration.
• Mastery of ANSI SQL and deep knowledge of the nuances between Oracle and Postgres dialects.
• Proficiency in Shell scripting (Bash) or Python for automation.
• Fluency in English is required.

Nice To Haves

• Experience with cloud database services (e.g., GCP CloudSQL).
• Knowledge of migration tooling (e.g., Ora2Pg).
• Ability to deconstruct complex legacy logic and rebuild it efficiently.
• Excellent verbal and written communication skills.
• French is a strong asset.

Responsibilities

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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed