Senior Database Migration Engineer Role Edmonton

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 workplace 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 in PostgreSQL with PL/pgSQL skills • Experience in a full Oracle to PostgreSQL migration • Mastery of ANSI SQL nuances • Proficient in scripting with Shell or Python Enhance your career as a senior database expert with TELUS Digital, making a significant impact on our migration efforts. J-18808-Ljbffr Apply on Kit Job: kitjob.ca/job/2ng9dr