SQL Database Administrator

Join our team as a SQL Database Administrator! Provide software support for internal products interacting with databases. Design and implement processes for optimal database administration, data preservation, and high availability. Client-focused role in a dynamic IT environment. Apply now!

Key Responsibility

• 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.

Skills, qualifications, and experience

•             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.