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;
Apply via :
jobs.kemri-wellcome.org
