Roles and Responsibilities of DBA

  • Policy Formulation and Implementation - DBA formulates policies and communicates these policies to users. Among these policies are those covering access privilege, security, disaster planning, and archives.
    • Access Privileges - Access to every table and field in the database is not a necessity for every user.Database Management System

    • Security - Security refers to the prevention of unauthorized access to the database.
      Once access privilege have been specified and security features are in place, DBA draws up policies to explain the security privileges and then distributes these policies to authorized users.
    • Disaster Planning - A database may be harmed by some physical problems or by some natural disasters.
      For this the DBA's responsibility is to establish and implement backup and recovery procedures.
    • Archives - This tells that data need to be kept in the database for only a limited time.
      A data archive is a place where a record of certain corporate data is kept.
  • Data Dictionary Management - Data dictionary contains a wider range of information, including at the very least, information on tables, indexes, and programs.
    The creation and distribution of appropriate reports from the data dictionary is another of DBA's responsibility.
  • Training
  • DBMS Support - DBA is responsible for all the aspects of a DBMS within an organization, including the selection and maintenance of the system.
    • DBMS Evaluation and Selection - DBA is responsible for the evaluation and selection of the DBMS. In order to over see this responsibility, it sets up a check list.
      DBA must evaluate each prospective purchase of a DBMS in terms of all the categories.
    • DBMS Responsibility - DBA installs the DBMS in a way that is suitable for the organization.
      If the DBMS configuration need to be changed, DBA makes the changes.
  • Data Base Design - DBA is in charge of database design at both the information level and the physical level.
    It is also in charge of evaluating changes in requirements to determine whether a change in the database design is warranted. If so, DBA makes the changes and reports it to affected users.