CCC Intelligent Solutions Achieves Improved Efficiency with Oracle to AWS PostgreSQL
summary
CCC migrates 182 database instances (about 170 TB total) from Oracle Exadata to Postgres on AWS using AWS DMS and SCT plus custom scripts, moves large BLOBs to S3 to shrink DB storage, and performs iterative cutovers across 30–35 grouped databases. Results include removing multi‑million dollar Oracle licensing, handling 70–80k aggregate transactions/sec with an ~80 TB production DB, improved parallel query and scaling on Aurora, and automated observability via CloudWatch → PagerDuty.
AI-written summary · about
chapters (16)
- 0:00Oracle to PostgreSQL migration
- 1:30Introduction
- 4:41Database modernization journey
- 6:06Migration approach and challenges
- 9:57Risk mitigation and testing
- 12:07Migration process and tools
- 14:14Migration timeline and releases
- 14:35Measurable benefits and costs
- 15:15Cloud-native strategy and scalability
- 16:18Performance and security gains
- 17:40Operational efficiency shift
- 18:24Resilience and recovery
- 18:46Incident management and observability
- 20:55Post-migration optimizations
- 21:58Patching and compliance
- 22:40Conclusion
related talks
19mPostgreSQL at Amazon
48mThe Journey of a strongly coupled Monolith into the Cloud Land
29mTales from the Field - Oracle to PostgreSQL migrations
25mMigrate to an AWS database: The freedom to save, grow, and innovate
37mDatabase Modernization at Cloud Scale: Minimizing Risk and Disruption
26mIntroduction to AWS databases: Modernize your data infrastructure
31mModernizing a megascale database
10mPostgres on AWS: Run 5X faster on metal, migrate anywhere