OVERVIEW OF ADMINISTRATION FUNCTIONS - Database Design and Development: An Essential Guide for IT Professionals - page 432

DBA Install selected DBMS.

DBA Install application interfaces.

DBA Define files for various tables.

DBA Define indexes and clustering of tables.

DBA Allocate physical storage to files and set data blocks.

DBA Define storage management parameters.

DBA/DA Define user views.

DBA Define entity and referential integrity constraints.

DBA Define data edits and business rules in data dictionary.

DBA/DA Complete data dictionary entries for all definitions.

DBA/DA Grant user privileges.

DBA/DA Test backup and recovery.

DBA Set concurrency control criteria.

DBA/DA Complete final testing.

DBA/DA Complete data conversions.

DBA Perform initial data loads.

DBA/DA Complete initial user training.

DBA/DA Initiate initial user support.

AFTER DEPLOYMENT

Administration tasks do not end with the deployment of the initial version of the
database system. They continue in several ways. The DBA continues to have many
responsibilities. He or she has to keep the database up and running with optimum
efficiency. In the postdeployment phase, the DA mostly gets involved when new
data requirements emerge or when the service levels decrease.
In each of the following sections, we have listed the significant tasks and indi-
cated the involvement of the DBA and DA.

Ongoing Functions

The DBA continues to perform many maintenance functions on an ongoing basis.
These are mainly routine maintenance functions, and the DA is rarely involved in
these activities.

DBA Monitor database usage by gathering statistics.

DBA Monitor usage by various user groups.

DBA Police and detect unauthorized database access.

DBA Watch space utilization and expand disk extents as data volume

increases.

DBA Organize and ensure periodic backups.

DBA Create and maintain recovery log files.