Search Jobs | Dice.com

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 5 hours ago

Fitment

Dice Job Match Score™

✨ Finding the perfect fit...

Create job alert

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

Similar Jobs

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

Data Engineer

Hybrid in Bernards, New Jersey

•

13d ago

Role : Data engineer with PostgresSQLLocation : Basking ridge, NJ(Hybrid) Look for a Data Engineer who has worked with Postgres SQL as source of data and has built data pipelines using AWS services. Job Description As a Data Reliability Engineer II, you will play a crucial role in developing, optimizing, and managing several large data lakes and data warehouses, comprising data from multiple disparate sources. Responsibilities: Need data engineer with extensive experience in PostgresSQL, and AWS

Easy Apply

Contract, Third Party

60 - 63

Filter Results

Job post features

Posted date

Work settings

Employment type

Distance

Employer type

Work authorization

Oracle to PostgreSQL Migration Consultant

Skills

Summary

Dice Job Match Score™

Similar Jobs

Oracle to PostgreSQL Migration Consultant

Job Details

Skills

Summary

Dice Job Match Score™

Similar Jobs