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.
Data Engineer – Oracle to PostgreSQL Migration • Sunnyvale, CA, United States
A leading technology company in Santa Clara seeks a Senior Software Engineer to architect and build next-gen authorization services.The ideal candidate will have over 5 years of experience in backe... Show more
Cloud Migration Project Manager.NEED candidates with cloud migration experience - MUST HAVEjira and confluence are required as wellservicenow nice to have.Required Skills/Qualifications/Experience:... Show more
Tech Lead Manager, Google Analytics Gold Processing Backend.Google's software engineers develop the next-generation technologies that change how billions of users connect, explore, and interact wit... Show more
Certified Databricks ConsultantLocation:TX/GA/CADuration:Long-termClient:IBM/AT&TSkills:Need certified Databricks consultant with good experience in Spark and PySpark.Experience with Azure, Pyt... Show more
OverviewJob Title :Databricks ArchitectDatabricks Architect with expertise in building scalable data solutions on AWSResponsibilitiesSupply Chain, Consumer Goods / Retail domain knowledge required.... Show more
Jade Global | US-based | Reports to: Global Oracle SL Leader.The Oracle and NetSuite GTM and Alliance Leader owns the end-to-end go-to-market motion and partnership strategy for Jade Global's Oracl... Show more
Locations negotiable (fulltime travelling position with client).Locations include IL - Chicago, IN - Indianapolis, MI - Detroit, MN - Minneapolis, MN - St Paul, OH - Cincinnati, OH - Columbus - Cle... Show more
This role provides technical leadership in designing and optimizing ETL/ELT frameworks using Azure data services (Fabric, Data Lake, Data Factory), integrating data from ERP, CRM, and operational s... Show more
Job DescriptionJob DescriptionCompany DescriptionEnterprise Solution Architect - Master Data & Governance (Remote / Hybrid - Bay Area Preferred)Our client is a high-growth technology company tr... Show more
The Enterprise AI team helps Lam scale responsible, secure, and high-value use of AI across the company.The team works across enterprise AI platforms, developer tools, data and knowledge platforms,... Show more
Data EngineerLocation:San Ramon, CA (100% Onsite)Duration:6-12 MonthsPositions:2Start Date:1/9/23Job Description:Integrate, extract the data using ETL and inject using AWS, build pipeline from AWS ... Show more
We are seeking a senior expert in financial technology solutions for a contract position in the Sunnyvale region.This role involves strategic development and process transformation, with a focus on... Show more
Azure / Cloud Architect Data bricks LINUX Santa Clara, Ca.Prior experience with Databricks integration work, Unity Catalog,.Experience with enterprise Linux service packaging, systemd, and.Prior wo... Show more
Data Solution ArchitectLocation:Contract - Long Term, Dublin, CAType:Hybrid 3 days in Onsite RoleNeed & Responsibilities:The position is for a Solution Data Architect focused on the SVT (Single... Show more
A consulting firm is seeking a Principal Hadoop Architect to lead the optimization of a large-scale Big Data ecosystem.This role involves defining design standards and ensuring a highly optimized o... Show more
Oracle EPM Cloud - Techno-Functional Consultant.Were looking for Techno-Functional, Functional or solution Architect with expertise in Oracle EPM Cloud to join our Consulting practice where we prov... Show more
Senior Software Engineer - Data InfrastructureApplied Intuition, Inc.Founded in 2017 and now valued at $15 billion, the Silicon Valley company is creating the digital infrastructure needed to bring... Show more
Position: Battery Data Engineer III Location: Cupertino, California Duration: Contract Job ID: 171364 Job Description: This will be a data engineer role for processing battery testing data to facil... Show more
Lead end-to-end data conversion activities across all phases: strategy, mapping, extraction, transformation, validation, and loading into Oracle Fusion.Work closely with business and functional tea... Show more
Marketing Technology Team PositionThe Marketing Technology team has the mandate of increasing the rate of customer acquisition, retention, and revenue by optimizing products and inventing new marke... Show more
