Clicky

Infrastructure Support

Database Administration PostgreSQL

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