Enterprise Database Migration Architect
Core
Architect and execute the end-to-end migration of a complex, business-critical Oracle estate to a PostgreSQL platform, ensuring minimal operational disruption and long-term stability.
Role type
Senior Enterprise Database Migration Architect
Builds
A resilient, secure, and scalable PostgreSQL target platform replacing legacy Oracle systems
Domain
Enterprise Data Management, Database Modernization, Cloud Migration
Required skills
Oracle architecture and PL/SQL expertise, PostgreSQL architecture and performance tuning, Change Data Capture (CDC) and replication design, heterogeneous database migration strategy, application/database coupling remediation, high availability and disaster recovery design, data reconciliation and validation, performance engineering, migration cutover and rollback planning
Preferred skills
Experience with ORM mappings and SQL query rewrites, knowledge of database drivers and connection pooling, capacity and cost optimization, operational readiness and knowledge transfer
Technologies
Oracle, PostgreSQL, PL/SQL, PL/pgSQL, CDC, Replication, Bulk-load, SQL, ORM
Responsibilities
Lead technical assessment of the current Oracle estate including dependency mapping, schema inventory, and workload profiling; Define the end-to-end migration strategy, target-state architecture, and migration-wave planning; Identify and rationalize Oracle-specific dependencies and database-resident business logic; Design the resilient PostgreSQL target platform topology and security controls; Own the conversion strategy for schemas and database code from Oracle to PostgreSQL; Work with application teams to resolve dependencies on Oracle behavior; Design data migration and replication architecture for live production estates; Define controls for functional and performance validation including data reconciliation; Own the technical cutover strategy, rollback plans, and production transition; Stabilize and optimize the PostgreSQL environment post-migration and plan Oracle retirement
Seniority
Senior, hands-on IC