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