Description

Job Description:-

Key Responsibilities

• Code Conversion: Manually and programmatically translate complex Oracle PL/SQL code (including Packages and Triggers) into high-performance PostgreSQL PL/pgSQL.
• 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.

Key Skills

Education

Any Graduate