🛠 Tech Stack

💼 About This Role

You'll lead migrating a large-scale enterprise database from Oracle to PostgreSQL, refactoring PL/SQL to PL/pgSQL for performance parity. You'll ensure data integrity and operational excellence. This role offers the chance to work with cutting-edge technology at TELUS Digital.

🎯 What You'll Do

• Manually translate Oracle PL/SQL packages to PostgreSQL PL/pgSQL
• Re-engineer Data Warehouse ETL logic for PostgreSQL
• Optimize schema design and perform performance tuning
• Develop validation scripts to ensure data consistency

📋 Requirements

• 5+ years of Oracle (12c/19c) with deep PL/SQL proficiency
• 3+ years of PostgreSQL development in PL/pgSQL
• Proven full-lifecycle Oracle to PostgreSQL migration experience
• Advanced ANSI SQL knowledge and dialect nuances

✨ Nice to Have

• Experience with cloud database services like GCP CloudSQL
• Knowledge of migration tooling like Ora2Pg
• Strong analytical and communication skills

🎁 Benefits & Perks

• 🏥 Private medical and life insurance from day one
• 📚 Budget for professional growth (certifications)
• ⏰ Schedule flexibility
• 💰 Extra bonus based on performance

📨 Hiring Process

Estimated timeline: 2-3 weeks · AI estimate

1. 1Recruiter Screen· 30 min
2. 2Technical Interview· 60 min
3. 3Hiring Manager Interview· 45 min