Leveraging scalable infrastructure for SQL server migration to achieve cost savings for a global healthcare and pharmaceutical company
A global healthcare and pharmaceutical company with multibillion USD revenue. The client has 3 global businesses that research, develop & manufacture, innovative pharmaceutical medicines, vaccines & consumer healthcare products. The company also has investments in various other industries like CPG, etc.
The Customer was looking for insights into sales patterns of its various goods across a particular geography, region, state or country. The insights had to be derived from huge terabytes size sales data. Sales team utilized these insights to create strategy plans in advance on Month on month basis.
Large amount of compute and storage capacity had to be provisioned in advance to meet the peek requirements during month end. There was a need for a scalable and highly available infrastructure.
"The Customer was looking for insights into sales patterns of its various goods across a particular geography, region, state or country."
After an initial assessment, Mindtree provided a roadmap for migrating databases, implementing SSIS packages & analytical algorithms (written in R & Python) on Azure. The roadmap addressed the challenges of bandwidth constraints, modiﬁcations of SSIS packages, and integration of SQL on VM’s with Azure SQL, as many stored procedures had cross-database queries.
The migration sequence of SQL Server databases was planned based on criticality and approved downtime. To avoid any disruptions, Azure SQL VM’s were provisioned using HA patterns. Floating licenses were utilized to keep license costs under control. Azure DMA and other migration tools were leveraged to assist quick and reliable migration and optimize the use of bandwidth. Immutable infrastructure was achieved with the help of ARM templates.
"Mindtree provided a roadmap for migrating databases, implementing SSIS packages & analytical algorithms (written in R & Python) on Azure."
Due to the scalable infrastructure, performance gains upward of 20% were achieved while keeping the cost in control without any business disruption. Additionally, Mindtree was able to deliver on its promises of:
- First-time right execution
- Resilient infrastructure that meets business requirements of > 99% availability
- No impact on ongoing business, thanks to zero unscheduled downtime during migration
- Developing new revenue/business models