Common use of Database Administration Clause in Contracts

Database Administration. (a) Database administration support Services are those Functions associated with the maintenance and support of existing and future databases (e.g. MS SQL server, Oracle, DB2, etc.). Supplier’s responsibilities in this regard include: (i) Managing data, data set placement, database performance, and data recovery and integrity at a physical level; (ii) Performing database restores from export/DB dumps or backups; (iii) Implementing new database configuration; (iv) Performing database tuning, (v) Seting up test & development database environments; (vi) Supporting application upgrades including those for enterprise applications (e.g. PeopleSoft); (vii) Scheduling and monitoring nightly database back-ups; (viii) Performing database Init Parameter modifications; (ix) Managing and cleaning the database audit trail and archive logs; (x) Supporting database distributed option; (xi) Performing database upgrades and patches; (xii) Performing database monitoring including automatic trouble ticket generation for Problems; (xiii) Performing security administration including managing role and user database permissions in accordance with Health Net policies; (xiv) Performing security administration including managing role and user database permissions in accordance with Health Net policies; (xv) Ensuring data integrity and implementing corrections; (xvi) Performing database support activities, including: (A) Managing database availability and resources; (B) Managing database space (allocated and used); (C) Performing day-to-day operational database capacity planning and performance tuning; (D) Performing physical database maintenance (including running of appropriate utilities, jobs, and working problems/updates to existing jobs as required); (E) Support data loads and unloads as required; (F) Monitoring the size of the physical database objects; and (G) Performing database reorganization, including to improve performance and reclaim space. (xvii) Providing physical DBMS support for production application databases; (xviii) Executing and completing imports for data restores; (xix) Creating new databases and objects; (xx) Performing schema changes (e.g. creation, alteration, and deletion of tables and indices, compilation and dropping of stored procedures and triggers); (xxi) Establishing and maintaining database configuration and system parameters in a consistent manner across like database environments; (xxii) Executing processes for the proper maintenance and functioning of databases, e.g. updating table/index statistics, dropping and rebuilding tables/indices, etc.; (xxiii) Determining file reorganization requirements, schedule and run reorganizations; (xxiv) Managing database changes in accordance with Section 2.17 and with the Health Net’s change management policies and procedures; and (xxv) Maintaining operational database documentation and the physical DBA support process and desk-side procedure documentation.

Database Administration. (a) Database administration support Services are those Functions associated with the maintenance and support of existing and future databases (e.g. MS SQL server, Oracle, DB2, etc.). Supplier’s responsibilities in this regard include: (i) Managing data, data set placement, Performing logical database performance, and data recovery and integrity at a physical leveldesign for Supplier-developed applications; (ii) Performing physical database restores from export/DB dumps or backupsdesign for development and test databases; (iii) Implementing new Performing database configurationtuning for test and development environments; (iv) Performing database SQL tuning,; (v) Seting up test & development database environments; (vi) Supporting application upgrades including those for enterprise applications (e.g. PeopleSoft); (vii) Scheduling and monitoring nightly database back-ups; (viii) Performing database Init Parameter modifications; (ix) Managing and cleaning the database audit trail and archive logslogs in development and test environments; (x) Supporting database distributed option; (xi) Performing database upgrades and patches; (xiivi) Performing database monitoring including automatic trouble ticket generation for Problemsdevelopment and test environments; (xiiivii) Performing database security administration for development and test environments, including managing role and user database permissions in accordance with Health Net policies; (xiv) Performing security administration including managing role and user database permissions in accordance with Health Net policies; (xvviii) Ensuring data integrity and implementing corrections; (xviix) Performing database support activitiesactivities for development and test environments, including: (A) Managing database availability and resources; (B) Managing database space (allocated and used); (C) Performing day-to-day operational database capacity planning and performance tuning; (D) Performing physical database maintenance (including running of appropriate utilities, jobs, and working problems/updates to existing jobs as required); (E) Support Performing data loads and unloads as required; (F) Monitoring the size of the physical database objects; and; (G) Performing database reorganization, including to improve performance and reclaim space.; and (xviiH) Performing grants, revokes, synonyms and aliases. Schedule A A-30 Health Net / Cognizant Confidential Final Execution Version (x) Providing physical DBMS support for production development and test application databases; (xviiixi) Executing and completing imports for data restoresrestores in development and test environments; (xixxii) Creating new databases and objectsobjects in development and test environments; (xxxiii) Performing schema changes in development and test environments (e.g. creation, alteration, and deletion of tables and indices, compilation and dropping of stored procedures and triggers); (xxixiv) Establishing and maintaining database configuration and system parameters in a consistent manner across like database development and test environments; (xxiixv) Executing processes for the proper maintenance and functioning of development and test databases, e.g. updating table/index statistics, dropping and rebuilding tables/indices, etc.; (xxiiixvi) Determining file development and test database reorganization requirements, schedule and run reorganizations; (xxiv) Managing database changes in accordance with Section 2.17 and with the Health Net’s change management policies and procedures; and (xxvxvii) Maintaining development and test operational database documentation and the physical DBA support process and desk-side procedure documentation.; (xviii) Ensuring recoverability of development and test databases based on Health Net requirements; (xix) Ensuring performance of development and test databases based on Health Net requirements; (xx) Ensuring availability of development and test databases based on Health Net requirements; (xxi) Ensuring security of development and test databases based on Health Net requirements; (xxii) Providing DBMS expertise and guidance to development staff; and (xxiii) Performing development and test database administration Services, including those Functions listed in the roles and responsibilities table below, except for those Functions that are expressly identified as retained Health Net responsibilities. Table 16. (DBA) Planning and Analysis Roles and Responsibilities Planning and Analysis Roles and Responsibilities Supplier Health Net 1. Provide infrastructure specification, planning and analysis requirements for new applications. X 2. Provide estimates to support technical planning for capacity and performance. X 3. Monitor management reports for utilization trend analysis and provide growth forecasts. X Schedule A A-31 Health Net / Cognizant Confidential Final Execution Version Planning and Analysis Roles and Responsibilities Supplier Health Net 4. Recommend Health Net data backup and retention policies and requirements. X 5. Implement infrastructure, and maintain approved backup and retention policies. X 6. Approve infrastructure, Health Net data backup and retention policies and requirements plan. X Table 17. (DBA) Technical Infrastructure Engineering/Development Roles and Responsibilities Technical Infrastructure Engineering/Development Roles and Responsibilities Supplier Health Net 1. Support developing recommendations of partitioned resources and/or server domains for application performance/processing. X

