Job Details
The primary function of this position is tsupport UCSF with its data needs by developing and maintaining databases, reports, queries and other software tsupport its projects and programmes. The Database Administrator/Developer is expected tdesign databases tmeet the needs for specific projects. Some projects will require the developer timport data form existing data sources inta UCSF-managed database, sometimes with data transformations. Therefore, an understanding of SQL is critical. Most projects will require the data tbe 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 tbe aggregated inta 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 tmeet 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 tcontain large health-related datasets
Design, develop and implement ETL programs tload various databases on a continuous and ongoing basis inta master database
Develop queries, views, indexed views and other database objects tfacilitate querying, reporting, and analysis
Recommend, where appropriate and subsequently develop a data warehouse
Monitor performance and manage parameters in order tprovide fast responses tfront-end users, establish the needs of users and monitoring user access and security
Further refining the physical design tmeet system storage requirements
Install and test new versions of the database management system (DBMS)
Maintain data standards, including adherence tthe 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 tensure database integrity and security
Commission and install new applications and customize existing applications in order tmake them fit for purpose
Manage the security and disaster recovery aspects of a database.
Develop interfaces for interoperability tenable 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 tthis job descriptionRequirements
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:
Django
(Bio)statistics
Monitoring and Evaluation
Epidemiology
HIV
Working in the health sector
Linux
Experience in meeting with external stakeholders (clients, government, etc) and coordinating with development team members
Additional requirements
Must be willing twork occasionally during evening hours tparticipate in phone calls
Some components of the job may be executed off-site, for example at a Government entity
The incumbent must be willing tliaise and collaborate with other staff, and train them in the design, development and maintenance of these databases
