Haystack
← Back to Jobs
Technology
TS

Data Engineer – Oracle to PostgreSQL Migration

Tanisha Systems, Inc.East Brunswick, NJ🇺🇸United StatesPosted 30 Jul 2026

Quick Overview

Seniority
Mid Senior
Work mode
On Site
Location
East Brunswick, NJ, United States
Posted
4 weeks ago
OraclePL/SQLSQLShellAWSAzureGitGoogle CloudPostgreSQLPython

Job Description

Data Engineer – Oracle to PostgreSQL Migration
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, Google Cloud Platform 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.

Similar jobs

Browse related jobs

Apply now