Our DBA service offers:

Preventative Maintenance

  • Database Housekeeping & Reports.
  • Monitoring database performance.
  • Monitoring replication.
  • Monitor, investigate and report on SQL Agent job failures.
  • Data file and disk space monitoring and management.
  • Database Index and statistics maintenance.
  • Integrity checks.
  • Review storage utilization and disk space growth planning.
  • Review and inform customer of deviations and breaches against security checklist.

Database Security Management

Apply Microsoft’s security standard and administer access accordingly, so that:

  • Data are only visible to users with authorised access.
  • Security related patches are applied when necessary.
  • Granting and revoking of user access to data is controlled.
  • User security is administered in accordance with the security standard.

Database Optimisation

  • Index tuning and performance monitoring to keep databases running optimally.
  • Configuration and tuning of server parameters in accordance with best practices.
  • Periodically reorganise / rebuild indexes to reduce fragmentation and maintain performance.
  • Monitor fragmentation and adjust index page fill values as necessary.
  • Identify hardware, software and process performance improvement opportunities and notify customer of these opportunities.

Database Architecture

  • Evaluation of customer supplied database design and preparation of recommendations for improvement on the design.

Database Quality Assurance

Quality assurance for database structure and code changes made to databases, covering:

  • Audit and evaluate database structures in accordance with industry standard best practices and customer’s standards and specifications.
  • Recommend changes to database design and formally raise issues where design does not conform to adopted standards and specifications.

Database Deployment

SQL Server version upgrades, applying SQL Server service packs and data migrations can be managed as part of agreed projects.

  • Notifying the customer when new service packs become available.
  • Applying service packs and patches as agreed with business systems owners.
  • Implement and rollback when required.
  • Deploy according to change management procedures.

Database Decommissioning

  • Ensure environment contains only those resources that are actually used and ensure final backups are created before databases are removed.

Database Availability Solutions

Evaluate customer’s availability requirements and design cost effective solutions in support of uptime requirements.

  • High Availability / Rapid Recovery.
  • Disaster Recovery.

Emergency Support

  • Provide 24 / 7 emergency support, 365 days a year, for all database related issues.
For more information, please contact us.