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
11,056 views

5 answers to this question.

+1 vote
  • 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
• 65,770 points
3,005 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
3,004 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
1,271 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
• 11,380 points
11,070 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
• 11,380 points
2,569 views
+2 votes
11 answers

hadoop fs -put command?

Hi, You can create one directory in HDFS ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
109,020 views
–1 vote
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,350 points
4,635 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
1,405 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
9,934 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP