Database Administrator

SUMMARY:
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.

POSITION INFO:
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.

• 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.

• 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

• 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

• 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, identify and recommend database improvements.

• Tasks allocated by management and any initiatives driven in IT department to support the Strategy.

• Degree in Computer Science, Information Systems or IT relevant Degree
• Microsoft certified Database Administrator (Added Advantage)
• Cloud Certification (Added Advantage) and Relevant Database certificates

• Minimum of 5 year’s proven MS SQL Database Administration
• Minimum of 2 years Microsoft Synapse experience
• MySQL experience (added advantage)