Description

You will lead the manual and programmatic migration of complex Oracle PL/SQL codebases into PostgreSQL.

This role is on-site.

Responsibilities

• Translate Oracle PL/SQL packages and triggers into high-performance PostgreSQL PL/pgSQL.
• Re-engineer complex Data Warehouse ETL logic for PostgreSQL optimization.
• Migrate data types, constraints, and indexes while leveraging PostgreSQL architectural strengths.
• Resolve performance bottlenecks using query plan analysis and advanced indexing strategies.
• Develop rigorous validation scripts to ensure 100% data consistency between source and target systems.

Required Skills

• 5+ years of experience with Oracle 12c/19c and deep PL/SQL proficiency.
• 3+ years of experience developing in PostgreSQL PL/pgSQL.
• Proven track record of at least one full-lifecycle Oracle to PostgreSQL migration.
• Mastery of ANSI SQL and deep knowledge of Oracle vs. Postgres dialect nuances.
• Proficiency in Shell scripting (Bash) or Python for automation.
• Fluency in English is required.

Preferred Skills

• Experience with cloud database services such as GCP CloudSQL.
• Knowledge of migration tooling like Ora2Pg.

Key Skills

Education

Any Graduate