Responsibilities
Install, configure, and maintain databases on Linux servers (primarily My SQL and Postgre SQL). 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, My SQL, or Microsoft SQL Server. Postgre SQL 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 My SQL and Postgre SQL 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. Deadline for applications is Friday 5th July 2024.
Jhpiego, a Johns Hopkins University affiliate, is an equal opportunity employer and does not discriminate on the basis of gender, marital status, pregnancy, race, color, ethnicity, national origin, age, disability, religion, sexual orientation, gender identity or expression, veteran status, other legally protected characteristics or any other occupationally irrelevant criteria. Jhpiego promotes Affirmative Action for minorities, women, individuals who are disabled, and veterans
#LI-EM1
