About Database Administration

The Database Administration (DBA) Group manages, secures and monitors the University's administrative and student data systems housed in the Data Center. This includes the administration and management of the actual application or software, the fixes/updates to the application or software as shipped from the vendor, the installation of custom code built by ASD, and the security of these data systems. As caretaker of the University's data systems, the DBAs advise ASD and SSD staff on how best to access/use the databases and make any agreed upon changes to accommodate user requirements.

The DBA Group:

  • Is also a flat organization with teams focusing primarily on: Core Systems, Development Support, and Upgrades - A senior DBA has been identified as the principal point of contact for each of these focus areas.
  • Established a DOD or 'DBA On Duty' - This responsibility is assigned on a weekly rotating basis. As the DOD, a DBA is the primary point of contact for the Group for all database issues during normal business hours. The DOD's primary responsibilities include triaging trouble tickets, providing developer support, monitoring production systems and fulfilling security requests.
  • Also established a DOC or 'DBA On Call' - This responsibility is also assigned on a rotating basis and, in contrast to the DOD, covers systems during all non-business hours. The DOC must carry their pager and cell phone so that s/he can be reached regardless of the time or where they may be. The DOC is charged to monitor the production systems, primarily, and correct any production critical problems as well as apply any necessary patches, fixes or custom code to production during non-business hours.
  • Continues to establish/document guidelines, procedures and standards for planning, administration and documentation.
 

Updated October 23, 2007