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:
- 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.
- 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.
- 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.
- 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.
- 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.
- Research and continuous improvement (Research identify and recommend database improvements)
Application email: portia@boikagogroup.co.za
This job is Expired