Project duration: Four years
Duration of contract: one year with possible extension
Place: Ethiopian Public Health Institute, Addis Ababa
Reporting to: National Data Management Center for health (NDMC)
The National Data Management Center for health (NDMC) at the Ethiopian Public Health Institute (EPHI) is a responsible center to centrally archive health and health related data, process and manage health research, apply robust data analytic technics, synthesis evidence and to ensure evidence utilization for decision making by the Federal Ministry of Health (FMoH) and other relevant stakeholders at local, sub-national and national and international levels. NDMC has collaborative partnership with Institute for Health Metrics and Evaluation (IHME), University of Washington and has established a Burden of Disease (BoD) Unit. The BoD Unit is responsible for data mapping, collecting, reviewing and archiving available health and health related data in the country and for producing national and subnational burden of disease estimates collaboratively with Global Burden of Disease (GBD) Study centered at IHME for population and demography, mortality and risk factors for a range of communicable diseases, non-communicable diseases, maternal newborn and child health, nutrition and for injuries. The unit creates platforms for translating BoD evidence for decision and policy at national and subnational levels. The NDMC is looking for high caliber staff for this collaborative project.
Roles and responsibilities
· Create and manage multiple databases and assist in capacity planning.
· Create and manage constraints and indexes.
· Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.
· Create detailed documentation including diagrams of database infrastructure.
· Effectively coordinate & communicate with stakeholders (internal teams & clients).
· Set up and maintain database infrastructure for the company’s BI needs
Desired skills and experiences
· Experience with management of Oracle, PostgreSQL, MYSQL and Microsoft SQL server
· Experience of project management processes
· Experience of other monitoring packages such as Zenoss, Nagios and HP OpenView Ability to foresee relevant issues and assist in proposing possible solutions
· Advanced understanding of Oracle 10g/11g and MySQL 5.x gained through running critical systems
· Management of multiple schemas through system development, test & live environments
· Experience with Oracle Data Guard replication
· Experience with Oracle RMAN and OEM Monitoring
· Experience with MySQL Enterprise Monitoring
· Experience with MySQL Master-Slave / Master-Master replication
· Good working knowledge of, and confidence administering on Solaris/Linux platforms
· Experience of Unix Scripting
· Systematic approach to identifying faults and pursuing paths to resolution
· Experience of specifying and installing new solutions
· Advanced understanding of PHP frameworks such as laravel and symfony.
· University degree in the field of computer science/Engineering and/or a relevant combination of equivalent training and 3 years work experience.
· Preference will be given to candidates with certifications in related fields such as; Oracle, MS SQL and MySQL