Oracle to PostgreSQL Migration Consultant

Oracle to PostgreSQL Migration Consultant
Location: Sunnyvale, CA/ Austin, TX (Onsite)
FTE/Fulltime
Salary : Market- based on exp
Rate: Market- based on exp

CANDIDATE SHOULD HAVE PYTHON CODING EXPERIENCE AND ORACLE TO POSTGRESQL MIGRATION EXPERIENCE

Job Description
We are seeking an experienced Data Engineer with proven, hands-on expertise in migrating enterprise database workloads from Oracle to PostgreSQL. The ideal candidate will lead/support end-to-end migration activities including assessment, schema conversion, data migration, application compatibility, performance tuning, and cutover planning.
Key Responsibilities

• Assess existing Oracle databases (schema, PL/SQL objects, indexes, partitioning, triggers, jobs) to determine migration complexity and approach.
• Perform schema and object conversion from Oracle to PostgreSQL using tools such as AWS SCT/DMS, Ora2Pg, EDB Migration Toolkit, or custom scripts.
• Convert PL/SQL procedures, functions, triggers, and packages to PostgreSQL PL/pgSQL, resolving syntax and behavioral differences.
• Design and execute data migration/validation strategies (full load, incremental/CDC, reconciliation) ensuring zero/minimal data loss.
• Identify and remediate incompatibilities (data types, sequences, materialized views, partitioning strategies, error handling, connection pooling).
• Optimize PostgreSQL performance post-migration (indexing strategy, query tuning, vacuum/autovacuum, connection pooling via PgBouncer, partitioning).
• Collaborate with application teams to update SQL queries, ORM configurations, and connection strings/drivers (JDBC/ODBC/psycopg2).
• Plan and execute cutover strategy including rollback plans, downtime minimization, and go-live support.
• Document migration runbooks, technical decisions, and lessons learned.

Required Skills & Experience

• 5 years of overall database engineering/DBA experience; 3 years hands-on with Oracle-to-PostgreSQL migration projects (not just theoretical knowledge).
• Strong command of Oracle (PL/SQL, RMAN, Data Pump, performance tuning) and PostgreSQL (PL/pgSQL, extensions, vacuum internals, replication).
• Practical experience with migration tools: Ora2Pg, AWS SCT, AWS DMS, EDB Postgres Migration Toolkit, Google DMS, or equivalent.
• Solid understanding of differences between Oracle and PostgreSQL (sequences, ROWID vs CTID, NVL vs COALESCE, hierarchical queries CONNECT BY vs recursive CTEs, autonomous transactions, packages, etc.).
• Experience with data validation/reconciliation frameworks to ensure migration accuracy.
• Familiarity with cloud database services (AWS RDS/Aurora PostgreSQL, Azure, GCP Cloud SQL) is a plus.
• Scripting skills in Shell, Python for automation of migration tasks.
• Experience with CI/CD pipelines and version control (Git) for schema/code management.
• Strong problem-solving skills and ability to work with minimal supervision on complex legacy systems.