Database Administration SQL Server
- ATMECS – Content Team
Challenges:
- Limited documentation
- Competing priorities
- Limited alert setup for database functions
- Application dependency on lower functions
Solution Approach:
- SQL Server Provisioning
- SQL Server Upgrade
- SQL Server Monitoring to keep alive(24*7)
- Disk Spaces, CPU and Memory verification
- Database Backups and Recovery
- Database refresh from higher to lower environment
- Database Patching
- Database User Management
- Database Indexes
- Debugging Application related DB issues
- Achieve SLAs
ATMECS Contribution:
- Implemented a robust monitoring system to monitor SQL Services status and CPU, Memory and Disk level thresholds
- Placed a PowerShell script to monitor and report all the error events in production error logs
- Automated the process to perform DB refresh from higher to lower environments
- Automated the process to rebuild index offline/online on periodic basis
- Placed scripts to generate various types of application reports
- Developed jobs for Index Optimization
- Developed scripts to auto failover the SQL Instances