24×7 DBA Support

Ensuring round the clock database availability for Americas Private Beverage company

Client
One of North America’s most diversified and successful private beverage company

Industry
Food & Beverages

The Client

One of North America’s most diversified and successful private beverage companies focused on the alcohol beverage sector.

The Challenge

To provide 24*7*365 monitoring of database availability and setup of Disaster Recovery environment.

The Solution

Monitoring of database environment to eliminate performance issues, CPU, System Memory, backup and recovery was done round the clock. Database reconfiguration and reorganizations for performance improvement, database refresh, database Dump & Load and Index Rebuild were done as part of the ongoing maintenance of the system.

Disaster recovery scripts for monitoring the database extent to avoid database shutdown due reaching maximum, for monitoring file growth to check the long running transactions, for monitoring database log file growth which helps in analyzing errors in log file faster and maintain disk space.

The Benefits

Ensures round the clock production support for all your Progress / QAD and other interfaces to keep the business running with less downtime. Having processes in place to ensure smooth running of the system and fall back on a disaster recovery system in case of downtime.