Database management and automation for improved performance

Client

The client is a global IT services provider working with public and private sector organizations managing their mission-critical business processes and the underlying IT systems. An FTSE 250 company, the client employs 50,000 people across the globe.

Business Goal

The client had a sprawling onsite database infrastructure (500+ database instances) meant to support day-to-day operations of multiple end customers. The environment was sub-optimal resulting in low service availability. This had an impact on the responses to pubic emergencies and communication between the public and local governments.

The client needed to ensure an integrated and highly available database management structure and enhance database performance through implementation of industry best practices such as Performance Diagnosis, Capacity Management, etc. In addition, the client wanted to leverage the opportunity to optimize operations and database maintenance costs.

Microland Solution

Microland segregated the operational roles and responsibilities between an optimal combination of onshore (client site) and offshore resources. Apart from implementing industry best practices and providing 24X7 support for databases, Microland delivered:

• Exception notification and management on performance
• Monthly back up report and regular reviews
• Monthly installation report, patch management report and performance management report
• Daily database health check automation
• Automation of redundant tasks

The technology landscape included:

• 400 SQL Server instances
• 100 Oracle instances

Business Outcomes

Microland ensured that the cost of operations was optimized through round-the-clock proactive support and a flexible delivery model. Microland’s interventions achieved the following benefits:

• 15% reduction in database maintenance costs
• >99% database availability
• 25% improvement in employee productivity
• 50% reduction in manual effort for troubleshooting