Elastic Support Systems – ESS Model
Database / Data availability and support needs
Configuration and volume (Data/Transaction)
Ranges from as low as $750 to $10000 a month.
Monthly : 10000 USD – 150000 USD
Monthly : 7500 USD – 10000 USD
Monthly : 1000 USD – 5500 USD
Daily monitoring of Databases backups to disk
Weekly database re-indexing.
Weekly database consistency checks
Resolving backup failure issues
Resolving failed database services jobs
Review Database Configuration against best practice
Review Database and Database Agent error logs.
Review Windows/Unix Event log
Report on previous action points
Summarise work completed since the last report
Liaise with key customer contact.
Report changes to the Database environment
Update disk and database growth statistics
Verify backup and recovery process and timing
Update Database DBA documentation
Report on any Database incidents
Review Service Pack and hot fix levels.
Review Security configuration and login failures
Rebuilding Database in the event of failure
Reinstalling Database following hardware changes
Database Configuration changes
Resolution of any log shipping issues or failures
Management of cluster fail-over and fail-back process
Applying Database service packs and hot fixes
Investigate and resolve Database Consistency issues, SQL Alerts and errors
Investigate and resolve performance problems and user connectivity problems
Disk and database space management (outside of reporting frequency audit).
Database permissions for users
Restoring production databases
Copying production databases for testing
Liaison with application providers and users
Produce incident report following unplanned production systems downtime
Proactive monitoring & performance bottle necks
Review tuning requirements and present opportunities to customer
Tune and evaluate performance
Manage data loads and script automation
Manage transfer of data between databases by unix or db links
Optimize data architecture
As mutually negotiated with respect to client needs