- Install, Upgrade and configure the Database server based on the organizational requirements.
- Since systems are not static, the DBA must be able predict growth based on application and data usage patterns.
- Understand the logical and physical structure of the particular database.
- Ensuring the database is available to the users with minimum or no downtime, by taking backups regularly and creating well-tested recovery strategies.
- Helping and creating primary objects such as tables, views and indexes based on the needs of the application developments.
- The DBA must be able to design a database that holds accurate and valid data at all times.
- Managing users and ensuring the database is accessible to only valid users. Granting the users the privileges they need to perform various actions in the database.
- Monitoring and optimizing the performance of the database.
- The DBA must be able to design, debug, implement and maintain stored procedures, triggers and user defined functions that are stored.
- Security is becoming increasing important with the need for data to be available across the internet. The DBA should ensure that the data is secure and implement
Role of Database Administrator
Subscribe to:
Posts (Atom)