What is the role of a database administrator in a database management system?

Database installation and configuration: The database administrator is responsible for installing the database software. He sets up the database software and upgrades as necessary. Because there are many database software such as Oracle, Microsoft SQL, MySQL, etc. in the industry, DBA will decide how to install and set up these database software.

Depending on the cost, performance and efficiency of the hardware, the DBA will determine which hardware design meets the company's requirements. Hardware is the interface between the end user and the database, so the highest quality is required.

Since data integrity protects data against unauthorized use, it must be managed accurately. DBA manages relationships between data to maintain data integrity

If a company owns a large database, the database may fail in any situation. The DBA needs to periodically back up the entire database. The DBA needs to determine the amount of data to be backed up and its frequency. When the DBA loses the database, the database is also recovered by the DBA.

Database performance plays an important role in every business. If the user can not obtain the data quickly, the business of the company may be lost. Therefore, the DBA can improve the performance of the database by adjusting the sql command.

All databases have restrictions on the storage of data, and physical memory has some limitations. Database administrators need to determine the limit and capacity of the database and all the problems associated with it.

The logical design of the database is designed by the DBA. The DBA is also responsible for physical design, external model design, and integrity management.

DBA writes a submode to determine database accessibility. He will decide which users in the database and which users will use which data. Users do not need to access the entire database without a DBA license.

The DBA needs to determine the data to use and the company's exact data type. Therefore, he always checks to make the data more accurate and consistent.

The database administrator (DBA) is the person who manages the database of the organization. This person creates and maintains a database that is used as part of an application or data warehouse. DBA also negotiates with system analysts and programmers who need to access or create database projects. Most medium to large organizations have their own information technology service desk. Service desk is the first line to support corporate computer users. Computers users with problems or need information can contact the help desk for assistance. In many cases, the help desk staff is a junior and he does not necessarily know how to answer all the questions he or she encountered. In such a case, helpdesk analysts will work with senior support analysts or use the computer's knowledge base to investigate immediate problems.

Wikipedia (2011) defines a database management system as a series of computer programs that control the creation, maintenance, and use of databases. This allows organizations to provide database development management to database administrators (DBAs) and other experts. DBMS is a system package useful for using integrated data records and files called databases. It allows different user applications to easily access the same database. DBMS can use various database models such as network model and relational model. On large systems, using DBMS, users and other software can store and retrieve data in a structured way. Users can ask simple questions in the query language without writing a computer program to extract information. Therefore, many DBMS packages provide 4th generation programming language (4GL) and other application development functions.