Oracle to PostgreSQL Migration Consultant

Tanisha Systems

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 1 day ago

Similar jobs that could be interesting for youBased on the Oracle to PostgreSQL Migration Consultant in Austin, TX vacancy

Senior Cloud Database Migration Engineer / Senior Database Administrator / SQL Server-Oracle DBA (Azure)
...Senior Cloud Database Migration Engineer / Senior Database Administrator / SQL Server–Oracle DBA (Azure) Austin, Texas (Hybrid – 3 Days Onsite | 2 Days Remote) Experience: Minimum 12+ Years Mandatory Skills ✔ Oracle to Azure SQL Migration ✔ SQL Server Administration...
Oracle
Temporary work
Remote work
Delan Associates, Inc
Austin, TX
a month ago
Cloud Data Migration Engineer
...Cloud Data Migration Engineer Austin, Texas (Hybrid – 3 Days Remote | Onsite Monday & Thursday) Experience: Minimum 12+ Years Mandatory Skills ✔ Oracle Database Migration ✔ AWS Database Migration Service (AWS DMS) ✔ Oracle to AWS Migration ✔ Database...
Oracle
Temporary work
Remote work
Delan Associates, Inc
Austin, TX
a month ago
Database Administrator
...role at MTK Technologies. We are seeking an experienced PostgreSQL Database Administrator (DBA) to support our database infrastructure... ..., TX or Cupertino, CA. Nice to Have Experience with migration projects (e.g., Oracle to PostgreSQL). Exposure to Kubernetes, Docker, and...
Postgresql
Oracle
Contract work
MTK Technologies Inc
Austin, TX
3 days ago
Database Administrator, Mid
$78.4k - $119.18k
...maintenance activities such as patching, upgrades, environment migrations, and recovery exercises while minimizing downtime and... ...and non‑production instances of platforms such as Oracle, SQL Server, MySQL, or PostgreSQL, including advanced schema design, partitioning...
Postgresql
Oracle
Contract work
Work experience placement
Work at office
ASM Research, An Accenture Federal Services Company
Austin, TX
2 days ago
Sr. Software Engineer - AI Quality and Productivity
...modeling across enterprise data platforms (e.g., SQL Server, Oracle, PostgreSQL).Build and optimize data pipelines and workflows in... ...data engineering, analytics, or AI workloads.Proven experience migrating applications and complex data workloads to Azure or other cloud...
Postgresql
Oracle
Full time
Local area
Work from home
Relocation package
General Motors
Austin, TX
4 days ago
Senior Software Engineer / Architect - Search Engine Internals (Full-Text & Hybrid Retrieval)
$135.2k - $306.4k
...search, and AI-facing capabilities inside Oracle Database. This is a role for... ...systems. Document APIs, Compatibility, and Migration Help evolve developer-facing document... ...infrastructure. Experience with Oracle Database, PostgreSQL, MongoDB, DynamoDB, Elasticsearch,...
Postgresql
Oracle
Temporary work
Flexible hours
Oracle
Austin, TX
5 days ago
Technical GRC Analyst with SQL DB
...implementing and maintaining governance controls in a complex environment.Familiarity with major database platforms (e.g., Oracle, SQL Server, MySQL, PostgreSQL, etc.), database lifecycle management, and access control mechanisms.Proven ability to own, document, and...
Postgresql
Oracle
Local area
SRI Tech
Austin, TX
1 day ago
Senior Consultant
$150k
...| Summit | Washington Who We Are Boston Consulting Group partners with leaders in business... ...cloud computer providers and strategies for migrating from on-premise architecture. Utilizing... ...g., Anaplan, Kinaxis, OMP, etc.). SAP / Oracle. Salesforce. Exceptional learning and...
Oracle
Work at office
Local area
Boston Consulting Group
Austin, TX
1 day ago
Senior Database Administrator
$105k
...ecosystem. It covers database and system administration across Oracle, PostgreSQL, and Databricks, and devises optimal database configurations... ...database tuning.* Skilled at database design, installation, migration and conversion.* Experience with Databricks and AWS...
Postgresql
Oracle
Full time
Work at office
Immediate start
Remote work
Monday to Friday
Flexible hours
Shift work
Night shift
University of Texas at Austin
Austin, TX
1 day ago
PostgreSQL Database Developer
...Job Description Job Description PostgreSQL Database Developer Employment... ...federal customers. You will support a migration from the current Oracle database to a Postgres database and... ...Azure and/or AWS - Prior federal consulting experience Our Commitment:...
Postgresql
Oracle
Full time
Flexible hours
Contact Government Services, LLC
Austin, TX
7 days ago
Lead Software Development Engineering
$163.1k - $271.8k
...modern microservices architectures leveraging Java, Databricks, Oracle, PostgreSQL, MongoDB, APIs, and event-driven integration patterns. The... ...(e.g., monolith-to-microservices transformation, cloud migration) is a plus.Additional SkillsStrong awareness of emerging trends...
Postgresql
Oracle
Full time
H1b
Work at office
Remote work
Work from home
2 days per week
McKesson
Austin, TX
3 days ago
ETL ,Informatica Consultant (GC-EAD,GC,USC)
...specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.Job DescriptionPreferred... ...and maintenance projects• At least 3 years of experience in Oracle Databases• At least 3 years of hands on experience in Design,...
Oracle
Permanent employment
Full time
H1b
Sonsoft
Austin, TX
1 day ago
Energy and Market Management Systems (EMS AND EMMS) Consultant
...opportunities for Energy and Market Management System (EMMS) Consultants to provide application and interface support to... ...with code build, patch implementation, and migrations in the EMMS System Experience with Oracle PL/SQL and Data Conversion Benefits MWResource offers...
Oracle
Temporary work
Work experience placement
MWResource, Inc.
Austin, TX
2 days ago
Java spring boot developer
...OOP concepts.Experience with RESTful APIs, both consuming and developing.Knowledge of database technologies such as MySQL, Oracle, or PostgreSQL.Understanding of fundamental design principles behind a scalable application.Experience with version control systems like Git...
Postgresql
Oracle
For contractors
Technamo
Austin, TX
1 day ago
ETL Developer
$115k - $175k
...Vision Technologies is a technology consulting and software development company delivering... ...Collaborate with cloud engineers to migrate legacy ETL workloads to Azure or AWS... ...SQL development skills with SQL Server, Oracle, PostgreSQL, Snowflake, or Teradata. Strong...
Postgresql
Oracle
Full time
H1b
Local area
Immediate start
Remote work
Visa sponsorship
Bright Vision Technologies
Round Rock, TX
a month ago
IT - Project Manager - Engineering | Database | Oracle Database
$70 per hour
...experience with other RDBMS andNonrelational systems like Aurora PostgreSQL, Aurora MySQL, MSSQLSERVER, Single Store, Cassandra and Aurora... ...skills: DBA Administrator of an RDBMS database including oracle tool sets RAC, ASM, Data Guard, OEMand RMAN.Aurora PostgreSQL,...
Postgresql
Oracle
Hourly pay
Permanent employment
Work at office
Remote work
3 days per week
Cloudspace LLC
Austin, TX
1 day ago
Senior Java Spring Boot Developer
...BootSpring Framework (Spring MVC, Spring Data JPA, Spring Security)Microservices ArchitectureRESTful API DevelopmentHibernate/JPASQL (Oracle, PostgreSQL, SQL Server, or MySQL)Maven or GradleGit/GitHubUnit Testing (JUnit, Mockito)Agile/Scrum methodologyStrong debugging and...
Postgresql
Oracle
Workiy
Austin, TX
2 days ago
Sr Manager, Enterprise Batch Services
...Transfers: NDM, FTP, SFTP, PGP/FTP, NFSScripting & Programming: Unix Shell Scripting, PERLDatabase & Data Tools: SQL, Oracle, MS-SQL Server, PostgreSQL, Hadoop (Big Data)Infrastructure Knowledge: Backup & Recovery, High Availability/Disaster Recovery, Clustering (Unix &...
Postgresql
Oracle
Full time
The Charles Schwab Corporation
Austin, TX
2 days ago
Senior Data Engineer - Scalable Data Pipelines (Hybrid)
...warehousing, AWS cloud architecture, migration and troubleshooting complex performance... ...: Teradata, Amazon Redshift, Oracle, MySQL, or PostgreSQL. Cloud services: AWS Services EC2, S3... ...details specific to your location, please consult with your recruiter. Accommodations Roku...
Postgresql
Oracle
Work experience placement
Work at office
Local area
Remote work
Monday to Thursday
Flexible hours
1 day per week
Roku
Austin, TX
1 day ago
Mainframe Consultant
Company DescriptionSonSoft is an IT Staffing and consulting firm and duly organized under the laws of the Commonwealth of Georgia. We are... ...Suite of Tools for Mainframe) Exposure to ETL technologies or Oracle DB At least 4 years of experience working in Mainframe environments...
Oracle
Permanent employment
Full time
H1b
Sonsoft
Austin, TX
3 days ago
Senior Database Engineer
$8,488.33 per month
...enabled solution patterns, executing database migration activities, validating data quality, and... ...management systems (RDBMS), such as Oracle and Microsoft SQL Server, data... ...cloud datastores (e.g., Azure SQL, AWS RDS, PostgreSQL) and distributed schema designs. Thorough...
Postgresql
Oracle
Permanent employment
Full time
Temporary work
Part time
Work at office
Remote work
Shift work
Texas Health and Human Services
Austin, TX
4 days ago
Senior Data Engineer
...warehousing, AWS cloud architecture, migration and troubleshooting complex performance... ...: Teradata, Amazon Redshift, Oracle, MySQL, or PostgreSQL. Cloud services: AWS Services EC2, S... ...details specific to your location, please consult with your recruiter. Accommodations...
Postgresql
Oracle
Work experience placement
Work at office
Local area
Remote work
Monday to Thursday
Flexible hours
1 day per week
Roku, Inc.
Austin, TX
5 days ago
Consultant principal ou consultante principale Oracle Cloud ERP Financials
...Your role, your impact As an Oracle Cloud ERP Financials Senior Consultant, you’ll leverage your domain and functional expertise to design and implement finance solutions across Oracle Cloud ERP finance modules, including General Ledger, Payables, Receivables, Cash...
Oracle
Jobleads-US
Austin, TX
3 days ago
Database Administrator 3
...independent judgment. This position demands a strong background in Oracle database technologies and is central to ensuring that the TIERS... ..., Spring, JPA, jQuery, AngularJS, IBM WebSphere, Oracle, PostGreSQL and more. • Perform advanced logical database administration...
Postgresql
Oracle
Night shift
Weekend work
TriOptus LLC
Austin, TX
3 days ago
Enterprise Solution Architect
...Management Production Reliability, Incident Management & RCA Database Architecture & Administration: Oracle (SQL/PLSQL, Performance Tuning, GoldenGate) PostgreSQL Cassandra Couchbase Redis CockroachDB Database Replication, Backup & Disaster...
Postgresql
Oracle
Delan Associates Inc
Austin, TX
1 day ago
Consultant - ERP
...you will be involved in designing, implementing and deploying oracle solutions to achieve business goals. Primary role involves in bringing... ...according to EEO guidelines.SummaryType: Full-timeFunction: ConsultingExperience level: Mid-Senior LevelIndustry: Management Consulting
Oracle
Work at office
Roljobs Technology Services
Austin, TX
3 days ago
Full Stack Developer
...JPA, Hibernate, Angular 6 (or above), JavaScript, jQuery, HTML5, CSS. Expertise with SQL and one or more of the following: Oracle, MySQL, PostgreSQL, or SQL Server. Ability to create and improve TDD coverage with JUnit, Cucumber, Karma, Jasmine. Able to conduct code...
Postgresql
Oracle
Contract work
Remote work
Relocation
2 days per week
Software Technology Inc
Austin, TX
5 days ago
IT - Technology Lead | HTML,CSS,Javascript,Jquery,PHP,Drupal | express.js
$70 per hour
...Spring Boot.* Experience designing and implementing microservices, RESTful APIs, and scalable systems.* Strong knowledge of SQL (Oracle, PostgreSQL, Snowflake) and NoSQL (Cassandra, MongoDB, DynamoDB)* Experience in AWS, GCP, or Azure, along with containerization using...
Postgresql
Oracle
Contract work
Local area
Cloudspace LLC
Austin, TX
1 day ago
.NET /GIS Consultant
...specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.Job DescriptionPreferred... ...API) • ArcGIS for Mobile(ArcPad), • FME(FME Scripts) and Oracle Spatial• At least 2 years of experience in Java Script, Python...
Oracle
Permanent employment
Full time
H1b
Sonsoft
Austin, TX
1 day ago
Java Developer
...such as GCP, AWS, or PCF, and deployment tools like Docker and Kubernetes.Proficiency in working with databases like MongoDB, PostgreSQL, or Oracle, and experience with system modernization initiatives.Practical knowledge of AI/ML implementation, Large Language Models,...
Postgresql
Oracle
Experis
Austin, TX
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!