TX or CA location- Data Engineer – Oracle to PostgreSQL Migration

Confidential; Town of Texas (WI); On-site; USD 120,000 - 160,000; Full time

Job summary

Confidential is seeking a Data Engineer to lead Oracle to PostgreSQL migrations onsite in Sunnyvale, CA and Austin, TX. You will own end-to-end activities from assessment to cutover, mapping Oracle constructs to PostgreSQL and validating data integrity.

You will work with migration tools and cloud database services, optimize performance, and collaborate with application teams to update queries and configurations. 5+ years in DB engineering with Oracle migration experience is expected.

Qualifications

• 5+ years of overall database engineering/DBA experience.
• 3+ years hands-on Oracle-to-PostgreSQL migration projects.
• Strong command of Oracle (PL/SQL, RMAN, Data Pump) and PostgreSQL (PL/pgSQL, extensions, vacuum).
• Experience with migration tools: Ora2Pg, AWS SCT, AWS DMS, EDB Postgres Migration Toolkit, Google DMS.
• Solid understanding of Oracle vs PostgreSQL differences and compatibility.

Responsibilities

• Assess Oracle databases to determine migration complexity and approach.
• Perform schema and object conversion from Oracle to PostgreSQL using migration tools.
• Convert PL/SQL procedures, functions, triggers, and packages to PostgreSQL PL/pgSQL.
• Design data migration/validation strategies with minimal data loss.
• Identify incompatibilities and remediate data types, sequences, and partitioning.
• Optimize PostgreSQL performance post-migration (indexing, vacuum, connection pooling).
• Collaborate with application teams to update SQL, ORM configurations, and drivers.
• Plan and execute cutover strategy including rollback and go-live support.
• Document runbooks, decisions, and lessons learned.

Skills

Oracle

PostgreSQL

SQL

PL/pgSQL

Shell scripting

Python

DMS

Ora2Pg

AWS SCT

ETL

Tools

Ora2Pg

AWS SCT

AWS DMS

EDB Postgres Migration Toolkit

Google DMS

Job description

Data Engineer – Oracle to PostgreSQL Migration

Sunnyvale, CA/ Austin, TX (Onsite)

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.