Service Name
|
University Database Administration - MS SQL
|
| Description |
Provide the administrative tasks required to keep all of the instances of the Microsoft SQL Server Database Management System running at levels necessary to support the various applications using SQL Server.
|
Service Line
|
Administrative Systems
|
| Features |
- Plan, install, configure and test database configurations.
- Identify server, network and capacity requirements needed to operate databases.
- Decommission databases upon request.
- Provide database requirements to support procurement activities.
- Integrate database software assets in compliance with supporting 3rd party vendor requirements.
- Maintain information about installed database software and database configuration items and ensure accuracy and availability to others.
- Provide consulting services and support for release package testing, installation, deployment and operation.
- Provide troubleshooting and technical support services for databases.
- Coordinate, schedule, implement and test database tuning, reorganization, backup and restoration activities.
- Provide consulting and support services to identify database operational, monitoring and reporting requirements.
- Define physical and logical models for implementing and operating databases.
- Identify database capacity sizing needs land requirements and manage database performance and turning.
- Define, implement and test database security schemas per requested requirements.
- Maintain database Known Error and bug lists.
- Plan, design, build, implement, test and maintain database checkpoint restart mechanisms.
|
| Service Administrator (owner) |
Soren King
|
| VP Customer |
All Vice Presidents who have areas reporting to them that utilize and application built on MS SQL Server. |
| Availability |
The SQL Server DBMS is available 24 X 7 X 365 except during planned maintenance and upgrades.
|
| Support |
- Support is provided 8:30 am - 5:00 pm, M-F except for campus holidays and shutdowns.
- Trouble calls and programming requests to 864.294.3477 - helpdesk@furman.edu
|
| Initiated |
- Approved Work Requests
- Escalated Incidents or Problems from the Help Desk
|
| Charges |
none
|
Delivery channels
|
- Satisfied Work Requests
- Consulting and Support
|
| Prerequisites |
Functioning infrastructure, network, servers, and user interface
|
| Key Service Targets |
- If a database outage occurs then access will be restored within two hours or the problem will be escalated to the appropriate vendor.
- Normal requests, e.g., new users, permissions, will be handled within 24 hours.
|