Terms of employment: Contract
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) and ICT case team
Background
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.
Monitor, maintain database systems and troubleshoot problems that may arise.
Maintain data integrity and security (manage roles and permissions of database users).
Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them.
Develop strategies and implement solutions for managing back-ups, restoration and replication.
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.
Assisting development teams with effective schema design to achieve optimum performance
Proactive housekeeping /archiving and shrinking of databases.
Manage production, QA (quality assurance) and development database environments.
Create detailed documentation including diagrams of database infrastructure.
Effectively coordinate and communicate with all the stakeholders (internal teams and clients).
Set up and maintain database infrastructure for the company’s BI needs
University degree in the field of computer science/Engineering and/or a relevant combination of equivalent training and 4years work experience.
Preference will be given to candidates with certifications in related fields such as; Oracle, MS SQL and mysql
Desired skills and experiences
Experience with management of Oracle and Microsoft SQL server
Experience with management of PostgreSQL
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 and 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
Methodical and accurate while delivering to daily deadlines
Systematic approach to identifying faults and pursuing paths to resolution
Experience of specifying and installing new solutions