The database administrator (DBA) is the person who manages, backs up and ensures the availability of the data produced and consumed by today’s organizations via their IT systems. The DBA is a critically important role in many of today’s IT departments, and by extension, their organizations overall.
Database administrators use specialized software to store and organize data. The role may include capacity planning, installation, configuration, database design, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery.
- Establish the needs of users and monitor user access and security
- Monitor performance and manage parameters in order to provide fast responses to front-end users
- Map out the conceptual design for a planned database
- Consider both back-end organisation of data and front-end accessibility for end-users
- Refine the logical design so that it can be translated into a specific data model
- Maintain data standards, including adherence to the Data Protection Act
- Write database documentation, including data standards, procedures and definitions for the data dictionary (metadata)
- Control access permissions and privileges
- Develop, manage and test back-up and recovery plans
- Ensure that storage and archiving procedures are functioning correctly
- Carry out capacity planning
- communicate regularly with technical, applications and operational staff to ensure database integrity and security