Senior Database Migration Engineer Role (Winnipeg)

Join TELUS Digital as a Senior Database Migration Engineer, focusing on migrating systems from Oracle to PostgreSQL. This long-term project requires advanced PL/SQL and PL/pgSQL skills.

In this hands-on role, you will manage a large-scale database setting migration, which includes refactoring codebases for optimal performance. You’ll collaborate with cross-functional teams, ensuring data integrity and enhancing ETL processes. Your expertise will be crucial to successfully redesigning schemas and executing rigorous validation scripts.

Key Responsibilities

• Convert Oracle PL/SQL packages to PostgreSQL equivalents
• Refactor ETL logic for PostgreSQL efficiency
• Upgrade schemas while optimizing constraints and data types
• Performance tuning through query plan analysis
• Execute validation scripts for data integrity

Requirements

• 5+ years of Oracle experience with PL/SQL proficiency
• 3+ years i...