Database Administrator

Role purpose

Provide software support for internally developed products that interact with all database systems.

To implement, design and improve processes relating to the administration of databases to ensure that they function correctly, perform optimally, preserve data and maintain a high level of availability.

This role operates in the IT environment and has a strong client focus. Changes in the role occur with changes in client, organizational and legislative requirements.

Responsibilities

• Sets and maintains operational database standards on an ongoing basis.
• Enforces and improves database integrity and performance through the use of sound design principles and set down database design standards.
• Designs and enforces data security policies to eliminate unauthorized access to data on managed data systems in accordance with IT Services technical specifications and business requirements.
• Ensures that effective data redundancy; archiving, backup and recovery mechanisms are in place to prevent the loss of data.
  Sets up configurable pre-established jobs to automatically run on a daily basis, to monitor and maintain the operational databases.
• To keep abreast of technical developments of operational importance and to participate in developing or setting standards as directed.
• Assisting development teams with effective schema design to achieve optimum performance.
• Completes all project work and allocated tasks on time as per agreed schedule and communicates progress with all parties concerned.
• Takes on additional, unplanned projects as required by the business and works after hours where necessary.
• Completes technical documentation as required.

Qualification

• Excellent English written and verbal communication skills on it. Relevant Degree or Tertiary qualification.
• 2 or more years of Database experience.
• Experience working with AWS Cloud and/or AWS certification.
• Solid IT knowledge.
• Sound Relational Database Theory understanding.
  Basic report design and writing.
• Experience writing T-SQL and stored procedures and query tuning on high transaction systems.
• Experience with Microsoft SQL Replication, Availability Groups, Mirroring & Log Shipping, and Service Broker.
• Experienced in Microsoft SQL Dynamic Management Views, Functions & Triggers.
• Innovative approach to work, constantly looking for upgrading the system to more efficient and effective new technologies.
• Certification covering Microsoft SQL 2014/2019.