Database administrator

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