Sign upLog in
See more jobs

Oracle to PostgreSQL Migration Consultant

Tanisha Systems

  • Sunnyvale, CA/ Austin, TX (Onsite), TX
  • 1 day ago
    Want to know if you’re a fit?
    Upload your resume and let our AI show you.

    Skills

    • Amazon Relational Database Service (RDS)unmatched
    • Amazon Web Services (AWS)unmatched
    • Automationunmatched
    • Centers for Disease Control and Prevention (CDC)unmatched
    • Cloud Computingunmatched
    • Consultingunmatched
    • Continuous Deployment/Deliveryunmatched
    • Continuous Integrationunmatched
    • Data Migrationunmatched
    • Data Qualityunmatched
    • Database Administrationunmatched
    • Database Analysisunmatched
    • Database Programmingunmatched
    • Database Technologyunmatched
    • Error Handlingunmatched
    • GCP (Good Clinical Practices)unmatched
    • Gitunmatched
    • JDBC (Java Database Connectivity)unmatched
    • Microsoft Windows Azureunmatched
    • Migration Strategyunmatched
    • ODBC (Open Database Connectivity)unmatched
    • Object Relational Mapping (ORM)unmatched
    • Oracleunmatched
    • Oracle Databaseunmatched
    • Oracle PL-SQLunmatched
    • Performance Tuning/Optimizationunmatched
    • PostgreSQLunmatched
    • Problem Solving Skillsunmatched
    • Pumpsunmatched
    • Python Programming/Scripting Languageunmatched
    • RMANunmatched
    • Reconciliationunmatched
    • Replication and Remote Mirroringunmatched
    • SQL (Structured Query Language)unmatched
    • Scripting (Scripting Languages)unmatched
    • Software Administrationunmatched
    • Source Code/Configuration Management (SCM)unmatched
    • Strategic Planningunmatched
    • Unix Shell Programmingunmatched

    Description

    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.

    Numbers & Facts

    LocationSunnyvale, CA/ Austin, TX (Onsite), TX

    Resume Resources

    Free Resume TemplatesFree Resume Builder

    Similar Jobs

    See more jobs