Explain the Role of a database administrator

a. Defining the Schema 

 The DBA describes the schema which consists of the structure of the data in the application.

The DBA defines what data needs to be present in the system ad how this data has to be denoted and organized. 

b. Liaising with Users 

The DBA wants to interact continuously with the users to understand the data in the system and its employ.

c. Defining Security & Integrity Checks 

 The DBA finds out about the access restrictions to be defined and demonstrates security checks accordingly. Data Integrity checks are as well defined by the DBA.

d. Defining Backup / Recovery Procedures 

 The DBA as well defines processes for backup and recovery. Defining backup procedures involves specifying what data is to backed up, the periodicity of taking backups and as well the medium and storage place for the backup data. 

E. Monitoring Performance 

The DBA has to incessantly check the performance of the queries and take measures to optimize all the queries in the application.

Posted Date: 5/6/2013 3:29:31 AM | Location : United States

Ask an Expert

Related Discussions:- Explain the role of a database administrator, Assignment Help, Ask Question on Explain the role of a database administrator, Get Answer, Expert's Help, Explain the role of a database administrator Discussions

Write discussion on Explain the role of a database administrator
Your posts are moderated

Write your message here..

Related Questions

What is dml (data manipulation language)?, This language that enable user m... This language that enable user manipulate to or access data as organized by appropriate data model. Low level or Procedural DML : DML needs a user to specify what data ar

Project, Preliminary entities and attributes of human resourse management d... Preliminary entities and attributes of human resourse management database management system

Synonyms, Synonyms It allows short names or alternative names for objects.... Synonyms It allows short names or alternative names for objects. Example :               CREATE SYNONYM D30               FOR EMPD30;   Now if we give command:

Which component is not included in database environment, Which component is... Which component is not included in database environment ? A users component is not included in database environment.

What three major types of actions includes databases, What three major type... What three major types of actions includes databases? Briefly discuss these The three major types of actions including databases are: (i) Defining: It includes specifyin

Explain er relationship model, Explain ER Relationship model? An entity... Explain ER Relationship model? An entity-relationship model (ERM): An entity-relationship model (ERM) is an abstract theoretical illustration of structured data. Entity-relatio

Shadow copy, why shadow copy technique is used? why shadow copy technique is used?

Database design and documentation, A use case diagram giving a pictorial ov... A use case diagram giving a pictorial overview of user requirements and brief use case descriptions. As the case study contains only an outline of a business scenario, you will als

Calculate the joint probability, Consider the following frequency counts o... Consider the following frequency counts of some itemsets in a transaction database r : freq({A}, r) = 0.405 freq({B}, r) = 0.510 freq({C}, r) = 0.303 freq({A

Many-to-many relationship, For each m:n relationship type R, we make a new ... For each m:n relationship type R, we make a new table (say S) to represent R. We also contain the primary key attributes of both the participating entity types as a foreign key att