CareerPlanSign in

Enterprise Database Migration Architect

Perth, Western Australia💼 Full-time🗓 2026-09-22 → 2026-09-28

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

Sourced via viewjobs · Listed on CareerPlan, which tracks 844,000+ jobs from 20+ sources.