Database Administration. (a) Database administration support Services are those Functions associated with the maintenance and support of existing and future databases (e.g. MS SQL server, Oracle, DB2, etc.). Supplier’s responsibilities in this regard include: (i) Managing data, data set placement, Performing logical database performance, and data recovery and integrity at a physical leveldesign for Supplier-developed applications; (ii) Performing physical database restores from export/DB dumps or backupsdesign for development and test databases; (iii) Implementing new Performing database configurationtuning for test and development environments; (iv) Performing database SQL tuning,; (v) Seting up test & development database environments; (vi) Supporting application upgrades including those for enterprise applications (e.g. PeopleSoft); (vii) Scheduling and monitoring nightly database back-ups; (viii) Performing database Init Parameter modifications; (ix) Managing and cleaning the database audit trail and archive logslogs in development and test environments; (x) Supporting database distributed option; (xi) Performing database upgrades and patches; (xiivi) Performing database monitoring including automatic trouble ticket generation for Problemsdevelopment and test environments; (xiiivii) Performing database security administration for development and test environments, including managing role and user database permissions in accordance with Health Net policies; (xiv) Performing security administration including managing role and user database permissions in accordance with Health Net policies; (xvviii) Ensuring data integrity and implementing corrections; (xviix) Performing database support activitiesactivities for development and test environments, including: (A) Managing database availability and resources; (B) Managing database space (allocated and used); (C) Performing day-to-day operational database capacity planning and performance tuning; (D) Performing physical database maintenance (including running of appropriate utilities, jobs, and working problems/updates to existing jobs as required); (E) Support Performing data loads and unloads as required; (F) Monitoring the size of the physical database objects; and; (G) Performing database reorganization, including to improve performance and reclaim space; and (H) Performing grants, revokes, synonyms and aliases. (xviix) Providing physical DBMS support for production development and test application databases; (xviiixi) Executing and completing imports for data restoresrestores in development and test environments; (xixxii) Creating new databases and objectsobjects in development and test environments; (xxxiii) Performing schema changes in development and test environments (e.g. creation, alteration, and deletion of tables and indices, compilation and dropping of stored procedures and triggers); (xxixiv) Establishing and maintaining database configuration and system parameters in a consistent manner across like database development and test environments; (xxiixv) Executing processes for the proper maintenance and functioning of development and test databases, e.g. updating table/index statistics, dropping and rebuilding tables/indices, etc.; (xxiiixvi) Determining file development and test database reorganization requirements, schedule and run reorganizations; (xxiv) Managing database changes in accordance with Section 2.17 and with the Health Net’s change management policies and procedures; and (xxvxvii) Maintaining development and test operational database documentation and the physical DBA support process and desk-side procedure documentation; (xviii) Ensuring recoverability of development and test databases based on Health Net requirements; (xix) Ensuring performance of development and test databases based on Health Net requirements; (xx) Ensuring availability of development and test databases based on Health Net requirements; (xxi) Ensuring security of development and test databases based on Health Net requirements; (xxii) Providing DBMS expertise and guidance to development staff; and (xxiii) Performing development and test database administration Services, including those Functions listed in the roles and responsibilities table below, except for those Functions that are expressly identified as retained Health Net responsibilities. 1. Provide infrastructure specification, planning and analysis requirements for new applications. X 2. Provide estimates to support technical planning for capacity and performance. X 3. Monitor management reports for utilization trend analysis and provide growth forecasts. X 4. Recommend Health Net data backup and retention policies and requirements. X 5. Implement infrastructure, and maintain approved backup and retention policies. X 6. Approve infrastructure, Health Net data backup and retention policies and requirements plan. X 1. Support developing recommendations of partitioned resources and/or server domains for application performance/processing. X