IT Shared Services Catalog

Database Hosting - Service Detail

Service Detail

Summary of Responsibilities

Database Hosting – Shared

Database Hosting – Dedicated

DML  Administration Tasks

Customer Application

Customer/Vendor

DDL Administration Tasks

Admin

Customer/Vendor

Access and Administration (e.g., sysadmin) of the core database platform (engine)

Admin

Customer/Vendor

Admin Database Utilities Administration (patches, upgrades, etc.)

Admin

Admin

Admin Database Software Administration (patches, upgrades, etc.)

Admin

Admin

 

Definitions

  • DML (Data Manipulation Language): Database administration tasks that include activities such as: retrieve, store modify, delete, insert and update data in a database.

  • DDL (Data Definition Language): Database administration tasks that include activities such as: creation and/or modification of the structure of database objects in a database management system

1. For the two database hosting service offerings (Dedicated and Shared), Admin provides the following:

Database Software Installation and upgrade

  • Install and upgrade of database management software.

  • Install and upgrade of database management utility software.

  • Apply functional patches, service packs, security patches, and bug fixes to database management software.

  • Apply functional patches, service packs, security patches, and bug fixes to database utility software.

2. Additional features with Database Hosting - Shared service offering:

Basic Database System administration

  • Database availability monitoring.

  • Database specific performance tuning and troubleshooting.

  • Collaboration with agency support teams to troubleshoot database application performance issues.

  • Database job scheduling.

  • Database data exports.

Database System Level Configuration

  • Coordinate with Admin Enterprise Storage teams to allocate storage for initial database installation based on Admin database storage best practices.

  • Work with the agency application data owners to determine future storage needs.

  • Create the database / database instance.

  • Create the database tablespaces / database files.

  • Create the database schema owners.

  • Grant database system privileges to Agency application owners.

  • Manage the database instance configuration settings, including the amount of server memory and how it is allocated.

  • Control and monitor the number of concurrent user connections.

  • Work with the server system administrators to configure server operating system parameters.

  • Work with the server system administrators to configure and apply the relevant operating system patches.

Database Systems Maintenance

  • Administration of databases to ensure that each Admin-managed database is available during the defined target availability hours.

  • Maintenance of databases to ensure that each Admin-hosted database is performing optimally during the defined target availability hours.

  • Documentation of major changes to the database servers.

Database Systems Support and Monitoring

  • Ensure databases are sized properly.

  • Ensure database logs are sized properly.

  • Increase / add storage for database files as required.

  • Configure new storage space for database files as required.

  • Execute the necessary parameter adjustments to the system configuration settings for performance optimization.

  • Responsive support to unscheduled service outages in a timely manner.

  • Escalate system database software problems to vendor standard for resolution.

  • Proactive monitoring of database with Admin monitoring tools.

  • Leverage database diagnostic information to assist with agency database issue resolution. Admin will work to determine and solve any database infrastructure issues and relay needed information to the customer.

Related Services

A Database Hosting customer might also be interested in these Admin services which are offered separately:

Service Level Objectives

Service Level Targets

TBD