DATABASE ADMINISTRATOR

JOB SUMMARY:

The responsibilities of a Database Administrator (DBA) will be the performance, integrity, and security of a database. DBA will be involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users.

DBA will ensure that:

• 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 (ensuring all data is retrievable in an emergency).

DUTIES AND RESPONSIBILITIES:

• Establish the needs of users and monitor user access and security.
• Monitor performance and manage parameters to provide fast responses to front-end users.
• Map out the conceptual design for a planned database.
• Consider both back-end organization of data and front-end accessibility for end-users.
• Refine the logical design so that it can be translated into a specific data model.
• Further refining the physical design to meet system storage requirements.
• Install and test new versions of the database management system (DBMS)
• 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 DB 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.
• Work closely with IT project managers, database programmers and multimedia programmers.
• Communicate regularly with technical, applications and operational staff to ensure database integrity and security.
• Commission and install new applications and customize existing applications to make them fit for purpose.
• Manage the security and disaster recovery aspects of a database.

Databases: MySQL, PostgreSQL, knowledgeable with AWS is a plus