Database Engineer/DBA - Oracle to PostgreSQL Migration

Exl Neo Inc

Position: Database Engineer/DBA - Oracle to PostgreSQL Migration
Location: Sunnyvale, CA/ Austin, TX (Onsite)
Employment Type: Full-Time & Contract

Job Description:-

Candidate should have python coding experience and Oracle to PostgreSQL migration experience.

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.

Apply

Vacancy posted 1 day ago

Similar jobs that could be interesting for youBased on the Database Engineer/DBA - Oracle to PostgreSQL Migration in Austin, TX vacancy

Database Engineer
...building modern, scalable database systems that power healthcare... ...We are seeking a Database Engineer to design, develop, and... ...administration. Proficiency in PostgreSQL, MySQL, MSSQL, or Oracle. Deep understanding of... ...analytical warehouses. Migrate on-premise clinical databases...
Postgresql
Medclinicx
Austin, TX
4 days ago
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...
Suggested
Contract work
Remote work
Delan Associates, Inc
Austin, TX
a month ago
Technical Dynamics 365 Data Migration Manager
$130k - $145k
...Woolpert is an award‑winning, global leader in architecture, engineering, and geospatial services. We blend design excellence with cutting... ...growth. Woolpert is hiring a Technical Dynamics 365 Data Migration Manager to join our dynamic Corporate Applications. This position...
Suggested
For contractors
Flexible hours
Woolpert
Austin, TX
2 days ago
PostgreSQL Database Engineer
The University of Texas at Austin's Applied Research Laboratories seeks a Database Engineering Specialist to build, test, and maintain PostgreSQL backends in a Linux environment at the Pickle Research Campus. Responsibilities include deploying and optimizing analytic databases...
Postgresql
Immediate start
Phase2 Technology
Austin, TX
1 day ago
PostgreSQL DBA
.... Job Description Below 10 Years of experience as a Database Administrator with focus on PostgreSQL. Experience in SQL performance tuning, query optimization... ...is a plus. Ability to support database upgrades, migrations, and patch management. Ability to manage and...
Postgresql
Full time
Apexon
Round Rock, TX
2 days ago
Database Administrator - Senior
$94.1k - $144.8k
...The Database Administrator, Senior leads the design... ...major upgrade, migration, and modernization... ...platforms such as Oracle, SQL Server, MySQL, or PostgreSQL, including advanced... ...analytics workloads. Engineer and oversee high‑availability... ..., advanced Oracle DBA tracks or Microsoft...
Postgresql
Contract work
Work experience placement
Work at office
ASM Research, An Accenture Federal Services Company
Austin, TX
2 days ago
Database Administrator, Mid
$78.4k - $119.18k
The Database Administrator, Mid oversees the stability, performance, and security... ...patching, upgrades, environment migrations, and recovery exercises while... ...production instances of platforms such as Oracle, SQL Server, MySQL, or PostgreSQL, including advanced schema design,...
Postgresql
Contract work
Work experience placement
Work at office
ASM Research, An Accenture Federal Services Company
Austin, TX
4 days ago
Senior Data Engineer
...continual improvement of engineering tools, cloud-based technologies... ..., AWS cloud architecture, migration and troubleshooting... ...pipelines. SQL and NoSQL database design, Data Modeling and... ...Teradata, Amazon Redshift, Oracle, MySQL, or PostgreSQL. Cloud services: AWS Services...
Postgresql
Work experience placement
Work at office
Local area
Remote work
Monday to Thursday
Flexible hours
1 day per week
Roku, Inc.
Austin, TX
17 hours ago
Senior Database Administrator
$105k
...Senior Database Administrator Hiring Department: Enterprise... ...across Oracle, PostgreSQL, and Databricks, and... ...Information Systems, Engineering, or equivalent professional... ...professional experience in a DBA role with PostgreSQL... ..., installation, migration and conversion....
Postgresql
Full time
For contractors
Work at office
Immediate start
Remote work
Monday to Friday
Flexible hours
Shift work
Night shift
Phase2 Technology
Austin, TX
1 day ago
Database Administrator
Overview Database Administrator role at MTK Technologies. We are seeking an experienced PostgreSQL Database Administrator (DBA) to support our database infrastructure and ensure... ...Nice to Have Experience with migration projects (e.g., Oracle to PostgreSQL). Exposure to...
Postgresql
Contract work
MTK Technologies
Austin, TX
1 day ago
PostgreSQL Database Developer
...Job Description Job Description PostgreSQL Database Developer Employment Type: Full Time, Experienced level Department... ...that empower our federal customers. You will support a migration from the current Oracle database to a Postgres database and manage the...
Postgresql
Full time
Flexible hours
Contact Government Services, LLC
Austin, TX
27 days ago
Senior Database Administrator
...Government Services is seeking a Senior Database Administrator to assist with administering... ...Services, and Integration Services Migrating databases from SQL Server 2012 to SQL Server... ...warehouses Experience with AWS RDS for PostgreSQL Experience with working in cloud...
Postgresql
Full time
Flexible hours
CGS Federal (Contact Government Services)
Austin, TX
1 day ago
Oracle DBA (Hybrid) at Serigor Inc. Austin, TX
...Oracle DBA (Hybrid) Location: Austin, TX Duration: 12 Months Job Description: Understands... ...objectives. Responsibilities include optimizing database performance, maintaining secure... ...cloud deployments, and on‑premise‑to‑cloud migration deployments and roadmaps. 8 years preferred...
Serigor Inc
Austin, TX
1 day ago
Senior Data Engineer
The Senior Data Warehouse Data Engineer will develop,implementandmaintaindata platform... ...of experience in data warehousing, database management, or a related role.... ...database management systems (e.g., Oracle, SQL Server, MySQL, PostgreSQL). 5-7 years of hands-on...
Postgresql
Work at office
Weekend work
Afternoon shift
University Federal Credit Union
Austin, TX
4 days ago
Data Warehouse Engineer
$60 - $65 per hour
...senior) of experience with Data Warehouse Engineering. Should have been a part of building... ...Strong Experience with MYSQL Relational Databases Knowledge with cloud-based data... ...such as relational databases (e.g. MySQL, PostgreSQL), NoSQL databases (e.g. MongoDB, Cassandra...
Postgresql
Full time
Temporary work
Remote work
TEKsystems
Austin, TX
1 day ago
Oracle Database Administrator
$44 per hour
...$44.00/hr - $44.00/hr Job Summary: This Database Administrator (must be located in the state... ...users. Responsibilities: Work with Oracle databases, including creating logical and... ...Optimize database performance during and after migration, identify bottlenecks, and implement...
Full time
For contractors
MDA Edge
Round Rock, TX
3 days ago
Database Administrator
$5,098.66 - $6,451 per month
...Working at HHS webpage. Functional Title: Database Administrator Job Title: Database... ...Texas. Performs complex (journey-level) Oracle database administration work. Work... ...objects and databases. Performs database migration. Analyzes and reports the performance of...
Permanent employment
Full time
Temporary work
Part time
Work at office
Remote work
Shift work
Day shift
TX-HHSC-DSHS-DFPS
Austin, TX
10 hours ago
Database Team Lead / DBA Lead
$79.4k - $136.4k
...Position Overview The Database Team Lead oversees the design, administration, and... ...Coordinate and prioritize work across the DBA team, providing guidance, mentoring,... ...enterprise database systems such as Oracle, SQL Server, MySQL, or PostgreSQL, including leadership or team‑lead...
Postgresql
Contract work
Work at office
ASM Research, An Accenture Federal Services Company
Austin, TX
2 days ago
Senior Software Engineer - Data-Driven Applications
$140k - $190k
...For more information, visit . Our Engineering organization is a fast-growing team of... ...and API design to backend systems and databases. Responsibilities: Translate product... ...including relational systems (MariaDB, PostgreSQL, MySQL, etc.). ~ Experience designing...
Postgresql
Full time
Worldwide
Vectra
Austin, TX
17 hours ago
Data Engineer
$138.7k - $206.95k
...You will partner closely with product owners, architects, data engineers, report and analytics teams, and source-system teams to define... ...integrations and reporting patterns by standardizing and migrating solutions onto the enterprise data platform. Contribute to team...
Full time
H1b
Local area
Work from home
Relocation package
Flexible hours
General Motors
Austin, TX
1 day ago
Database Administrator
...different types of backup and restores in Postgres. Experience with database upgrade on minor and major versions. Hands-on experience on... ...average, locks, blocking and long running sqls. Commonly used PostgreSQL configuration parameters and common system tables usage....
Postgresql
Tata Consultancy Services
Austin, TX
1 day ago
Oracle Consultant
...contractors with strong experience working with Oracle systems. Can you reach out to our... ...Integrity & Clean-up: Assist with data migration, deduplication, and mass updates of supplier... ...failures between upstream procurement engines (e.g., Zip, Coupa) and downstream Oracle...
For contractors
Avenue Code
Austin, TX
17 hours ago
Data Warehouse Engineer
...hoc querying tools. As a Data Warehouse Engineer at ZogoTech, you will play a critical role... ...optimize complex SQL queries and design database schemas for data integration and... ...Windows Server, SQL Server, Linux, and PostgreSQL. Opportunities for Growth At ZogoTech, you...
Postgresql
Remote work
Zogotech
Austin, TX
1 day ago
Data Engineer
$100k - $130k
...Python Develop production-ready tooling that supports data engineering, software engineering, and machine learning teams Improve... ...Prefect Strong SQL skills and experience with relational databases such as PostgreSQL Comfortable working in fast-paced engineering...
Postgresql
Talent Connect Protocol
Austin, TX
1 day ago
Senior Data Engineer
SII Group USA is seeking a Senior Data Migration Engineer to design and execute a large-scale migration... .... Responsibilities Assess source databases and define the detailed migration scope... ...SQL development skills. Experience with Oracle, Microsoft SQL Server, MySQL, or...
3 days per week
SII Group USA
Austin, TX
1 day ago
Senior Solutions Engineer
$180k - $230k
.... Job Description We’re looking for a Senior Solutions Engineer to join our growing team in Austin, Texas. The Wise Platform... ...2. Familiarity and working experience with relational databases (e.g.MySQL, PostgreSQL) and non-relational databases (e.g., MongoDB, Cassandra)....
Postgresql
Full time
Work experience placement
Work at office
Wise
Austin, TX
2 days ago
Database Administrator
...transportation and security markets! Position: Database Administrator – Austin, TX (Hybrid)... ...in MySQL, AWS RDS/Aurora, database migrations, ETL processes, and CI/CD environments.... ...Experience SQL Skills (SQL Server and/or Oracle preferred) Terraform, Git, CI/CD knowledge...
Contract work
Day shift
Creative Solutions Services, LLC
Austin, TX
3 days ago
Data Engineer
...Intelligence CGS is seeking a passionate and driven Data Engineer to support a rapidly growing Data Analytics and Business Intelligence... ...and ability to apply them Experience with relational database, such as PostgreSQL Work comfortably in version control systems, such as Git...
Postgresql
Full time
Flexible hours
CGS Federal (Contact Government Services)
Austin, TX
2 days ago
Senior Software Engineer / Architect - Search Engine Internals (Full-Text & Hybrid Retrieval)
$135.2k - $306.4k
...Senior / Principal Software Engineer or Architect Database Engine, Search & Document... ...capabilities inside Oracle Database. This is a role... ...APIs, Compatibility, and Migration Help evolve developer-facing... ...Experience with Oracle Database, PostgreSQL, MongoDB, DynamoDB,...
Postgresql
Full time
Temporary work
Flexible hours
Oracle
Austin, TX
1 day 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 Modernization...
Contract work
Remote work
Delan Associates, Inc
Austin, TX
a month ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Database Engineer/DBA - Oracle to PostgreSQL Migration. Be the first to apply!