Database Migration Engineer

Database Migration Engineer TELUS Digital - 3.5 Ontario, CA Job Details Full-time 7 hours ago Qualifications Data migration English Linux PL/SQL Full Job Description Who We Are Welcome to TELUS Digital — where innovation drives impact at a global scale. As an award-winning digital product consultancy and the digital division of TELUS, one of Canada's largest telecommunications providers, we design and deliver transformative customer experiences through cutting-edge technology, agile thinking, and a people-first culture. With a global team across North America, South America, Central America, Europe, Africa, and APAC, we offer end-to-end expertise across various service offerings: Web, Mobile & Digital Marketing | Enterprise AI | Customer Care AI & Technology | Enterprise Technology Modernization From mobile apps and websites to voice UI, chatbots, AI, customer service, and in-store solutions, TELUS Digital enables seamless, trusted, and digitally powered experiences that meet customers wherever they are — all backed by the secure infrastructure and scale of our multi-billion-dollar parent company. Position Overview 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. Project Scope 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 SQL•Plus scripts to psql/PostgreSQL procedures; schema redesign; and ETL orchestration for massive datasets.

Key Responsibilities Code Conversion:

Manually and programmatically translate complex Oracle PL/SQL code (including Packages and Triggers) into high-performance PostgreSQL PL/pg

SQL. 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. Required Qualifications 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. Preferred Skills & Competencies Experience with cloud database services (e.g., GCP CloudSQL). Knowledge of migration tooling (e.g., Ora2Pg).

Analytical Thinking:

Ability to deconstruct complex legacy logic and rebuild it efficiently.

Communication:

Excellent verbal and written communication skills.

Working Conditions Flexibility:

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