logo for information-management-architect.com
leftimage for information-management-architect.com

Database Administrator Roles and Responsibilities

Improve accountability with David Bowman’s information management guidelines for information management roles

This site is designed for Information Technology professionals who need to improve accountability and require guidance and direction to establish information management roles.

It provides information management guidelines for database administrator roles and responsibilities and tasks and deliverables.

What is database management?

The data storage discipline focuses on the management of persistent data stores.  It covers such topics as database selection guidelines, backup and recovery procedures, data retention/archiving policies, and disaster recovery planning.

Development Database Administrator

A development database administrator (DBA) is responsible for creating the various environments required for development, test and production. They also work closely with the data architect and help with capacity planning.  Because of the unique characteristics of data warehouse and business intelligence databases, the development DBA is often dedicated to a data warehouse project, as opposed to being part of a pool of online transaction processing database administrators.

Database Administrator Roles and Responsibilities for Architecture
  • Should select target database management system;
  • Should create development, system test, integration test, user acceptance test and production environments;
  • Should consult on database capacity;
  • Should consult on database performance strategy;
  • Should create database availability strategy;
  • Should create database failure management strategy;
  • Should consult on data integration performance strategy;
  • Should consult on physical data model;
  • Should review and augment data quality criteria;
  • Should validate data quality  constraints in database;
  • Should consult on final source to target map;
  • Should consult on data architecture detail design checkpoint;
  • Should define storage needs;
  • Should define capacity plan; and
  • Should consult on data architecture specification checkpoint.
Database Administrator Roles and Responsibilities for Build and Test
  • Should generate development database;
  • Should build views;
  • Should generate system test database;
  • Should consult on promoting release to system test environment;
  • Should perform initial database tuning; and
  • Should consult on development checkpoint.
User Acceptance Test
  • Should generate user acceptance database;
  • Should consult on promoting release to user acceptance test environment;
  • Should consult on user acceptance test; and
  • Should consult on data architecture user acceptance test checkpoint.
Transition to Production
  • Should generate production database; and
  • Should consult on data architecture deployment checkpoint.
Production Database Administrator Roles and Responsibilites

A dedicated production support DBA takes ownership for the data warehouse as it transitions to production and has the following responsibilities:
  • Should be responsible for the physical instance of the development and production data warehouse environment;
  • Should perform query optimization reviews as a measure of prevention and when performance incidents occur that require immediate remedial action;
  • Should manage performance, database utilization and growth monitoring and tuning, backup and recovery;
  • Should establish database clustering and partitioning strategies;
  • Should promote test databases to the production environment;
  • Should implement and monitor backup and restore procedures; and
  • Should implement appropriate security scheme for the data warehouse.
Summary…

The data storage discipline focuses on the management of persistent data stores.  It covers such topics as database selection guidelines, backup & recovery procedures, data retention/archiving policies, and disaster recovery planning.

This site provided information management guidelines for database administrator roles and responsibilities, tasks and deliverables and best practices.