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

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.
Vacancy posted 22 days ago
Similar jobs that could be interesting for youBased on the Oracle to PostgreSQL Migration Consultant in East Brunswick, NJ vacancy
  •  ...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
    20 days ago
  • $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
    20 days ago
  •  ...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,... 
    Postgresql
    Oracle

    eTeam Inc.

    Edison, NJ
    22 days ago
  •  ...APIsStrong knowledge of Microservices ArchitectureExperience with Spring Security, OAuth2, and JWTDatabase experience with PostgreSQL, MySQL, Oracle, or MongoDBExperience with Apache Kafka or other messaging platformsExperience using Docker and KubernetesGit version... 
    Postgresql
    Oracle

    Prolim Global

    New Brunswick, NJ
    1 day ago
  • $77.2k - $115.8k

     ...our team. World Wide Technology is seeking a highly skilled Oracle Cloud ERP and R12 Analyst to join our IT Financial Operations team...  ...value sets to meet functional requirements. Support data migration activities by validating FBDI templates and coordinating with technical... 
    Oracle
    Full time
    Remote work
    Shift work

    World Wide Technology

    New Brunswick, NJ
    3 days ago
  •  ...Experience with Microservices architecture and distributed systems. Strong knowledge of SQL databases such as Oracle, MySQL, or PostgreSQL. Experience with Kafka or other messaging technologies is preferred. Good understanding of AWS/Azure cloud technologies... 
    Postgresql
    Oracle
    Contract work

    Han IT Staffing

    Iselin, NJ
    20 days ago
  • $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
    a month ago
  •  ...payment processing workflows, settlement, and reconciliation Experience developing REST APIs and event-driven applications SQL experience (Oracle/PostgreSQL) Experience with Git, Maven, Jenkins, and CI/CD Exposure to cloud platforms (AWS preferred) is a plus... 
    Postgresql
    Oracle

    Han IT Staffing

    Iselin, NJ
    22 days ago
  •  ...microservices patterns, circuit breakers, service discovery, and asynchronous messaging. - Solid experience with relational (PostgreSQL, Oracle) and NoSQL (MongoDB, Redis) databases. - Proven experience with cloud platforms (AWS/Azure/GCP) and container orchestration (... 
    Postgresql
    Oracle

    AceStack LLC

    Iselin, NJ
    5 days ago
  •  ...(OAuth 2.0, JWT, OpenID Connect, SSL/TLS) 2 years React JS / React UI 3 Years - Mandatory Database (DB2 or SQL Server or Oracle , PostgreSQL, Hibernate, JPA) 5-7 Years Integration Testing & API Testing (Postman, SOAP UI) Good to have Caching Technologies (Redis, EhCache... 
    Postgresql
    Oracle

    TechDigital Corporation

    Holmdel, NJ
    22 days ago
  •  ...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
    22 days ago
  •  ...development. REST and SOAP APIs, JSON, WSDL, JBOSS, and Apache Tomcat. SQL and relational databases including Oracle, MySQL, and PostgreSQL. OAuth tokens. Jenkins, Maven, JIRA, Agile, SOA, XML, IntelliJ, Eclipse, cloud servers, and AWS. Development... 
    Postgresql
    Oracle
    Full time

    Tanisha Systems

    Edison, NJ
    22 days ago
  • $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
  • $77.2k - $96.5k

     ...Qualifications: ~ Bachelor’s degree in business, Accounting, MIS, Finance, or related field ~3+ years supporting or implementing Oracle EBS R12 and/or Oracle Cloud Financials ~ Hands-on experience with Order-to-Cash (O2C) and/or Procure-to-Pay (P2P) processes ~... 
    Oracle
    Full time
    Shift work

    World Wide Technology

    New Brunswick, NJ
    5 days ago
  • $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
    20 days ago
  •  ...React Front-End Development (HTML5, CSS3, JavaScript, TypeScript) RESTful APIs Database Design and Development (Oracle, SQL Server, PostgreSQL, or similar RDBMS) Reflection Frameworks and Core Java Concepts AI-enabled Application Development / AI... 
    Postgresql
    Oracle

    Han IT Staffing

    Iselin, NJ
    22 days ago
  • $96.4k - $144.6k

     ...Degree; preferably in Business, IT, Accounting, MIS, Finance, or a related field. Minimum 6 years of functional experience with Oracle ERP Applications, including Oracle EBS R12 and/or Oracle Cloud Financials, with a focus on the Procure-to-Pay cycle (Cloud experience... 
    Oracle
    Full time
    Remote work
    Flexible hours
    Shift work

    World Wide Technology

    New Brunswick, NJ
    1 day ago
  • 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
  • $66.41 - $74.41 per hour

     ...Iselin, NJ. We are seeking an experienced Java Developer to consult on a high-level initiative focused on developing a scalable...  ...~ Experience with SQL and relational databases such as Oracle, PostgreSQL, SQL Server, or MySQL ~ Experience with source control tools... 
    Postgresql
    Oracle
    Hourly pay
    Permanent employment
    Contract work

    Genesis10

    Iselin, NJ
    22 days ago
  •  ...Integration patterns, ESB / middleware exposure (Oracle SOA/OSB, MuleSoft, or similar)...  ...Databases ~ DB2, Oracle, SQL Server, or PostgreSQL; advanced SQL, stored procedures, query...  ...models Experience modernizing or migrating legacy platforms Experience working... 
    Postgresql
    Oracle
    Permanent employment
    Contract work
    Shift work

    TMS

    Edison, NJ
    5 days ago
  •  ...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
  •  ...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
  •  ...Job Title: Oracle HCM Cloud Technical Consultant Location: Newark, NJ Duration: 06 of contract with possibility of extension...  ..., ensuring smooth transitions and successful data migrations. Data Loader Management: Prepare and manage HDL (HCM... 
    Oracle
    Contract work

    Sunrise Systems

    Edison, NJ
    a month ago
  •  ...expect strong Pega architectural understanding)Pega PRPC 6.2 to 7.1 Migration experienceHTML5, JavaScript, JavaScrum development methodology experienceExperience with Relational databases and concepts — Oracle SQL, PL/SQL etc.Ability to debug and fix as part of the... 
    Oracle
    Full time
    Immediate start

    HSS SOFT

    Edison, NJ
    4 days ago
  •  ...Job Description Job Description Title: Oracle SaaS Fusion Finance Consultant. Location: Edison, NJ (Hybrid, 3 days onsite). Type: Contract...  ...into Oracle Cloud solutions. Lead or support data migration, reconciliation, SIT, UAT, cutover, and go-live... 
    Oracle
    Full time
    Contract work
    3 days per week

    ZipStaff Inc.

    Edison, NJ
    8 days ago
  •  ..., tracking progress, and maintaining accountability across the team. SAP BASIS Have strong exposure in SAP BASIS – ECC 7.4 with Oracle database Operating system – Oracle Linux Can lead SAP basis and security team of 5 members Have strong customer facing experience... 
    Oracle

    TechDigital Group

    Plainsboro, NJ
    1 day ago
  •  ...Role Overview: We are seeking an Oracle Fusion HCM Solutions Architect/SME with 13+ years of implementation experience who can...  ...projects across regions would be ideal ~ Certified Benefits HCM consultant will be Ideal. Ideal Core Competencies: Oracle HCM... 
    Oracle
    Full time

    Donyati

    Piscataway, NJ
    14 days ago
  •  ...implementation, configuration, and integration of Oracle Cloud HCM solutions, with a focus on...  ...leadership and mentorship to junior consultants and support presales activities through...  ...Cloud. Experience in HCM data migration, integration design, configuration, and... 
    Oracle
    Contract work

    Techvilla Solutions

    Edison, NJ
    19 days ago
  •  ...Descriptions: In this contingent resource assignment, you may: Consult on complex initiatives with broad impact and large-scale...  ...Experience with SQL and relational databases such as Oracle, PostgreSQL, SQL Server, or MySQL. Experience with source control tools... 
    Postgresql
    Oracle

    Mindlance

    Iselin, NJ
    22 days ago
  • $287.3k - $371.8k

     ...Summary NetApp® ONTAP® data management software is coming to Oracle Cloud Infrastructure as a first party, fully managed service. That...  ...and IT decision makers. Tie the service to their workload, migration, data protection, and cost priorities. - Run high-level technical... 
    Oracle
    Work at office
    Local area

    NetApp

    Avenel, NJ
    2 days ago

Do you want to receive more vacancies?

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