Often, computer operations and maintenance generally includes computer troubleshooting and repair, operating system in accordance with, backup, relatively little content; while the database administrator is responsible for the overall management and control of the database system, including the installation of the database, monitoring, backup, recovery and other basic work. The main responsibilities of the database administrator are the following:
1. Design database design, including fields, tables and key fields; how resources are used on auxiliary storage devices, how to add and delete files and records, and how to find and remedy losses.
2. Monitors warning logs of monitored databases and does regular backups for deletion. Monitor the daily sessions of the database. Fragmentation, remaining tablespace monitoring, to keep abreast of tablespace expansion, as well as the distribution of the remaining space. Monitor object modifications. Regularly list all changed objects Install and upgrade database servers (e.g. Oracle, MicrosoftSQLserver), and application tools. Database design system storage solutions and plan for future storage requirements. Develop database backup plans and restore database information when disaster strikes. Maintain archived or backup data on appropriate media. Backup and restore databases. Contact database system manufacturers to track technical information.
3. Backup to the database backup monitoring and management of database backup is critical to the database backup strategy should be changed according to the actual requirements of the daily backup of data to monitor the situation.
4. Change the password: standardize the management of database users regularly on the administrator and other important user password changes. For each project, a user should be established. the DBA should communicate with the appropriate project managers or programmers to determine how to establish the appropriate database underlying model, and finally by the DBA unified management, establishment and maintenance. Any changes to the database objects should be operated by the DBA based on the requirements.
5. SQL statement: the requirements of the SQL statement writing specification of a SQL statement, if not written in a satisfactory manner, the impact on the database is very large. Therefore, each programmer or the corresponding staff in writing the corresponding SQL statements, should be strictly in accordance with the "SQL writing specification" article, the last to have a DBA to check before the official run.
6. end-user services and coordination: database administrators specify user access rights and allocate resources for different user groups. If different users are in conflict with each other, the database administrator should be able to coordinate 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 data only, while another type of user may have permission to update data and delete records.