Migrating Databases to the Cloud
Business Challenge
A very large mental healthcare provider was operating as three separate entities. They were looking for the efficiency and flexibility of a consolidated cloud database.
- Merge and consolidate three separate database entities
- Migrate from on-premise database to AWS cloud
- Team performed a homogeneous Migration of on-prem SQL Server to AWS RDS SQL Server using DMS
- TPA migration and transformation using Matillion to Snowflake DB
- Implement functional data lakes using Snowflake DB
- Migrate OnPrem NAS Storage to AWS S3 buckets using AWS Snowball & AWS Data Sync
- TCO Reduction by 40%
- Improved operational efficiency and business transparency with single source of truth
- Enabled more informed decision making (Cost to serve, Member Profitability) for the client to expand their business
Related Case Studies
Case Study
A mission-critical government and business service provider migrates data to the cloud
Case Study
A very large healthcare conglomerate needed to consolidate multiple on-premise digital imaging and communications in medicine (DICOM) applications and migrate to the cloud.