Answers.com > Wiki Answers > Categories > Technology > Computers > Computer Programming > Database Programming > What are the responsibilities of database administrator?

What are the responsibilities of database administrator?

Answer:

Answer

  • 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.
  • 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 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.
First answer by ID1389268764. Last edit by ID1389268764. Question popularity: 24 [recommend question].

Can you answer these Database Programming questions?

What is the topic for management information system project? Answer it!
What does Row Detail determine in database? Answer it!
What is a view in oracle? Answer it!
What is data portability? Answer it!
What is the future of databases in web information systems? Answer it!

Relevant answers:

Home

Answer these

How much for a power steering line if you buy it from the Nissan dealer?
In: Power Steering
Answer it!
What dose mercury weigh?
In: Planet Mercury
Answer it!
How do they call a baby horse?
In: Care of Horses
Answer it!
What are the facts on the monster high DS game?
In: Nintendo DS
Answer it!
» more

Recent questions

Featured guides

» More