> Markdown version of [/jobs/ext/1842369-oracle-to-postgresql-migration-consultant](https://www.wearedevelopers.com/jobs/ext/1842369-oracle-to-postgresql-migration-consultant). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Oracle to PostgreSQL Migration Consultant - **Company:** Tanisha Systems Inc - **Location:** Austin, TX, United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Amazon Web Services, Microsoft Azure, Cloud Database, Databases, Data Validation, Data Loss, Data Migration, Java Database Connectivity, PostgreSQL, Open Database Connectivity, Oracle Databases, Oracle (Applications), Performance Tuning, Query Optimization, Recovery Manager (RMAN), PL-SQL, SQL Databases, Strategies of Testing, Scripting, Google Cloud, Git, Amazon Relational Database Service, Software Version Control, Legacy Systems - **Published:** July 31, 2026 - **Apply:** https://www.dice.com/job-detail/bbbf8430-dc02-464c-aeca-d14edd2a2383 ## About the Role * 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. ## Description 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., * 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. ## Related Videos - [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Branch your database like your code: How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand) - [Postgres in the Age of AI (and Devin)](https://www.wearedevelopers.com/videos/1042-postgres-in-the-age-of-ai-and-devin) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Effortlessly Scale Prometheus With The Telemetry Data Platform – And Keep your Grafana Dashboards, Too!](https://www.wearedevelopers.com/magazine/3-effortlessly-scale-prometheus-with-the-telemetry-data-platform-and-keep-your-grafana-dashboards-too) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Dev Digest 168: Hacking Postgres, Blocking Meta and Fixing CSS](https://www.wearedevelopers.com/magazine/588-dev-digest-168-hacking-postgres-blocking-meta-and-fixing-css)