Database Administrator

JOB DETAILS
Job Title Database Administrator
Job Type Permanent
Division Business Change and Technology
Department Infrastructure

**EE Occupational Levels Level 4 & 5**: Skilled, Technical and Academically Qualified
Location - Town / City Sandton
Location - Province Gauteng
Location - Country South Africa
Job Advert Summary
Job summary statement/purpose

The primary role of the database administrator's (DBA) is to ensure that data is available, structured, protected from loss and corruption, and easily accessible. The DBA will be expected to manage, maintains, and secure data in one or more data systems to ensure that users can perform business-related analyses. This role will be responsible for data storage, display, utilisation, and analysis.

Minimum Requirements

**Qualifications**:
Degree in Computer Science, Information Systems, or IT relevant Degree

Microsoft certified Database Administrator (Added Advantage)

Cloud Certification (Added Advantage)

Experience

Relevant database certificates

Insurance background (Added advantage)

Minimum of 5 years proven MS SQL Database Administration

MySQL experience (added advantage)

Knowledge and experience with database Performance Tuning and Optimization (PTO).

Business Intelligence experience - Power BI (added advantage)

Knowledge and experience with backups, restores and recovery models (Preferable)

Knowledge and experience of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.

**Responsibilities**:
**KEY PERFORMANCE AREAS (DUTIES & RESPONSIBILITIES**:
1. Database Software Installation

Collaboration on the initial installation and configuration of a new database either SQL/ MYSQL.

Setting up the hardware and deploying the operating system for the database server, and installation and configuration of database software.

Handling of data transfer from the existing system to the new platform.

2. Database Maintenance

Maintenance of database servers and updating of processes/SOPs.

Ensure high levels of performance, 97% availability and sustainability.

Ensure that databases logs are tracked, issues are resolved on time.

Works closely with IT Project Managers, Business Analysts, Enterprise Architects, Suppliers, Infrastructure team and development teams.

Provide support to Application Productions team, Application Developers and Infrastructure team.

Participates in the configuration, tuning and troubleshooting of the databases in use in Development, QA and Production.

Performs backup recovery through testing and ensure database are backed up accordingly.

Provide support for business-critical systems; and perform scheduled maintenance and support release deployment activities.

3. Database Security

Know the potential weaknesses of the database software and the companys overall system and minimise risks.

Implementing best practices to minimize risks.

Ensuring that there are audit logs should there be any security breach.

Recommend best security practices for Databases to achieve business objectives, advise on risk assumptions for any variances granted, and provides alternatives to achieve desired end results.

4. Monitoring and Reporting

Database Performance monitoring and resolution Implement and maintain storage, archiving, backup, and recovery procedures function correctly.

Monitor database health and its performance on a regular basis.

Produce reports on various database e.g., capacity, availability, job run etc.

Provide Business Intelligence (BI) Dashboard support.

Provide necessary support for business Intelligence function through access management.

5. Policy Holder Data Acquisition

Support business with Policy Holder Data acquisition programme by ensuring data is collected and availed for reporting purposes.

Provide support for Policy Holder Data to enable business for data management.

6. Research and continuous improvement

Research identify and recommend database improvements.

APPLICATION QUESTIONS

**Which of the following IT related qualification do you have**: Are you a Microsoft certified Database Administrator?

Do you have Cloud Certification?

Do you have any relevant database certificates?

How many years of experience do you have in MS SQL Database Administration?

Do you have short-term insurance background?