Shulou(Shulou.com)05/31 Report--

This article mainly introduces what is the responsibility of the dba database administrator, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Responsibilities are as follows: 1. Stipulate user access rights and allocate resources to different user groups. 2. Monitor the warning log of the monitoring database and delete the backup regularly. 3. The backup strategy of the database should be changed according to the actual requirements, and the daily backup of the data should be monitored. 4. Standardize the management of database users and modify the passwords of administrators and other important users regularly.

Database administrator (Database Administrator, referred to as DBA) is a general term for the relevant staff engaged in the management and maintenance of database management systems (DBMS). It belongs to a branch of operation and maintenance engineers, and is mainly responsible for the lifecycle management of business databases from design, testing to deployment delivery.

The core goal of DBA is to ensure the stability, security, integrity and high performance of the database management system.

Main responsibilities:

In a general sense, the database administrator is a person responsible for managing and maintaining the database server. The database administrator is responsible for the overall management and control of the database system, including database installation, monitoring, backup, recovery and other basic work. The main responsibilities of a database administrator are as follows:

1. Design the database design, including fields, tables and key fields; how resources are used on secondary storage devices, how to add and delete files and records, and how to find and remedy losses.

2. Monitor the warning log of the monitoring database and delete the backup regularly. Monitor the daily sessions of the database. Monitor the fragmentation and remaining tablespace to keep abreast of the expansion of the tablespace and the distribution of the remaining space. Monitor the modification of the object. Periodically list all changed objects to install and upgrade database servers (such as Oracle, MicrosoftSQLserver), as well as application tools. The database designs the storage scheme of the system, and makes the future storage requirement plan. Make a database backup plan and recover the database information when the disaster occurs. Maintain archived or backup data on the appropriate media. Back up and restore the database. Contact the manufacturer of the database system and track the technical information.

3. Backup is very important for monitoring and managing the backup of the database. The backup strategy of the database should be changed according to the actual requirements, and the daily backup of the data should be monitored. (related recommendation "mysql video tutorial")

4. Change the password: standardize the management of database users and modify the password of important users such as administrators on a regular basis. For each project, a user should be created. DBA should communicate with the appropriate project managers or programmers to determine how to establish the underlying model of the database, and finally be managed, established and maintained by DBA. Any changes to database objects should be handled by DBA on demand.

5. SQL statement: the writing specification of SQL statement requires a SQL statement, if it is not written satisfactorily, it will have a great impact on the database. Therefore, every programmer or corresponding staff should strictly follow the "SQL Writing Specification" when writing the corresponding SQL statement, and finally there must be a DBA check before it can be officially run.

6. End-user service and coordination: the database administrator specifies user access and allocates resources to different user groups. If different users conflict with each other, the database administrator should be able to coordinate the users to optimize the arrangement.

7. Database security: database administrators can specify different access rights for different database management system users to protect the database from unauthorized access and destruction. For example, one type of user is allowed to retrieve only data, while another type of user may have permission to update data and delete records.

Thank you for reading this article carefully. I hope the article "what is the responsibility of dba database administrator" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.