Database Administrator

Overview
Through funding from the Centers for Disease Control and Prevention (CDC), Jhpiego is implementing the project ‘Enhancing Global Health Security: Expanding Efforts and Strategies to Protect and Improve Public Health Globally’. This award builds on ongoing CDC funded investments to support the Global Health Security Agenda (GHSA) through implementation of programs focused on protecting and improving health globally. Through this grant, Jhpiego will support Uganda to strengthen surveillance data managing creating a centralized data warehousing, analysis, and visualization at designate national and sub-national levels, develop policies, procedures and relevant MoUs for surveillance systems integration, and implement targeted capacity building to data end-users on how to think about data.
At the end of the project life, CDC and MOH expect centrally available timely data for public health action, improved data access and exchange between systems across the country and a resilient data-intelligent workforce.

The Database Administrator will be responsible for managing and maintaining the databases developed by the project in compliance with local law and global best practice. He/she will ensure the security, availability, and performance of the database to facilitate the smooth operation of data systems developed and managed by the project.

Responsibilities
• Install, configure, and maintain databases on Linux servers (primarily MySQL and PostgreSQL).
• Monitor database performance to ensure optimal performance and availability, including transactional processing and response times.
• Develop and implement security measures to protect Databases from unauthorized access, including auditing and access control.
• Develop and implement backup and recovery procedures, ensuring data integrity and availability.
• Perform database backups, recovery procedures, and disaster recovery planning.
• Ensure uptime and availability of the database outside of scheduled down time maintenance.
• Plan and oversee database software and patch upgrades.
• Maintain data standards, including adherence to the Data Protection Act.
• Create and maintain documentation related to the database environment.
• Collaborate with development teams to design and implement database schemas, indexes, and queries that optimize database performance and ensure data integrity.
• Collaborate with system administrators to ensure optimal performance of the underlying Linux servers.
• Monitor and manage database server resources, including CPU usage, disk space, and memory usage.

Required Qualifications
• Degree in computer science, information technology, software engineering or related field
• Master’s degree in public health informatics is an added advantage.
• Relevant certificates in computer programming and software development
• Minimum of 4 years of experience as a database administrator.

Preferred Qualifications
• Experience with data warehouses / data centers/data warehouse environment and implementing data management solutions at large scale.
• Expertise in database management systems (DBMS) such as Oracle, MySQL, or Microsoft SQL Server. PostgreSQL experience preferred.
• Experience performance tuning SQL statements and resolving performance issues.
• 5+ years of experience in Linux database administration, including installation, configuration, and maintenance of MySQL and PostgreSQL databases.
• Experience with database security measures, including auditing and access control.
• Experience working with Linux Server Administration and Performance tuning.
• Experience with cloud-based database services such as Amazon RDS or Google Cloud SQL.
• Experience with scripting languages such as Bash and Python.
• Knowledge of database modelling and design
• Familiarity with hardware configuration for large scale databases in a high availability environment.
• Experience implementing data security and privacy policies.
• Experience working in an environment that utilizes bulk load operations
• Experience implementing data recovery and backup, as well as planning for disaster recovery.
• Patch management experience in a datacenter environment.
• Experience with Jasper and/or Kafka server administration.
• Excellent communication and interpersonal skills, and the ability to function on a high-performing team.
• Excellent problem-solving skills and attention to detail.