Job Description
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...