Database Administrator (DBA)
Deadline of this Job:
18 February 2021
Within Rwanda , Kigali , East Africa
Date Posted: Tuesday, February 09, 2021 , Base Salary: Not Disclosed
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. .
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.
The Database Administrator (DBA) will implement a strategy to ensure effective usage of ACHIEVE Rwanda’s DHIS2 database systems- including the Rwanda DREAMS Tracking System (RDTS) and the electronic OVC case management system (eCMS). The DBA will 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, creating key visualizations and dashboards, providing user support, and performing the required updates and upgrades to the information management systems. 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.
• Design, administer, test, troubleshoot, and implement the project’s data management systems and related technology platforms, including backup and recovery management solutions; proactive health-checks and maintain security and database software; database performance tuning; and lead planning and execution of annual and ad-hoc “snapshot” database instances.
• Identify, test, and use cutting edge, innovative technology solutions to enable the program to automate, simplify, and refine processes that generate critical reports with secure and accurate data to track and measure project progress over time.
• Lead the updating and application of the Rwanda DREAMS Tracking System (RDTS) across all the ACHIEVE sub-partners and other OVC/DREAMS implementing partners through quarterly joint system and data quality reviews and user feedback.
• Lead the development, rollout, and maintenance of the Rwanda electronic OVC case management system across all the ACHIEVE sub-partners and other OVC/DREAMS implementing partners.
• Incorporate Geographic Information System (GIS) technology into the project’s data management systems to track project and activity location data. Periodically generate geographic reports and digital maps in line with USAIDs geographic data reporting requirements.
• Configure standard project indicator performance reports, visualizations, and dashboards to enable users track progress in service provision and generating of on fly reports/visualizations.
• 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.
• Administer database servers to avoid/limit systems downtime, improve system performance and ensure that the servers run the most updated and stable packages.
• Develop staff and partner capacity in using information management systems including data entry, analysis, and reporting.
• 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.
• Provide technical IT support in applying other related technology solutions in order to respond to the emerging project priorities.
• Bachelor’s Degree in information technology, computer science, information systems, data science, computer engineering or related field
• Knowledge of SQL and NoSQL databases, 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.
• Expertise in DHIS2 and cloud-based data management, and at least 3 years of experience in administering and configuring DHIS2 instances.
• Expertise in server administration with at least two years in managing Linux based servers preferably Ubuntu server.
• Expertise in deploying and applying custom reporting systems with at least two years’ experience in applying preferably open-source analytics and business intelligence software applications such as Jasper Reports Server, KNIME analytics, Microsoft Power BI, etc.
• Experience in administering mobile-based data collection applications such as DHIS2, CommCare or other ODK-based mobile data collection software.
• Knowledge of DHIS2’s API
• Working knowledge of monitoring and evaluation principles, including data collection and analysis, tracking outcome indicators, and design of program evaluations using mixed methods
• Local candidates preferred.
Job Experience Requirements: Not Specified
Work Hours: 8
Job application procedure
Pact is an equal opportunity employer and does not discriminate in its selection and employment practices based on 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 February 18, 2021, 5pm mentioning the position title as a subject to email.