Database Administrator - Johannesburg, South Africa - LENOHLAHLA CONSULTING
Description
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:
- Database Software Installation
Setting up the hardware and deploying the operating system for the database server, and installation and configuration of database software.
- Database Maintenance
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.
- Database Security
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.
- Monitoring and Reporting
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.
- Policy Holder Data Acquisition
Provide support for Policy Holder Data to enable business for data management.
- Research and continuous improvement
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?
More jobs from LENOHLAHLA CONSULTING
-
Chief Governance
Johannesburg, South Africa - 1 week ago
-
Senior Operations Manager
Johannesburg, South Africa - 3 days ago
-
Senior Legal Advisor
Pretoria, South Africa - 1 week ago
-
Monitoring & Evaluation Manager
Johannesburg, South Africa - 6 days ago
-
Legal Manager
Johannesburg, South Africa - 1 week ago
-
Cost Estimator
Johannesburg, South Africa - 1 week ago