Depending on the level of
the responsibility, the tasks of the database administrator include pure
maintenance while other roles will involve specialising in database
development.
the responsibility, the tasks of the database administrator include pure
maintenance while other roles will involve specialising in database
development.
Tasks include some or all
of the following:
of the following:
·
establishing the needs of
users and monitoring user access and security;
establishing the needs of
users and monitoring user access and security;
·
monitoring performance and
managing parameters to provide fast responses to front-end users;
monitoring performance and
managing parameters to provide fast responses to front-end users;
·
mapping out the conceptual
design for a planned database;
mapping out the conceptual
design for a planned database;
·
considering both back-end
organisation of data and front-end accessibility for end-users;
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;
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;
further refining the
physical design to meet system storage requirements;
·
installing and testing new
versions of the DBMS;
installing and testing new
versions of the DBMS;
·
maintaining data standards,
including adherence to the Data Protection Act;
maintaining data standards,
including adherence to the Data Protection Act;
·
writing database
documentation, including data standards, procedures and definitions for the data
dictionary (metadata);
writing database
documentation, including data standards, procedures and definitions for the data
dictionary (metadata);
·
controlling access
permissions and privileges;
controlling access
permissions and privileges;
·
developing, managing and
testing back-up and recovery plans;
developing, managing and
testing back-up and recovery plans;
·
ensuring that storage and
archiving procedures are functioning correctly;
ensuring that storage and
archiving procedures are functioning correctly;
·
capacity planning;
capacity planning;
·
working closely with IT
project managers, database programmers and multimedia programmers;
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;
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.
commissioning and
installing new applications and customising existing applications in order to
make them fit for purpose.
