What are the Roles and Responsibilities of database administrator?
The Database
Administrator (DBA) is the super-user of the system.
The role of the DBA
is very important and is defined by the following functions.
Ø
Defining the Schema
The DBA defines
the schema which contains the structure of the data in the application. The DBA
determines what data needs to be present in the system and how this data has to
be represented and organized.
Ø
Liaising with Users
The DBA needs to
interact continuously with the users to understand the data in the system and
its use.
Ø
Defining Security &
Integrity Checks
The DBA finds
about the access restriction to be defined and defines security checks
accordingly. Data integrity checks are also defined by the DBA.
Ø
Defining Backup / Recovery
Procedures
The DBA also
defines procedures for backup and recovery. Defining backup procedures includes
specifying what data is to backed up, the periodicity of taking backups and
also the medium and storage place of the backup data.
Ø
Monitoring Performance
The DBA has to
continuously monitor the performance of the queries and take measures to
optimize all the queries in the application.