Apply Now!

Senior Software Engineer - Postgress

Mumbai, India

3 PostgreSQL Experts with the following skillset. 

 

Experience Level

5+ years (Relevant experience in large-scale database migrations required)

 

Overview

Experienced Oracle to PostgreSQL Migration Specialist to support the migration of enterprise-grade database backends from Oracle 19c to PostgreSQL (Cloud SQL v18). The role requires deep hands-on expertise in PL/SQL to PL/pgSQL refactoring, migration tooling (specifically ora2pg), performance tuning, and end-to-end validation to ensure functional parity and production readiness.

The ideal candidate will have a strong track record of handling complex Oracle constructs, resolving compatibility gaps, and delivering high-quality migrations in cloud environments.

 

Responsibilities

  • Lead and execute database migrations from Oracle 19c to PostgreSQL (Cloud SQL v18).
  • Analyze, optimize, and correct ora2pg outputs to meet PostgreSQL standards and performance expectations.
  • Refactor PL/SQL code to PL/pgSQL, including:
    • Rewriting unsupported Oracle features (packages, sequences, triggers, cursors, hints, etc.)
    • Adapting and optimizing dynamic SQL
    • Resolving data type, function, and syntax incompatibilities
  • Address Oracle-specific constructs and redesign them using PostgreSQL-native capabilities.
  • Perform query optimization and performance tuning post-migration.
  • Validate data integrity and functional parity between Oracle and PostgreSQL environments.
  • Execute and support unit testing, regression testing, and end-to-end testing.
  • Troubleshoot complex migration defects and performance issues.
  • Collaborate with application, cloud, and DevOps teams during migration and cutover phases.

Required Skills & Qualifications

  • 5+ years of hands-on experience in Oracle database development and migration.
  • Proven experience migrating Oracle 19c PL/SQL backends to PostgreSQL.
  • Strong expertise in:
    • PL/SQL and PL/pgSQL
    • ora2pg (deep understanding beyond default tooling output)
    • Oracle schemas, packages, procedures, functions, triggers, and views
  • Solid understanding of PostgreSQL internals, indexing strategies, and performance tuning.
  • Experience resolving Oracle-to-PostgreSQL compatibility gaps.
  • Strong SQL performance analysis and optimization skills.
  • Experience with data validation, reconciliation, and testing frameworks.
  • Familiarity with cloud-managed PostgreSQL services (preferably Google Cloud SQL).
  • Ability to work independently and take ownership of migration deliverables.

Nice to Have

  • Experience with other migration tools or frameworks in addition to ora2pg.
  • Exposure to CI/CD pipelines for database deployments.
  • Experience in regulated or enterprise-scale environments.
  • Knowledge of Oracle licensing and decommissioning considerations.

 



Apply Now!
Apply Now!

Senior Software Engineer - Postgress

Mumbai, India

3 PostgreSQL Experts with the following skillset. 

 

Experience Level

5+ years (Relevant experience in large-scale database migrations required)

 

Overview

Experienced Oracle to PostgreSQL Migration Specialist to support the migration of enterprise-grade database backends from Oracle 19c to PostgreSQL (Cloud SQL v18). The role requires deep hands-on expertise in PL/SQL to PL/pgSQL refactoring, migration tooling (specifically ora2pg), performance tuning, and end-to-end validation to ensure functional parity and production readiness.

The ideal candidate will have a strong track record of handling complex Oracle constructs, resolving compatibility gaps, and delivering high-quality migrations in cloud environments.

 

Responsibilities

  • Lead and execute database migrations from Oracle 19c to PostgreSQL (Cloud SQL v18).
  • Analyze, optimize, and correct ora2pg outputs to meet PostgreSQL standards and performance expectations.
  • Refactor PL/SQL code to PL/pgSQL, including:
    • Rewriting unsupported Oracle features (packages, sequences, triggers, cursors, hints, etc.)
    • Adapting and optimizing dynamic SQL
    • Resolving data type, function, and syntax incompatibilities
  • Address Oracle-specific constructs and redesign them using PostgreSQL-native capabilities.
  • Perform query optimization and performance tuning post-migration.
  • Validate data integrity and functional parity between Oracle and PostgreSQL environments.
  • Execute and support unit testing, regression testing, and end-to-end testing.
  • Troubleshoot complex migration defects and performance issues.
  • Collaborate with application, cloud, and DevOps teams during migration and cutover phases.

Required Skills & Qualifications

  • 5+ years of hands-on experience in Oracle database development and migration.
  • Proven experience migrating Oracle 19c PL/SQL backends to PostgreSQL.
  • Strong expertise in:
    • PL/SQL and PL/pgSQL
    • ora2pg (deep understanding beyond default tooling output)
    • Oracle schemas, packages, procedures, functions, triggers, and views
  • Solid understanding of PostgreSQL internals, indexing strategies, and performance tuning.
  • Experience resolving Oracle-to-PostgreSQL compatibility gaps.
  • Strong SQL performance analysis and optimization skills.
  • Experience with data validation, reconciliation, and testing frameworks.
  • Familiarity with cloud-managed PostgreSQL services (preferably Google Cloud SQL).
  • Ability to work independently and take ownership of migration deliverables.

Nice to Have

  • Experience with other migration tools or frameworks in addition to ora2pg.
  • Exposure to CI/CD pipelines for database deployments.
  • Experience in regulated or enterprise-scale environments.
  • Knowledge of Oracle licensing and decommissioning considerations.

 



Apply Now!