Database Administrator III

Closing Date

2024/12/26

Reference Number

SHO241212-3

Job Title

Database Administrator III

Job Type

Permanent

Location

South Africa, Western Cape, Brackenfell, Cape Town

Purpose of the Job

We are looking for an experienced SQL SERVER database administrator who will be responsible for ensuring the performance, availability, and security of SQL SERVER instances. You will also be responsible for orchestrating upgrades, backups, and provisioning of database instances. You will also work in tandem with other teams, preparing documentation and specifications as required. The SQL SERVER instances will be hosted in our datacenter as well as in AWS/Microsoft cloud platforms.

Job Advert Details

Job Category

IT

Job Objectives

1. To manage SQL SERVER installations and upgrades.
2. To assist Development Teams in designing and optimising systems.
3. To carry out database administration tasks.
4. To work with SECURITY team to manage access and compliance.
5. To research, assess and implement SQL SERVER variations in AWS/AZURE.

Qualifications

Grade 12
Tertiary qualification related to IT
Relevant courses in database management
AWS Associate architect
Azure Fundamentals

Experience

Experience managing SQL SERVER databases, including databases larger than 1TB - Years (5+)
Experience in SQL SERVER versions 2014-2019 - Years (3+)
Experience with Azure SQL; Azure SQL Managed Instances - Years (2+)
Experience with data encryption using SQL SERVER

Knowledge and Skills

General understanding of database management concepts - Years (5+)
Strong proficiency in SQL SERVER database administration – backups, restores, installation, patching and monitoring error logs - Years (5+)
SQL SERVER query performance tuning - Years (5+)
SQL SERVER transparent data encryption - Years (1+)
Experience configuring SQL SERVER ALWAYS ON AVAILABILITY groups and DATABASE MIRRORING - Years (2+)
Writing STORE PROCEDURES - Years (5+)
Migration of SQL SERVER from ON-PREM to AZURE/AWS - Years (2+)