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.

Rectangle 2151 (1)
Approach
  • Merge and consolidate three separate database entities
  • Migrate from on-premise database to AWS cloud
Rectangle 2151
Solution
  • 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
Rectangle 2151 (2)
Outcome
  • 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

A mission-critical government and business service provider migrates data to the cloud
A very large healthcare conglomerate needed to consolidate multiple on-premise digital imaging and communications in medicine (DICOM) applications and migrate to the cloud.