Database Administrator at University of California San Francisco (UCSF)

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 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:

• 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