DBA has to supervise the database loading at the time of its implementation. Database implementationĭatabase has to be implemented before anyone can start using it. Complete support is given to the users who are new to database by the DBA. If any user needs help at any time then it is the duty of DBA to help him. One can say that DBA decides the structure of database files. DBA decides fields, types of fields, and range of values of the content in the database system. Decides content of the databaseĪ database system has many kind of content information in it. Yes f course, he has to monitor the performance of the database. If database is working properly then it doesn’t mean that there is no task for the DBA. So he always puts validation checks on data to make it more accurate and consistence. Decides validation checks on dataĭBA has to decide which data should be used and what kind of data is accurate for the company. No user has to power to access the entire database without the permission of DBA. He decides the users of the database and also which data is to be used by which user. Database accessibilityĭBA writes subschema to decide the accessibility of database. Also a DBA is responsible for physical design, external model design, and integrity control.
The logical design of the database is designed by the DBA. DBA has to decide the limit and capacity of database and all the issues related to it. Capacity IssuesĪll the databases have their limits of storing data in it and the physical memory also has some limitations. So by tuning an modifying sql commands a DBA can improves the performance of database. If user is not able to fetch data speedily then it may loss company business. Tuning Database Performanceĭatabase performance plays an important role for any business. Also the recovery of data base is done by DBA if they have lost the database. DBA has to decide that how much data should be backed up and how frequently the back should be taken. It is require that a DBA takes backup of entire database in regular time span.
If any company is having a big database, then it is likely to happen that database may fail at any instance. DBA manages relationship between the data to maintain data consistency. Managing Data Integrityĭata integrity should be managed accurately because it protects the data from unauthorized use. It is hardware that is an interface between end users and database so it needed to be of best quality. Deciding the hardware deviceĭepending upon the cost, performance and efficiency of the hardware, it is DBA who have the duty of deciding which hardware devise will suit the company requirement.
#Database administrator software#
There are many database software like oracle, Microsoft SQL and MySQL in the industry so DBA decides how the installing and configuring of these database software will take place. He configure the software of database and then upgrades it if needed. Installing and Configuration of database: DBA is responsible for installing the database software. Role, Duties and Responsibilities of database Administrator ( DBA) Now let us discuss what are the main role and duties of Database Administrator (DBA). In a nut shell, A DBA is the controller of everything related to database system. There are very rare chances that only a single person can manage all the database system activities so companies always have a group of people who take care of database system. This job requires a high level of expertise by a person or group of person. A Database Administrator is a person or a group of person who are responsible for managing all the activities related to database system.
0 kommentar(er)
