Mydbops Webinar #53

Date & Time:
Friday, July 24th | 3:30 PM - 4:15 PM IST

Speaker:
Kabilesh PR, Co-Founder, Mydbops

Migrating a core database off Oracle involves navigating complex data mappings, rewriting legacy PL/SQL code, and planning for strict downtime windows.

In this session, we share the technical breakdown of a real-world modernization project. We migrated a 4TB Oracle database (reduced to 1.8TB post-archival) to AWS Aurora PostgreSQL 15 for a leading specialized health insurance provider in India.

• Schema & Data Type Mapping: Real-world conversions of Oracle types (NUMBER, DATE, CLOB/BLOB) to PostgreSQL equivalents.
• Code Conversion Challenges: Rewriting PL/SQL to PL/pgSQL, including handling legacy outer joins (+) and package states.
• Data Migration Pipeline: Best practices for using AWS DMS for bulk loading and setting up continuous Change Data Capture (CDC).
• The 8-Phase Cutover Plan: How the team structured the transition from write-freeze to go-live within a 30-to-45-minute window.
• Rollback Safety Net: Establishing concrete triggers to safely revert to Oracle if critical issues arise during cutover.

Database Administrators (DBAs), Cloud Architects, Systems Engineers, and Engineering Leaders planning or executing database modernization initiatives.

Register Now!