About the position
To ensure that data is available, structured, protected from loss and corruption, and easily accessible. The DBA will be expected to manage, maintain, and secure data in one or more data systems to ensure that users can perform business-related analyses.
JOB DESCRIPTION
Database Installations
- Collaboration on the initial installation and configuration of a new databases either SQL/ MYSQL or Azure.
- Installation and configuration of database related software.
- Handling of data transfer from the existing system to the new platforms / cloud.
- Manage and maintain SFTP server and application.
Database Maintenance
- Manage SQL, MySQL and Azure Server databases to support various applications during projects and production.
- Manage Synapse and Power Bi.
- 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 restore testing and ensure databases are backed up accordingly.
- Participates in IT patch management to mitigate any application risks and remediate database vulnerabilities.
- Provide support for business-critical systems; and perform scheduled maintenance and support release deployment activities.
- Analyse and optimize database queries and indexing strategies.
Database Security
- Ensure potential weaknesses are identified and addressed for all on premise and Azure databases.
- Implementing best practices to minimise risks.
- Ensuring that there is audit logs should there be any security breach.
- Recommend best security practices for Databases to achieve business objectives (in line best practice and regulations), advises 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 regular basis.
- Produce reports on various database e.g., capacity, availability, jobs run etc.
- Provide Business Intelligence (BI) Dashboard support.
- Provide necessary support for business Intelligence function through access management.
- Conduct regular performance audits and provide recommendations.
- Monitor Azure resource and Synapse costs
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.
Adhoc tasks
- Tasks allocated by management and any initiatives driven in IT department to support the Strategy.
JOB REQUIREMENTS
Qualifications
- Degree in Computer Science, Information Systems or IT relevant Degree
- Microsoft certified Database Administrator (Added Advantage)
- Cloud Certification (Added Advantage) and Relevant Database certificates
Experience
- Minimum of 5 year’s proven MS SQL Database Administration
- Minimum of 2 years Microsoft Synapse experience
- MySQL experience (added advantage)
Desired Skills:
- proficiency in SQL
- database management systems
- communication skills
