App
Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Oracle to PostgreSQL Migration Consultant

Tanisha Systems

East Brunswick, NJ

Job Description

Job 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 PostgreSQ L. 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.
Apply
Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Oracle to PostgreSQL Migration Consultant in East Brunswick, NJ vacancy
  • Senior Java Technical Lead - RESTful API, Spring Boot
     ...driven solutions • Support payment modernization and cloud migration initiatives • Collaborate with cross-functional teams...  ...Microservices • Kafka, IBM MQ, Event-Driven Architecture • Oracle/PostgreSQL/MongoDB • OpenShift, Kubernetes, Docker • CI/CD, Jenkins... 
    Postgresql
    Oracle
    Full time

    Qualis1 Inc.

    Edison, NJ
    1 day ago
  • Database SME. Senior Infrastructure Lead
     ...and optimizing various databases such as MS-SQL, SQL Server, Oracle, PostgreSQL, etc.Extensive experience in troubleshooting, resolving, and...  ...solutions for critical systems.Leads and oversees database migrations, upgrades, and consolidations, ensuring smooth transitions with... 
    Postgresql
    Oracle
    Work experience placement

    HAN Staffing

    Iselin, NJ
    2 days ago
  • Solution Architect .Net
     ...database technologies such as RDBMS (using any of SQL Server, Oracle, PostgreSQL, MongoDB), Entity Framework, and LINQ. Deep understanding of...  ...solution design Must have worked in Re-engineering, migration and support projects by providing technical architecture guidance... 
    Postgresql
    Oracle
    Work experience placement

    HAN Staffing

    Iselin, NJ
    2 days ago
  • Java Full Stack Developer

    $77k

     ...driven solutions • Support payment modernization and cloud migration initiatives • Collaborate with cross-functional teams...  ...Microservices • Kafka, IBM MQ, Event-Driven Architecture • Oracle/PostgreSQL/MongoDB • OpenShift, Kubernetes, Docker • CI/CD, Jenkins... 
    Postgresql
    Oracle
    Full time
    Local area

    HCLTech

    Edison, NJ
    5 hours ago
  • Sr. Full Stack Software Engineer
     .../metrics/alarms).Data layer expertise:AWS Aurora PostgreSQL: advanced SQL, indexing, query optimization, migrations, and transactional design.AWS Neptune: gremlin, graph...  ...SLOs/SLIs.Prior experience integrating with Oracle HCM.Screening Guidance (please follow strictly):Mandatory... 
    Postgresql
    Oracle
    Contract work
    Local area

    HAN Staffing

    Iselin, NJ
    4 days ago
  • Lead Java Developer (Payments domain)
     ...solutions \n \n • Support payment modernization and cloud migration initiatives \n \n • Collaborate with cross-functional...  ...\n • Kafka, IBM MQ, Event-Driven Architecture \n \n • Oracle/PostgreSQL/MongoDB \n \n • OpenShift, Kubernetes, Docker \n \n... 
    Postgresql
    Oracle
    Local area

    AppLab Systems, Inc

    Edison, NJ
    5 days ago
  • ETL Test Engineer
     ...Proficiency in ETL tools (e.g., Informatica, Talend, or equivalent) Hands-on experience in Vertica and Oracle databases Advanced SQL skills (e.g., Oracle, PostgreSQL) Python automation frameworks Familiarity with Agile and DevOps methodologies Core Responsibilities: Design... 
    Postgresql
    Oracle

    HAN Staffing

    Iselin, NJ
    2 days ago
  • Qlik Consultant
     ...Define and extract data from a variety of data sources (SQL Server, Oracle, Excel Files, Hive, etc.). Architect data structures and...  ...visualization and NPrinting reports • Implement procedures around migration, scheduling and distribution of applications • Help design... 
    Oracle
    Full time
    Contract work
    Work at office
    Remote work
    3 days per week

    ACI Infotech

    Edison, NJ
    2 days ago
  • SR AWS CONNECT SOLUTION ARCHITECT
     ...Infrastructure as code (Terraform, CloudFormation, Ansible, etc.) Unix/Linux Java technologies & frameworks (Spring, Hibernate, etc.) PostgreSQL, MySQL, Oracle Modern JavaScript frameworks (ReactJS, Vue.js or Angular) Agile Delivery AWS DevOps Proficiency following coding best... 
    Postgresql
    Oracle

    HAN Staffing

    Iselin, NJ
    2 days ago
  • Java Software Engineer
     ...hands-on experience with at least one major commercial Relational Database Management System (Microsoft SQL Server, Oracle, IBM DB2, MySQL, PostgreSQL, etc.) ~ Demonstrated proficiency with one or more modern Java IDEs (Eclipse, IntelliJ, NetBeans, etc.) ~ Deep understanding... 
    Postgresql
    Oracle

    Stellar Consulting Solutions, LLC

    Monroe, NJ
    10 hours ago
  • Application Migration Consultant
    Job ID: 21296458Reference Number: 24-00155Title: Application Migration ConsultantLocation: Iselin, NJ, 08830Posted Date: 2024-02-07Company: HAN Staffing Application Migration Consultant

    HAN Staffing

    Iselin, NJ
    2 days ago
  • Sage 500 Consultant
    Company DescriptionSA Technologies Inc. ( is a market leader and one of the fastest growing IT consulting firms with operations in US, Canada, Mexico & India. SAT is an Oracle Gold Partner, SAP Services Partner & IBM Certified enterprise.We guarantee you the best rate... 
    Oracle

    SA Technologies

    Cranbury, NJ
    1 day ago
  • Full Stack engineer with Rule Engine and API development
     ...React.js, GraphQL, JSON, YAML, HTML, XML, CSS, and RESTful APIs. Solid experience working with databases such as MySQL, Oracle, SQL Server, PostgreSQL, DynamoDB, Redis, or MongoDB. Familiarity with AWS services including Lambda, EC2, ECS, Route53, Elasticsearch, and IAM... 
    Postgresql
    Oracle

    HAN Staffing

    Iselin, NJ
    2 days ago
  • Linux Admin Migration
     ...with Chef, Red hat, AWS , Automation expert and Experienced in Migration projects, who can work flexible hours. Job Description. RedHat...  ...Powerbroker and Chef. Knowledge of clustering technologies - Veritas and Oracle RAC. Knowledge of the physical datacenter operating environment... 
    Oracle
    Flexible hours

    HAN Staffing

    Iselin, NJ
    2 days ago
  • Oracle EBS CRM Techno-Functional Support & Enhancement Specialist
     ...Title: Oracle EBS CRM Techno-Functional Support & Enhancement Specialist Location: Jamesburg, NJ Job Description: We are...  ...collaborate effectively with business stakeholders, CRM functional consultants, technical teams, and end users. Preferred Qualifications... 
    Oracle
    Full time
    Contract work

    Techgene Solutions

    Jamesburg, NJ
    10 hours ago
  • Oracle EBS Finance Techno-Functional Support & Enhancement Specialist
     ...Job Title: Oracle EBS Finance Techno-Functional Support & Enhancement Specialist Location Jamesburg, NJ Job Description: We are seeking an experienced Oracle E-Business Suite (EBS) Finance Techno-Functional Specialist with strong expertise in supporting, maintaining... 
    Oracle
    Full time

    Techgene Solutions

    Jamesburg, NJ
    10 hours ago
  • AI Solution Architect
     ...Java / J2EE: Java 11–21, Spring Boot, Spring Framework, Jakarta EE, microservices with REST/gRPC, Apache Kafka, JPA/Hibernate, PostgreSQL, Oracle .NET: C# (.NET 6/7/8), ASP.NET Core Web API, Entity Framework Core, Azure Service Bus, Dapper, SQL Server, and Cosmos DB... 
    Postgresql
    Oracle
    Shift work

    TechDigital Corporation

    Holmdel, NJ
    2 days ago
  • Consulting DBA
     ...fields of Software Development, Software Consultancy and Information Technology Enabled...  ...accordance with Cilent defined standardsDatabase Migrations and UpdatesApplication of database...  ...Certified ProfessionalKnowledge in SQL and/or Oracle will be added AdvantageStrong written &... 
    Oracle
    Full time

    Sonsoft

    New Brunswick, NJ
    3 days ago
  • Consulting DBA
     ...fields of Software Development, Software Consultancy and Information Technology Enabled...  ...accordance with Cilent defined standardsDatabase Migrations and UpdatesApplication of database...  ...Certified ProfessionalKnowledge in SQL and/or Oracle will be added AdvantageStrong written &... 
    Oracle
    Full time

    Sonsoft

    New Brunswick, NJ
    3 days ago
  • PostgreSQL DBA

    $43 - $45 per hour

     ...Technical Requirements: PostgreSQL database Administration, in-depth hands-...  ...procedures such as upgrade, patch, recovery, migration, High Availability Ensure performance...  ...in conversion of ETL mappings from Oracle to Postgres. ~ Good analytical and problem... 
    Postgresql
    Oracle

    eTeam Inc

    Somerset, NJ
    18 days ago
  • Senior Consultant-Life Insurance

    $116.88k - $148.13k

     ...Senior Consultant, Life Insurance About the Role – The applicant should have experience in advising Life Insurance client executives...  ...thinking type techniques. Life Insurance platforms like ALIP, Oracle Policy Admin for L&A, Majesco, Fineos, etc. Additional... 
    Oracle
    Full time
    Temporary work
    Work experience placement

    Infosys Consulting

    Somerset, NJ
    5 hours ago
  • Software Engineer

    $76 - $82 per hour

     ...using Angular . ~ Experience with JPA/Hibernate and relational databases. ~ Experience with SQL and databases such as Oracle, PostgreSQL, SQL Server, MySQL, or equivalent technologies. ~ Knowledge of object-oriented design, data structures, algorithms, design... 
    Postgresql
    Oracle
    Hourly pay
    Contract work
    Work at office

    Judge Group, Inc.

    Woodbridge, NJ
    1 day ago
  • Sr. Informatica Developer
     ...and other project team members Performs migration of workflows from development/Test to production...  ...with multiple databases like Netezza, Oracle etc. Qualifications Bachelor's Degree in...  ...be kept confidential according to EEO guidelines. #J-18808-Ljbffr Sonoma Consulting Inc.
    Oracle
    Permanent employment
    Full time

    Sonoma Consulting Inc.

    New Brunswick, NJ
    22 hours ago
  • TDM Architect
     ...environments including: Mainframe – DB2, VSAM, sequential datasets, GDGs and related technologies. Distributed databases – Oracle, SQL Server, PostgreSQL, DB2 LUW and similar platforms. Cloud/data platforms and enterprise data lakes. APIs, files, messaging and... 
    Postgresql
    Oracle

    TechDigital Corporation

    Holmdel, NJ
    2 days ago
  • Senior Java Technical Lead / Payments Backend Developer
     ...applications and payment processing platforms. Experience with Oracle, PostgreSQL, or MongoDB. Knowledge of OpenShift, Kubernetes, Docker,...  ...production deployments, troubleshooting, and cloud migration initiatives. Mandatory Payments Domain Experience: Candidates... 
    Postgresql
    Oracle

    Applab Systems Inc

    Edison, NJ
    2 days ago
  • Software Engineer- Enterprise modernization
     ...REST APIs, and other messaging technologies. Support migration from legacy communication technolog Required skills:...  ...network/service provisioning capabilities. Work with Oracle/Informix and PostgreSQL databases, including query optimization and performance tuning... 
    Postgresql
    Full time
    Contract work

    CTG

    Piscataway, NJ
    2 days ago
  • Java Enterprise Architect
     ...Amazon SNS, and Amazon SQS, DynamoDB, etc. and understand how to migrate to these patterns from more traditional application...  ...Additionally, the architect should have expertise in working with Oracle and PostgreSQL databases commonly used as backends for monolithic... 
    Postgresql

    HAN Staffing

    Iselin, NJ
    2 days ago
  • Senior Clinical Database Programmer
     ...Clinical Trial Processes. Hands-on experience with Medidata Rave, Oracle Clinical, OpenClinica. Study database build & configuration...  ...UAT, QC Testing, Functional Documentation. Integrations / Data Migration knowledge. Strong analytical & problem-solving skills. Excellent... 
    Oracle
    Remote work

    Katalyst Healthcares & Life Sciences

    New Brunswick, NJ
    5 days ago
  • TIBCO/Java Developer
     ...Familiarity with RDMS and NoSQL databases: MongoDB, Cassandra, Teradata, Oracle, MySQL Good understanding of Object-Oriented programming...  .../code Tibco components per NBCU technology standards Migrate the projects from BW 5.x to BW 6.x Create test scripts/validation... 
    Oracle

    HAN Staffing

    Iselin, NJ
    2 days ago
  • Systems Support Specialist

    $81.36k

     ...data and developing reports and analysis. Lean Six Sigma experience. Equipment Utilized Enterprise platforms (Jaggaer/RU-Marketplace, Oracle Cloud, ServiceNow), JIRA, Microsoft Office Suite (Word, Excel, PowerPoint, SharePoint), and standard functional documentation... 
    Oracle
    Full time
    Temporary work
    Seasonal work
    Work at office
    Flexible hours
    Shift work
    3 days per week

    Rutgers University

    Piscataway, NJ
    22 hours ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Oracle to PostgreSQL Migration Consultant. Be the first to apply!

Related searches