Shared SQL Server

Shared SQL Server

About Shared SQL Server

This service provides a Shared Database Server Cluster located at the State's cloud environment managed hosting facility based on agencies/boards/commissions availability requirements, excluding maintenance windows. This service also provides a relational database management system to handle routine database operations and maintenance on behalf of state agencies.

What problems it solves

This solution helps provide agencies and boards with a server cluster and professionally managed SQL servers, eliminating the database server and license costs allowing the internal agency to redirect resources to be used for higher-value business objectives rather than routine operational and maintenance tasks.

What the Service provides
  • A Shared Database Server Cluster located at the State managed cloud environment data facility
  • A team of experienced professionals to handle routine database operations and maintenance on behalf of state agencies
  • Database administration service to assist with managing SQL server
  • Database administration support provided on a monthly basis includes:
    • Database table maintenance
    • Backups
    • Monitoring of the database system
    • Database Management System (DBMS) tuning
  • Professional guidance on:
    • Architecture design
    • Administration
    • Monitoring and troubleshooting for dedicated infrastructure/cloud server platforms
Benefits of this Service
  • Optimization of database performance according to application requirements
  • Adds value to online presence
  • An experienced team of professionals to ensure maximum utilization
  • Guidance from experts in the field
  • Eliminates the need for hiring database administration personnel
  • Eliminates the database server and license costs
  • Enhancement of security due to the exclusive use of dedicated professional resources

Billing Unit: Database [100MB or less = 1 unit; 100MB-1GB = 1.5 units; 1GB-5GB = 2 units; 5GB+ = 3 units]
Billing Code: 8275

 

Eligible Customers
  • All State Agencies, Boards and Commissions
Service Prerequisites
  • Database access from customer is restricted within the State network (either through VPN connection or Application/Web server) only
Scope of Service
  • ASET Responsibilities:
    • DBMS monitoring and performance tuning
    • DBMS environment troubleshooting and problem resolution assistance
    • Perform DBMS (system) and Application Database Backup for use during Disaster Recovery
    • Management and completion of database-related customer service requests and issues
    • Support and facilitate cross-training of database administration staff
    • Maintain DBMS environment documentation which includes customer specific attributes with respect to the DBMS environment
    • All other requests for database administration assistance shall be provided following a receipt of a customer request and invoiced on a Time & Materials (T&M) basis according to the Database Specialist (Hourly) support rates published on the ADOA-ASET Service Catalog Rates page
  • Customer Responsibilities:
    • Coordinate DRM requests with Applications support team(s)
    • Attain authorization through the ADOA-ASET Security Group as required
    • Provide ADOA-ASET with customer contact information for the following:
      • Authorized Requestors
      • Authorized Approvers
      • Technical Contacts
    • Request assistance or support via the Cherwell Customer portal. Click on ADOA-ASET Service Desk. Select Database Support then Database Hosting.
    • Authorize activities in support of DBMS environment
    • Pay monthly fees associated with the use of the service
    • Customer agrees to provide ADOA-ASET authority to act on their behalf in case of an incident that requires immediate action outside of normal business hours
  • Shared Responsibilities:
    • In case of disaster and by customer request, coordinate customer's database recoverability with DBMS configuration, Point in Time Recovery and Point in Time Backup with Applications and Support teams
Service Commitment
  • Response Time: 24 - 48 hours (depending on severity)
  • Resolution Time: Dependent on issue
  • Support Time: 8AM - 5PM Monday - Friday
Related Services
How to order this Service

To order this service or for any questions related to it, please reach out to your Engagement Manager. Click here for a full list of Engagement Managers by Agency. Alternatively, click here to submit a Contact form (select Subject "Engagement Management").