Database administrator

Source: Internet
Author: User

Tag: OS uses SP data AD as to manage Database server

Database administrator (db Administrator, DBA), is a person responsible for managing and maintaining the database server. The database administrator is responsible for the full management and control of the database system.

Specific tasks:

  • Install and upgrade database servers (such as Oracle, Microsoft SQL Server), and application tools.
  • The database designs system storage scenarios and develops future storage requirements plans.
  • Once a developer has designed an application, the DBA is required to create the database storage structure (tablespaces).
  • Once a developer has designed an application, the DBA is required to create the database object (tables,views,indexes).
  • Modify the structure of the database, if necessary, based on feedback from the developer.
  • The user who enlists the database, maintains the security of the database.
  • Ensure that the database is used in compliance with intellectual property laws.
  • Control and monitor user access to the database.
  • Monitor and optimize the performance of your database.
  • Develop a database backup plan to recover database information when a disaster occurs.
  • Maintain archiving or backup data on the appropriate media.
  • Back up and restore the database.
  • Contact the manufacturer of the database system to track technical information.

Database administrator

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

Tags Index: