What are the functions of a Database Administrator?

0 votes
What are the roles and responsibilities of a Database Administrator? What does a Database Administrator do?
Dec 6, 2018 in Career Counselling by Kapoor
• 1,070 points
574 views

5 answers to this question.

0 votes
  • Monitor database and application levels and ensure work according to user privileges.
  • Design physical database and recommend optimizations of existing databases.
  • Determine development and test for various systems.
  • Ensure optimal performance of database
  • Provide support to SQL Server through various activities.
  • Ensure integrity of data.
  • Monitor database performance and monitor efficient working.
  • Prepare schedule for backup for various operating systems.
answered Dec 6, 2018 by Ajay
0 votes
The main job of a Database Administrator is to make sure the Database is running fine and keep it well maintained. For this, he will have to install the required software, upgrade the software and take care of the maintenance.
answered Feb 28 by Rina
0 votes
Database Administrator has to take care of the availability of the Database. Security, Authentication should be the main priority. They should identify the weakness of the Database and solve these issues. Should take care of Backup and Recovery process. Regular backup is important and if the Database crashes, immediate recovery should be made.
answered Feb 28 by Sneha
0 votes
Along with Security and Authentication as mentioned by @Sneha, troubleshooting is another important responsibility of a Database Administrator. Recovery is done when the whole system crashes but some times it might happen that only some part/feature of the Database is not working as expected. In such cases, troubleshooting is the quick fix.
answered Feb 28 by Shiva
0 votes
Database Administrator, along with maintenance and updating the database, should take care of performance tuning to make the best use of the Database. He should regularly keep monitoring the performance of the database and research on ways to improve the performance of the database.
answered Feb 28 by Rehan

Related Questions In Career Counselling

0 votes
3 answers

What are the roles and responsibilities of a linux administrator?

Hi, Basically, roles and  responsibilities vary from industry ...READ MORE

answered Jul 1 in Career Counselling by Gitika
• 19,720 points
59 views
0 votes
5 answers

What are the roles and responsibilities of a Data Scientist?

Following are one of the most important ...READ MORE

answered Feb 22 in Career Counselling by Barbara
124 views
0 votes
5 answers

What are the roles of a Big Data Engineer?

Adding to the above answers, a Data ...READ MORE

answered Jan 22 in Career Counselling by Kiran
73 views
0 votes
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,030 points
2,034 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,030 points
190 views
0 votes
10 answers

hadoop fs -put command?

copy command can be used to copy files ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Sujay
10,300 views
0 votes
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,240 points
754 views
0 votes
3 answers

What are the roles and responsibilities of a Database Architect?

Hey Ali, a Database Architect maintains database ...READ MORE

answered May 29 in Career Counselling by Himanshu
20 views
0 votes
3 answers

What are the roles of a data scientist

These are the high-level roles: Data mining and ...READ MORE

answered Feb 11 in Career Counselling by Mariam
43 views