Database Manager at University Research Co., LLC (URC)
- Company: University Research Co., LLC (URC)
- Location: Uganda
- State: Jinja, UG
- Job type: Full-Time
- Job category: IT/Telecom Jobs in Uganda
Job Description
University Research Co., LLC (URC) is implementing the USAID’s Regional Health Integration to Enhance Services in East Central Uganda Activity (USAID’s RHITES EC). The purpose of this project is to support the implementation of a comprehensive, integrated investment in regional health, HIV/AIDS and nutrition assistance. This five-year activity targets 12 districts in East-Central Uganda with an estimated total population of 4.1 million through a district-based integrated package of quality health, HIV/AIDS, nutrition and child development services.
Roles and Responsibilities:
Job Purpose:
Under the supervision of the Director Monitoring, Evaluation and Learning, the Database / Management Information System (MIS) Manager will be responsible for administration, management, design, documentation and evaluation of a variety of database management systems, EMR and Supplementary data tools, software Design, Software Debugging, Software Documentation, Software Testing, Problem Solving, Teamwork, Software Development Fundamentals, Software Development Process, Software Requirements, in addition, the successful applicant will perform database and transaction log backups, as well as maintenance and monitoring of database server performance and backup automation.
Specific Responsibilities:
• Manage all the project Information Systems and Databases.
Determines operational feasibility by evaluating analysis, problem definition, requirements, solution development, and proposed solutions.
• Develop and amend changes to the RHITES EC database as per the organization requirement.
• Develop SQL and Web-based databases and database systems.
• Digitize supplementary tools to ease the data entry process.
• Develop software solutions by studying information needs; conferring with users; studying systems flow, data usage, and work processes; investigating problem areas; following the software development lifecycle (SDLC).
Manage, administer, support and control UgandaEMR systems across the EC region to ensure zero downtime.
• Prepare and install solutions through determining and designing system specifications, standards, and programming.
• Develop solutions through documentation, flowcharts, layouts, diagrams, charts, code comments and clear code.
Design, manage and administer open-source data collections tools like ODK collect and ODK Aggregate server.
• Ensure the Amazon Web Server (AWS) that hosts RHITES EC database and ODK aggregate instance is up, running and responding 24/7 to the database needs as necessary.
• Manage the GIT repository for the organization which holds the source code for the project database and all other applications developed.
• Train and mentor project staff who will be collecting the data using both electronic and paper-based case report forms.
• Supervise data collection using ODK system and ensure accurate and timely data entry and query resolution.
• Provide technical guidance and oversight to ensure that the work delivered is in accordance with the technical standards.
Administer a variety of database management systems including Microsoft SQL Server, PostgreSQL, MySQL, No SQL Databases and MS Access.
• Develop and enforce database administration and user standards and procedures; audit, modify, and amend data in systems, and create data entry screens.
• Develop and oversee the scheduling of database projects, database and transaction log backups, notifications, and database replication between multiple database servers and remote sites.
• Regularly develop and evaluate the database server integrity and security.
• Review technical designs, reports, documentation, and other materials produced by staff.
Support project M&E and Technical staff to retrieve the needed data from the project database.
• Work with the project MEL team to ensure that clean program data is captured and stored into the project database(s).
• Work with the project MEL team to ensure that the project dashboards (online and offline) are regularly updated and accessed by the necessary audiences (Technical staff, Senior Management and Donors – USAID).
• Conduct user training on the current trends in technology.
• Perform other duties as assigned by Senior Management Team.
Required Experience and Qualifications
• The applicant must hold a bachelor’s degree in Computer Science, Software Engineering, or equivalent qualification. Possession of Masters or a Post-graduate qualification in the same fields is an added advantage.
• Should have a minimum of six years’ experience in IT, Management Information Systems, Database Management and Systems Development.
Have at least five years of recent experience in developing and/or managing health information Systems / databases.
• Proficiency and hands-on experience in key programing languages such as Python, C#, HTML, JavaScript.
• Very comfortable with hands-on in Django framework and the .NET framework including .Net core.
• Proficiency and hands-on experience in both Windows and Unix operating Systems.
• Proven ability to deploy the software development lifecycle (SDLC) process.
• Demonstrated knowledge of managing medical records.
• Considerable experience working with international development agency/s in Africa or with organizations such USAID, CDC, Ministries of Health.
Familiarity with PEPFAR indicators, technical areas, and interventions.
• Proficiency and hands-on experience in key database programming languages and database management systems such as MySQL, PostgreSQL, Oracle, Couch dB, MS Access, JavaScript
• Ability to innovate and solve problems independently.
• Excellent communication and interpersonal skills.