Infrastructure Support – Database Administration PostgreSQL
- ATMECS – Content Team
Challenges:
- Limited documentation
- PGPOOL stability
- Limited alert setup for database functions
- Limited visibility on design considerations
Solution Approach:
- Database Provisioning
- Database Backups and Recovery
- Database Size Growth Monitoring
- DB Server CPU and Memory utilization monitor
- Database User Management
- Performing Database level application related changes
- Application Scripts deployments
- Data refreshments between the environments
- Database related maintenance tasks
- Database Monitoring
- Support to the Application Issues
- Achieve SLA’s
ATMECS Contribution:
- Implemented a robust monitoring system to monitor the PostgreSQL Services status and CPU, Memory and Disk level thresholds