Database Administration

OCIO Database Hosting Services provides the database (DB) infrastructure required to support business applications and IT Hosting for your organization. In conjunction with Distributed Hosting services, we install and maintain the database resource to ensure data integrity and security, as well as appropriate levels of availability and recoverability. We provide on-call support to maintain the resource at the level required to meet your system availability needs. Database hosting services will maintain system administration rights to the database while customizing the granting of full application database authority needed by your Applications Database Administrators (DBAs) to maintain and support your application.

Database hosting and database administration services are provided for Oracle, Microsoft SQL Server and Software AG Adabas database management systems hosted on multiple server platforms including Windows, Solaris, Linux and the Mainframe.   

Database Installation and Maintenance

  • Install and customize database software and related connectivity software on the hardware platform.
  • Perform database upgrades and patching as deemed mandatory by database software vendor, or as necessary to support application functionality.  
  • Analyzing requirements and making recommendations on database configurations.
  • Performing database problem analysis and resolution, coordinating with database vendor and application developer.  
  • Provide technical and configuration data for planning and reporting.

Database Monitoring and Performance Tuning

  • Perform database configuration, tuning and optimization functions to meet performance service levels.
  • Monitor system activity for identification and correction of performance issues including response time, throughput and network load.
  • Perform physical storage and data file allocation and monitoring.
  • Manage database space allocation and transaction and database logs.

Database Security

  • Configure, monitor and maintain database security to security technical implementation guidelines.
  • Maintain the security and integrity of the database and client data.
  • Manage system-level user ids, passwords, and access authorities.

Database Backup and Recovery

  • Plan and implement structured backup and recovery strategy, including “Hot” and “Cold” database backups, transaction log archival, and logical (export) backups.
  • Clone databases and perform unscheduled restores to resolve problems as needed.
  • Perform database restores as part of Disaster Recovery Testing.