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
1,686 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, 2019 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, 2019 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, 2019 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, 2019 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, 2019 in Career Counselling by Gitika
• 25,440 points
147 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, 2019 in Career Counselling by Barbara
324 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, 2019 in Career Counselling by Kiran
111 views
0 votes
3 answers
+1 vote
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,840 points
3,859 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,840 points
527 views
+1 vote
11 answers

hadoop fs -put command?

put syntax: put <localSrc> <dest> copy syntax: copyFr ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Aditya
20,412 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,290 points
1,444 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, 2019 in Career Counselling by Himanshu
56 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, 2019 in Career Counselling by Mariam
102 views