1.4 Role of a Database Administrator

Typically there are three types of users for a DBMS. They are :

1. The End User who uses the application. Ultimately, this is the user who actually puts the data in the system into use in business. This user need not know anything about the organization of data in the physical level. She also need not be aware of the complete data in the system. She needs to have access and knowledge of only the data she is using.
2. The Application Programmer who develops the application programs. She has more knowledge about the data and its structure since she has manipulate the data using her programs. She also need not have access and knowledge of the complete data in the system.
3. The Database Administrator (DBA) who is like the super-user of the system. Individual in the association who controls the plan and the utilisation of the database alludes as DBA 

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 ad how this data has to be represented and organized. As per this construction, database will be produced to store required information for an association.
• Defining Storage Structure and Access Method: The DBA chooses how the information is to be spoken to in the put away database.
• Liaising with Users The DBA needs to interact continuously with the users to understand the data in the system and its use. The DBA figures out which client needs access to which part of the database
• Defining Security & Integrity Checks The DBA finds about the access restrictions 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 for 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.
  
• Assistance to Application Programmers: The DBA gives help to application software engineers to create application programs.

Above listed DBA's Roles are the same we learned from our text books. Practically Role of a DBA differ from association to association. In any case, the essential Roles that numerous DBAs are accused of are listed belows :

1. The First one is Install and configure Oracle software.
2. Taking Back up and planning for recovery of the database.
3. database schema designing and make required fundamental database objects. 
4. Design the database schema and create any necessary database objects.
5. Define ideal application SQL.
6. Execut Guarantee database security to defend the information. 
7. Work intimately with application engineers and framework chairmen to guarantee all database needs are being met. 
8. Apply patches to fixes or upgrade the database as per requirements.