A database administrator (DBA) is responsible for the performance, integrity and security of a database. They will also be involved in the planning and development of the database as well as troubleshooting any issues on behalf of the users.
A DBA makes sure that databases have the following qualities:
data remains consistent across the database;
data is clearly defined;
users access data concurrently, in a form that suits their needs;
there is provision for data security and recovery control (all data is retrievable in an emergency).
DBA roles vary depending on the type of database, the processes they administer and the capabilities of the database management system (DBMS) in use.
Typical work activities
Your level of responsibility will determine the tasks you carry out in the job. Some work may be pure maintenance while other roles will involve you specialising in database development.
Tasks may involve some or all of the following:
establishing the needs of users and monitoring user access and security;
monitoring performance and managing parameters to provide fast responses to front-end users;
mapping out the conceptual design for a planned database;
considering both back-end organisation of data and front-end accessibility for end-users;
refining the logical design so that it can be translated into a specific data model;
further refining the physical design to meet system storage requirements;
installing and testing new versions of the DBMS;
maintaining data standards, including adherence to the Data Protection Act;
writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata);
controlling access permissions and privileges;
developing, managing and testing back-up and recovery plans;
ensuring that storage and archiving procedures are functioning correctly;
working closely with IT project managers, database programmers and multimedia programmers;
communicating regularly with technical, applications and operational staff to ensure database integrity and security;
commissioning and installing new applications and customising existing applications in order to make them fit for purpose.
Because of the increasing levels of hacking and the sensitive nature of data stored, security and disaster recovery have become increasingly important aspects of the work.
This website is best viewed in an up-to-date web browser with CSS enabled. While you will be able to view the content of this page in your current browser, you will not be able to get the full visual experience. Please consider upgrading your browser software or enabling style sheets if you are able to do so.