Posted time 26th July 2023 Location Johannesburg Job type Full-time
  • Experience: 5 years DBA experience in SQL
  • Salary: R610 000 p.a negotiable

Job Title                                Database Administrator

Division                                 Business Change and Technology

Location – Town / City     Sandton

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              

  • Degree in Computer Science, Information Systems, or IT relevant Degree
  • Microsoft certified Database Administrator (Added Advantage)
  • Cloud Certification (Added Advantage)
  • Relevant database certificates
  • Insurance background (Added advantage)
  • Minimum of 5 year’s 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.

Duties and 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.
  1. Database Maintenance
  • Manage SQL and MySQL Server databases to support various applications during projects and production.
  • 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.
  • Participates in IT patch management to mitigate any application risks.
  • Provide support for business-critical systems; and perform scheduled maintenance and support release deployment activities.
  1. Database Security
  • Know the potential weaknesses of the database software and the company’s 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.
  1. 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.
  1. 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.
  1. Research and continuous improvement (Research identify and recommend database improvements)

Application email: portia@boikagogroup.co.za

This job is Expired