Database Administrator at KEMRI Wellcome Trust Research Programme (KWTRP)

JOB PURPOSE: 

This role is responsible for development of databases in the environment in accordance to the set standards to meet business objectives. Work includes a broad range of complex technical or professional activities, in a variety of contexts. Investigates, defines and resolves complex issues.

Description: 

Reports to: Software Development Manager

Direct Reports: None

Key Responsibilities

• Administer database management system support activities for operational database systems. 2. Gather requirements, design-build, and implement study databases and data collection tools
• Evaluate potential solutions, and demonstrate, install and commission selected products.
• Translate object and data models into appropriate database schemas within design constraints. 
• Integrate data across applications and DBMSs.
• Set data constraints and perform data cleanup to ensure data quality.
• Facilitate database development and implementation processes;
• Liaise with developers on development project requirements and implement physical database structures.
• Develop basic knowledge of database concepts, object and data modelling techniques and design principles.
• Assesses proposed changes to objects and data structures and implement changes in physical databases. 
• Interpret installation standards to meet project needs and produces database components as required; 
• Ensure data security by controlling data access through user authentication and connecting applications.
• Develop, manage and test back-up and recovery plans.
• Capacity planning by projecting resource utilization;
• Monitor performance and manage parameters to provide fast responses to front-end users;
• Conduct database backup, storage and archiving; and
• Writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata).
• Improve and document the technical processes around application support (using Confluence)

Financial Responsibility: None

Minimum Requirements

• Bachelor’s degree computer science or in related specialization of study
• Minimum 3 years’ experience in database management in environments with Opensource SQL database (MySQL/Maria DB, PostgreSQL). 
• Experience in with different database environments and integrating them with web and mobile applications
• Familiarity with architecture styles/APIs (REST, RPC)
• Knowledge and experience working with agile methodologies.
• Familiarity with secure coding standards.
• Experience in patching, upgrades, Database hardening, password management and vulnerability management

Desirable 

• At least one DBA certification e.g., OCA, MYSQL, MCSA
• Experience in Electronic Data Collection systems such e.g., Redcap, ODK, Open Clinica
• Experience in working in a research institution and support for clinical applications.
• Experience in supporting Microsoft Navision for end users.
• Experience in working with SharePoint, power BI, power automate and power apps.

Competencies:

• Demonstrate high levels of integrity
• Analytical and problem-solving skills
• Ability to multi-task and stay organized in a dynamic work environment
• Ability to provide adhoc support to different database environments
• Strong interpersonal and communications skills, both in writing and oral
• Logical diagnostic skills and ability to exercise good judgement in the resolution of problems
• Ability to learn new programming languages quickly.
• Ability to write, edit, and debug computer programs to achieve desired output.
• Strong understanding of the software development cycle.
• Good presentation skills;