Position Details

Position Title: Database Administrator                     Office Location: Kigali, Rwanda

Supervisor Name: TBD                                               Supervisor Title: ACHIEVE Rwanda MEL Director

New or Replacement: New Position                          Full or Part-Time: Full-Time

Expected Project End Date: 9/30/2022

Date of Submission: 8/6/2020

JOB DESCRIPTION (Please complete all Sections)

Pact Overview

At the heart of Pact is the promise of a better tomorrow. A nonprofit international development organization founded in 1971, Pact works on the ground in nearly 40 countries to improve the lives of those who are challenged by poverty and marginalization. We serve these communities because we envision a world where everyone owns their future. To do this, we build systemic solutions in partnership with local organizations, businesses, and governments that create sustainable and resilient communities where those we serve are heard, capable, and vibrant.

Pact is a recognized global leader in international development. Our staff have a range of expertise in areas including public health, capacity development, governance, and civil society, natural resource management, poverty, fragile states, monitoring and evaluation, small-scale and artisanal mining, microfinance, and more. This expertise is combined in Pact’s unique integrated approach, which focuses on systemic changes needed to improve people’s lives.

Project Overview

Pact seeks a Database Administrator for the ACHIEVE Rwanda program.  ACHIEVE is a five-year, USAID-funded global cooperative agreement with the dual objectives of attaining and sustaining HIV epidemic control among at-risk and hard to reach pregnant and breastfeeding (PBF) women, infants, children, and youth, as well as to mitigate the impact of HIV/ AIDS and prevent HIV transmission among these populations; and supporting the transition of prime funding and implementation to capable local partners in order to meet the PEPFAR goal of 70% of funding to local partners.

The aim of ACHIEVE Rwanda is to prevent new HIV infections and reduce vulnerability among orphans and vulnerable children (OVC), and adolescent girls and young women (AGYW) in selected high burden districts in Rwanda. The strategic objectives support the Government of Rwanda strategies and priorities for HIV mitigation and prevention, with an emphasis on minimizing negative impacts of HIV on OVC and AGYW; addressing social, behavioral and structural drivers of HIV, and improving access to comprehensive SRH and violence response services to prevent new infections.  The project supports OVC services in two districts and DREAMS activities in two districts.  The project also provides capacity development to two local implementing partners to coordinate and support OVC and DREAMS service delivery programming and for USAID and PEPFAR project implementation.

Position Purpose

The Database Administrator will implement a strategy to ensure effective usage of ACHIEVE Rwanda’s DHIS2 database systems- including the Rwanda DREAMS Tracking System (RDTS)- and ensure day to day maintenance and support of the databases, configure simple data collection sites, and socialize data usage. S/he will be responsible for user creation and permissions management, troubleshooting and documentation, dashboard creation, and simple configurations and updates. The Database Administrator will work closely with the MEL Director and Pact’s Strategic Information Systems Manager to ensure ACHIEVE Rwanda’s database systems are up-to-date, meet users’ needs- including other OVC/DREAMS implementing partners, and will liaise with systems architects for upgrades and advanced configuration needs.

Key Responsibilities

• Implement strategy for ACHEVE Rwanda’s database systems design, usage, and data for decision making
• Adhere to and advise on standard operating procedures for database configuration, user management, data access, dashboard management, and data usage
• Design and manage users, user groups; ensure appropriate object sharing and permission; provide data exports, assist teams in importing data sets, execute SQL queries
• Provide troubleshooting support to ACHIEVE, sub-partner staff, and other OVC/DREAMS implementing partners accessing and using the systems; investigate and find solutions to bugs and functionality issues, document processes and solutions when troubleshooting
• Provide regular updates on system maintenance and solutions to MEL Director and ACHIEVE global team
• Collaborate with Pact’s Strategic Information Systems Manager to ensure ACHIEVE Rwanda’s topline performance data is configured and populated in Pact’s imPact database (DHIS2) and lead or provide inputs to build an API between the systems for auto-populating the data
• Engage with other database administrators and DHIS2 users within ACHIEVE and Pact’s imPact community of practice
• Support roll-out of electronic case management system integration with ACHIEVE’s database systems

 Basic Requirements

• Bachelor’s Degree in social sciences, public health, international development, information technology, computer engineering or related field
• Expertise in DHIS2 and cloud-based data management, and at least 2 years of experience in administering and configuring DHIS2 instances
• Previous experience in data collection and information systems roll-out, configuration and usage
• Knowledge of DHIS2’s API
• Knowledge of SQL, ability to work with and edit csv and xml files
• Strong facilitation, teaching and coaching skills related to technology uptake
• Ability to work independently, to perform and prioritize multiple tasks; high attention to detail
• Ability to establish and sustain interpersonal and professional relationships with Pact staff, donor organizations, and peer organizations

Preferred Qualifications

• Experience with, or working knowledge of CommCare or other ODK-based mobile data collection software
• Working knowledge of MERL principles, including data collection and analysis, tracking outcome indicators, and design of program evaluations using mixed methods
• Data mining, analytics, and visualization skills using SPSS or STATA; with experience with programming language(s) (R, Python, SPSS modeler)
• Experience with qualitative analysis software, GIS systems, and/or data visualization software (NVivo, ArcGIS, Power BI, Tableau, etc.)
• Demonstrated success implementing programming at the community level
• Expertise in and sensitivity to the socio-cultural barriers facing intended beneficiaries for this program
• Local candidates preferred

Pact is an equal opportunity employer and does not discriminate in its selection and employment practices on the basis of race, color, religion, sex, national origin, political affiliation, sexual orientation, gender identity, marital status, disability, genetic information, age, membership in an employee organization, or other non-merit factors.

All applications with a motivation letter and CV shall be sent through the following email address: [email protected] not later than August 12, 2020, mentioning the position title as a subject to email.