I always have a point of view: The program is temporary, and the data is timeless. So I always thought that the importance of data in many enterprises is much higher than the application, in many years of work in the practice of the DBA to do the work. To be a DBA, it is important to be aware of the responsibilities of being a DBA. The most important task for DBAs is to ensure the security and integrity of the data, and it is important to coordinate the development department to deploy a data environment with relatively optimal performance.
The DBA 's responsibilities are summed up in the following areas:
1. Data server installation and upgrade
The installation of the corresponding version of the database system needs to be communicated with the developer to determine, in the developer familiar with the version of the database system and better performance of the version selection, the actual application, from the role of the DBA to consider the choice of recommendations to determine the database system version after the implementation of installation and upgrade.
2. Application System Data plane evaluation, database storage structure design, data object creation
To understand the functional purpose of the application system, to assess the possible magnitude of the relevant data storage, according to the architect's architecture analysis to give the corresponding data inventory design, and propose to minimize the database burden of the architectural recommendations, such as load balancing, increase the cache layer, to determine the relevant schema after the creation of related data objects, Cooperate with development Department to build development environment.
3. According to the developer feedback information, make relevant work, adjust the database structure if necessary
In the development department in the process of system development, at any time to follow up the database reading and writing, testing the development of database-related operational statements of the pros and cons, and give suggestions for improvement. According to the feedback from the developer, make corresponding feedback. After the completion of the system development, the relevant load, security testing, detection performance and according to the actual adjustment program to build the way or adjust the database structure.
4. Database user and Database security maintenance
Assign users and permissions to the application system, after the system enters the production application, completes the daily safety maintenance work.
5. Monitor and optimize database performance, coordinate with developers to optimize application systems
Monitor the data operation of the application system in the production environment, analyze and find out the database operation statements with low performance or security risks, give feedback to the developers, and provide suggestions for improvement. Combined with the operation of the server, and the system administrator on the CPU, memory, hard disk and other hardware operations to evaluate, according to the actual situation, so that the data server and application system to achieve optimal performance.
6. Develop and execute a database backup/recovery/migration plan
With the application system running, the data will continue to increase, in addition to pay attention to the hard disk space quota is sufficient to cope with a certain period of data increment, but also to develop a corresponding data backup/recovery/migration plan, especially the backup work is daily essential, Ensuring a relatively complete copy of the data is one of the most basic tasks of the DBA's routine. Develop a high availability recovery/migration plan for the application system, ensuring that the application system layer can be recovered or migrated without modification or modification only if required.
7. Ready to respond to catastrophic measures
To be able to deal with catastrophic problems, in doing the 6th above basically, it is necessary to gather all aspects of information and to coordinate with the server system administrator for daily coordination. In many cases, catastrophic shocks come not only from the data plane, but also from the system and hardware. As a DBA, it is necessary to maintain good communication and collaboration with server system administrators and application architects at all times, in addition to having enough experience to be proactive and ready to respond to the rapid recovery after the catastrophic impact of the advent.
8. Develop and do a daily/weekly/monthly work plan
Week work and monthly work to eliminate the schedule, the breakdown is the daily work, generally speaking daily work mainly include:
1) Ensure that the data server is working properly and the database is in good condition
2) View the database log and view the trace file to see if there are any exceptions
3) Check the server disk status, the space is sufficient
4) Check that the backup is normal
5) Monitoring performance, such as performance degradation, troubleshooting reasons
6) Fill in the DBA log
In addition to the daily work, the system runs to a certain period of time, it is necessary to discuss with the relevant departments whether to split the old and new data, according to the historical data of database performance, provide the corresponding analysis report, as well as performance optimization plan.
9. Understand technical information related to learning updates to address a variety of possible issues
The development of technology is changing rapidly, and a good DBA should always be aware of relevant technical information, the database software that has been put into use, the official technical news and the Bug bulletin. According to the actual situation of the company, screening useful new technologies to improve the performance of the system or add security.
As long as the above points, rich sense of responsibility and good execution, I believe such a person from a good DBA is not far away.
How to do a DBA "turn"