Database Migration Engineer

TELUS Digital

Database Migration Engineer at TELUS Digital, migrating enterprise databases from Oracle to PostgreSQL. Collaborating with global teams to ensure performance parity and operational excellence.

Posted 5/6/2026full-timeRemote • 🇨🇦 CanadaMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

ETLLinuxOraclePostgresPythonShell ScriptingSQL

About the role

Key responsibilities & impact

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.

Requirements

What you’ll need

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.

Benefits

Comp & perks

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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Oracle PL/SQLPostgreSQL PL/pgSQLETL logicData WarehousePerformance TuningAdvanced SQLShell scriptingBashPythonData Integrity

Soft Skills

CollaborationDocumentation