Apply Now

Oracle to PostgreSQL Migration Consultant

East Brunswick, NJ, US • Posted 4 hours ago • Updated 42 minutes ago

Full Time

On-site

Depends on Experience

Fitment

Dice Job Match Score™

🛠️ Calibrating flux capacitors...

Job Details

Skills

DATA ENGINEER – ORACLE TO POSTGRESQL MIGRATION

Summary

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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10117909
Position Id: 26-17142
Posted 4 hours ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Parsippany-Troy Hills, New Jersey

•

28d ago

Job Description Sr. Data Architect / Oracle Cloud Infrastructure (OCI) Migration Lead Location: Parsippany, NJ (On-site) Position Overview We are seeking a highly experienced Sr. Data Architect / OCI Migration Lead to drive the successful execution of a large-scale data platform migration to Oracle Cloud Infrastructure (OCI). This is a hands-on technical leadership role requiring deep expertise in cloud data architectures, database migration, ETL/ELT optimization, and enterprise data engineerin

Easy Apply

Full-time, Third Party

Depends on Experience

Oracle Database Engineer

Berkeley Heights, New Jersey

•

Today

Location: Berkeley Heights, New Jersey Type: Contract Job #104878 Job Title: Oracle Database Engineer Location: Berkeley Heights, New Jersey(Onsite) Duration:-5 months contract to hire W2 Only Pay Rate Range :- $50-70 /hr(W2 Only) Job Responsibilities The Senior Database Administrator designs, installs, maintains and upgrades the enterprise's production databases. Provides technical expertise in the use of database technology. Accountable for the overall performance of the enterprise's database

Full-time

USD 50.00 - 70.00 per hour

Principal Database Engineer

Hybrid in Jersey City, New Jersey

•

Today

Are you ready to make an impact at DTCC? Do you want to work on innovative projects, collaborate with a dynamic and supportive team, and receive investment in your professional development? At DTCC, we are at the forefront of innovation in the financial markets. We are committed to helping our employees grow and succeed. We believe that you have the skills and drive to make a real impact. We foster a thriving internal community and are committed to creating a workplace that looks like the world

Full-time

Senior Data Reliability Engineer

Bridgewater, New Jersey

•

Today

Profile: Senior Data Reliability Engineer Location: NJ (Onsite) Skills Deep expertise in PostgreSQL administration and performance tuning, preferably in AWS RDS environments. Strong experience with Debezium, Kafka Connect, ETL frameworks/tools, and enterprise-grade data pipeline architectures. Strong hands-on experience with Amazon Redshift, S3, and cloud-native data platforms. Expertise in Apache Airflow workflow orchestration and operational management. Experience with Apache Spark and large-

Easy Apply

Third Party

$DOE

Search all similar jobs

More jobs at Tanisha Systems, Inc. in East Brunswick, NJ

Oracle to PostgreSQL Migration Consultant

Dice Job Match Score™

Job Details

Skills

Summary

Similar Jobs