Database Administration Services

PEER 1 introduces Database Administration (DBA) services, designed to keep your Microsoft SQL 2005 or your MySQL 4 and MySQL 5 databases running like clockwork. Our new proactive DBA services ensure your SQL Clusters or Single SQL server instances are performing at the highest level. The last thing you want to happen is your database crash and you lose important data. It could be very costly to your business. Take the next step and learn how our DBA services will help your business.

Our support team monitors your databases so you can concentrate on your business. You already trust PEER 1 to manage your server, now it's time to let us monitor your database for any potential problems and take corrective action as needed.

Hiring a qualified database engineer to manage your database in-house is expensive, costing your IT department more than $80,000 annually for one person. And there's no guarantee they will be available 24x7x365 to prevent your database from avoidable downtime. By working with a team of database solutions engineers and Certified Database Administrators at PEER 1, you get complete coverage when you need it the most.

Our DBA services engineers are available to help you with every aspect of your database from installation to design to maintenance and monitoring. Whether you need basic maintenance or a mission critical solution, we will develop a plan dedicated to your exact needs.

Service plans

All PEER 1 DBA service plans include these three primary components of solid database management:

• Design and implementation
• Maintenance
• Monitoring

DBA services will save you time, money, and help you avoid crippling database crashes. We offer three DBA service plans based on our most popular requests, each designed to give you the support you need to ensure your database remains online, all the time. Take a look at the three plans below and choose one that fits your needs.

	TIER 1	TIER 2	TIER 3
DESIGN / IMPLEMENTATION
Installation	Included	Included	Included
Initial database design assistance	-	Included	Included
Database objects creation	-	Included	Included
Security and vulnerability review	-	Included	Included
Database maintenance plan creation	-	Included	Included
Database schema changes	-	Included	Included
MAINTENANCE
Connectivity support	Included	Included	Included
24/7 database support	Included	Included	Included
Database patch management	Included	Included	Included
Troubleshooting assistance	Included	Included	Included
Database user account management	-	Included	Included
Database Cluster Support	-	-	Included
Cluster Monitoring	-	-	Included
Failover Monitoring	-	-	Included
Hardware Recommendations	-	-	Included
Cluster Troubleshooting	-	-	Included
Install/Configure Cluster Software	-	-	Included
MEASUREMENT
Database monitoring	Included	Included	Included
Database performance/tuning recommendations	-	Included	Included
Database recovery/restore from backup/logs	Included	Included	Included
Quarterly health check and review	-	Included	Included
Maintenance plan monthly check	-	Included	Included

Highlights

• Cost management – Purchase only those DBA services that you require, and only at the levels you need.
• Maintenance – DBA services engineers will create a maintenance plan where we assist with database creation including automated backups and scheduling non-automated maintenance tasks.
• Troubleshooting – DBA services engineers will troubleshoot connectivity issues with your server, database, and any PEER 1 network issues over TCP/IP protocol.
• Bugs – Database vendors occasionally release patches to fix specific bugs. DBA services engineers will install patches as they become available and report patches to you through a patch log maintained by PEER 1.
• Support – DBA services engineers will assist you 24x7x365 in troubleshooting physical hardware and database software.
• Complete clustering support – Our DBA services team will install, implement, monitor, and support managed MS SQL or MySQL Cluster setups in an Active/Passive configuration.
• SQL service monitoring – Full tcp/3306 monitoring in an open state plus full service SQL monitoring using an advanced API through Concord Monitoring.
• Performance tuning – Receive recommendations for improving database performance including rewriting queries and tweaking system parameters, thereby reducing potential bottlenecks that could slow or crash your database.
• Full statistics – Get full reports on physical disk I/O statistics, query execution time, CPU and memory usage, table locking statistics, and query cache hits.
• Full database recovery – Get full database backups and recovery via a local backup or remote backup or take advantage of our Enterprise level Tivoli backup solution.
• Overall health check – Receive quarterly reviews on how your database is doing including performance, maintenance, and suggestions on how to keep your database running in peak condition.