Database Developer

Since 2021, Jhpiego has been supporting the Philippines to strengthen its cervical cancer control and prevention program by improving access to optimal screening and early treatment technologies, continuity of care, and messages on cervical cancer prevention. This was done through innovative health systems strengthening approaches that allow health providers to deliver quality services, empower program managers make evidence-based decisions, primary health facilities build stronger ties with communities of women, and women participate in maintaining their health.

Further, the implementation of Centralized Laboratory Model for HPV DNA Testing (CLAMS) Phase 2 using the centralized and point-of-care testing models aims the scale up the cervical cancer screening using the highly accepted self-sample collection and HPV DNA molecular assay test with genotyping. Local health systems improved coverage through a hub-and-spoke service model that decentralized care while also empowering health providers to deliver timely solutions to daily operational challenges.

In lieu of the expansion of the CLAMS project implementation to other highly urbanized cities in the county (Cebu City and Davao City) and scale up of work setting service delivery model in Taguig City the project aims to strategically streamline the data collection, patient record management & inventory, improve patient compliance and service referral through development of a omprehensive health information system that will track the client’s journey from screening to treatment.

• Collaborate with stakeholders to gather and understand project requirementsProvide technical insights and align database development goals with project objectives.
• Participate in project inception meetings to establish timelines, deliverables, and technical expectations.
•  Work closely with M&E Analyst to develop a cohesive development strategy which includes the architect database structures that meet performance, scalability, and data integrity requirements.
•  Design database schema, tables, and relationships based on business logic and workflows.
• Install and configure database systems to meet organizational standards.
• Optimize database environments to support high availability and disaster recovery strategies.
• Plan and execute seamless data migration processes from legacy systems to new database platforms.
•  Ensure data accuracy, integrity, and minimal downtime during migration.
• Develop and refine SQL queries to enhance database performance. 
• Analyze query execution plans and implement necessary indexing or partitioning strategies. 
• Implement robust security protocols to safeguard sensitive data. 
• Conduct rigorous database testing to identify and resolve bugs or inefficiencies.
• Ensure databases meet functional, performance, and security requirements before deployment.
• Create detailed technical documentation, including database design specifications and operational guides.
• Develop and deliver training materials for end-users and technical teams. 
• Provide ongoing support for database systems, including troubleshooting and performance tuning.
• Monitor database health and implement regular updates, patches, and backups.

• Bachelor’s Degree: A degree in Health Science related courses, Information Technology, Software Engineering, Health Informatics is essential.
•  At least 5-10 years of demonstrated experience in designing disease surveillance framework, development of a case-based health information system (e.g. OHASIS, ITIS, COVID), and report dashboard is required.
• Experience in integrating databases with electronic health records (EHRs) or other HIS components.
• Proficiency in relational databases (e.g., MySQL, PostgreSQL, Oracle, SQL Server) and NoSQL databases.
• Knowledge of Python, Java, C#, or PHP, especially for integrating databases with HIS applications.
• Experience in data warehousing solutions and Extract, Transform, Load (ETL) tools for managing large-scale health data.
•  Understanding of encryption, access controls, and compliance with the Data Privacy Act is essential.