Wednesday, December 24, 2008

Database Administrator

A database administrator (DBA) is responsible for the performance, integrity and security of a database. Additional role requirements are likely to include planning, development and troubleshooting.

The database approach incorporates the following principles 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).

Database administrator (DBA) roles are increasingly identified by the databases and processes they administer and the capabilities of the database management system the work of a database administrator varies according to the nature of the employing organization and the level of responsibility associated with the post. The work may be pure maintenance or it may also involve specializing in database development.

Typical responsibilities include 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 query responses to 'front end' users, mapping out the 'conceptual design' for a planned database in outline further refining the 'physical design' to meet system storage requirements.

Installing and testing new versions of the database management system (DBMS),maintaining data standards, including data standards, procedures and definitions for the data dictionary ('metadata'),controlling access permissions and privileges, developing, managing and testing backup and recovery plans
Because of the increasing levels of hacking and the sensitive nature of data stored, security and recoverability or 'disaster recovery' have become increasingly important aspects of the work.

No comments: