Kenya: Database Administrator

Want create site? Find Free WordPress Themes and plugins.

Organization: UCSF Global Programs for Research & Training
Country: Kenya
Closing date: 30 Mar 2018

The University of California San Francisco (UCSF) has Cooperative Agreements with the U.S. Centers for Disease Control and Prevention-Kenya (CDC-Kenya) to provide technical assistance to the Ministry of Health and its partners for multiple HIV and STI Surveillance and program Monitoring & Evaluation M&E activities.

The primary function of this position is to support UCSF with its data needs by developing and maintaining databases, reports, queries and other software to support its projects and programmes. The Database Administrator/Developer is expected to design databases to meet the needs for specific projects. Some projects will require the developer to import data form existing data sources into a UCSF-managed database, sometimes with data transformations. Therefore, an understanding of SQL is critical. Most projects will require the data to be disclosed via dashboards – often with some transformation or analysis of that data before it gets displayed. For example, data that originates from a single health facility may need to be aggregated into a district, provincial or national view on the dashboard. Visualizing data on dashboards will be a critical component of the developer. Additional software development needs may arise occasionally, such as the development of mobile apps, or interoperability layers between existing systems. As an integral part of the UCSF Kenya Office, the Database administrator/Developer will be expected to meet with stakeholders, funders and government officials, and draw up requirements based on their needs.

Roles and responsibilities

Using SQL Server 2014, the incumbent will:

· Map out the conceptual design for a planned database that is to contain large health-related datasets

· Design, develop and implement ETL programs to load various databases on a continuous and ongoing basis into a master database

· Develop queries, views, indexed views and other database objects to facilitate querying, reporting, and analysis

· Recommend, where appropriate and subsequently develop a data warehouse

· Monitor performance and manage parameters in order to provide fast responses to front-end users, establish the needs of users and monitoring user access and security

· Further refining the physical design to meet system storage requirements

· Install and test new versions of the database management system (DBMS)

· Maintain data standards, including adherence to the Data Protection Act

· Write database documentation, including data standards, procedures and definitions for the data dictionary (metadata)

· Control access permissions and privileges

· Develop, manage and test back-up and recovery plans

· Ensure that storage and archiving procedures are functioning correctly

· Work closely with IT project managers and system developers

· Communicate regularly with technical, applications and operational staff to ensure database integrity and security

· Commission and install new applications and customize existing applications in order to make them fit for purpose

· Manage the security and disaster recovery aspects of a database.

· Develop interfaces for interoperability to enable data syncing between databases

· Coordinate the execution of projects between other members of the informatics team, in collaboration with the Senior Manager for Global Health Informatics in San Francisco

· Any other duties assigned related to this job description

Requirements

· An appropriate degree in computer science, information systems or software engineering with a focus on database administration with three years’ experience – or at least six years of demonstrable experience in database administration

· At least three years of experience in one particular DMBS, either SQL Server or PostgreSQL

· Demonstrable experience in working with databases and SQL, including writing complex SQL queries

· Certification in a popular DMBS is considered a major advantage

· Experience with one or more of the following domains are considered advantages:

o Django

o (Bio)statistics

o Monitoring and Evaluation

o Epidemiology

o HIV

o Working in the health sector

o Linux

· Experience in meeting with external stakeholders (clients, government, etc) and coordinating with development team members

Additional requirements

· Must be willing to work occasionally during evening hours to participate in phone calls

· Some components of the job may be executed off-site, for example at a Government entity

· The incumbent must be willing to liaise and collaborate with other staff, and train them in the design, development and maintenance of these databases

How to apply:

To Apply:

Qualified Kenyan nationals are encouraged to apply.

All applicants must address each selection criterion detailed in the minimum requirements above with specific and comprehensive information. All applications must include the following:

· Cover Letter

· Current CV with names, email addresses and telephone numbers for three referees

· Salary History

Applications must be sent by email to HR.Kenya@ucglobalprograms.org with the email subject Database Administrator/Developer.

Only short-listed candidates will be contacted. Position will remain open until filled.

Did you find apk for android? You can find new Free Android Games and apps.
Don't Miss Another Job Opportunity !

Join over 15,000 people who get notified daily. Enter your Email Address and subscribe for free.