Common use of Physical Database Administration Clause in Contracts

Physical Database Administration. a. Vendor will: (1) provide physical support of Oracle, SQL Server, C-tree, Informix and DB2 application databases which includes: (a) creation of physical database objects (i.e., DDL, DBD, ACB, files); (b) management and performance of physical database maintenance, modifications and enhancements in accordance with the mutually agreed schedule; (c) maintaining mutually agreed database backup procedures, provided by ACI, to recover from database destruction or corruption or outage in accordance with the mutually agreed schedule; (d) maintaining and implementing mutually agreed database archive processes and procedures; (e) testing data recovery/backout procedures at least annually; (f) monitoring and reporting of database performance and space utilization, with database reorganization and/or expansion as required, and trend analysis of the data for the past 13 months in accordance with Schedule R (Reports), to support ACI reporting as needed; (g) recommending modifications for improved performance and implementing as approved by ACI; and (h) interacting and interfacing with logical DBA’s providing support for their design and implementation(s). (2) setup and retain exclusive use of DBMS system administration IDs and privileges; (3) provide physical database maintenance for development and test environments; (4) assist ACI in planning for database modifications as a result of changes in ACI’s business environment (i.e., growth, application development projects) and review ACI’s plans on a regular basis; (5) promote ACI-approved database changes into the production environment; Confidential Exhibit A-5 — Server Systems Management Services (6) develop, implement and maintain appropriate backout processes for changes where required; and (7) perform access grants to database objects as requested by ACI. b. ACI will: (1) provide requirements and approval for performing production database maintenance, modifications, enhancements and backups; (2) develop plan(s) for database modifications as a result of changes in ACI’s business environment (i.e., growth, application development projects) and review such plans with Vendor on a regular basis; (3) provide Vendor the approved database changes; (4) define database backup and recovery requirements; (5) perform logical database design and data modeling and cooperate with Vendor during physical database design and review; and (6) provide ACI’s access requirements (for example, name and authorization level) for database objects.