ab

Role of Database Administrator

  •  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 

adhitz