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
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.
- 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...PostgresqlOracle
$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...PostgresqlOracleFull timeLocal area- ...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,...PostgresqlOracle
- ...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...PostgresqlOracle
$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...OracleFull timeRemote workShift work- ...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...PostgresqlOracleContract work
$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...PostgresqlOracle- ...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...PostgresqlOracle
- ...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 (...PostgresqlOracle
- ...(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...PostgresqlOracle
- ...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...PostgresqlOracle
- ...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...PostgresqlOracleFull time
$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...PostgresqlOracleHourly payContract workWork at office$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 ~...OracleFull timeShift work$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...OracleFull timeTemporary workWork experience placement- ...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...PostgresqlOracle
$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...OracleFull timeRemote workFlexible hoursShift work- 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
$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...PostgresqlOracleHourly payPermanent employmentContract work- ...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...PostgresqlOraclePermanent employmentContract workShift work
- ...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 &...OracleFull time
- ...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 &...OracleFull time
- ...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...OracleContract work
- ...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...OracleFull timeImmediate start
- ...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...OracleFull timeContract work3 days per week
- ..., 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
- ...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...OracleFull time
- ...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...OracleContract work
- ...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...PostgresqlOracle
$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...OracleWork at officeLocal area
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Oracle to PostgreSQL Migration Consultant. Be the first to apply!







