Integrated Health Information Platform (IHIP) – Senior Database Administrator

Medical & Health

Overview

Support the IHIP IT team for database management.

You have:

• Bachelor’s Degree in computer science or Computer applications or any related field
• At least two years of demonstrable experience in project development with DBA case tools and third-party tools
• Excellent knowledge of written and spoken English and working knowledge of at least one other national language will be an asset
• Experience in database design, development, deployment & troubleshoot preferred
• Proven working experience as a Database Administrator

Contract

This is a No grade contract. More about No grade contracts.

The incumbent will be initially stationed at the prospective location. S/he could be posted anywhere in India as per the Project needs.

Overview of the programme

WHO India Country Office collaborates with the Government of India and relevant stakeholders within the framework of the collaborative Country Cooperation Strategy (CCS), to actively support the development and implementation of national health policies, strategies and plans aiming at promoting access to and utilization of affordable and quality health services and improving financial protection against health-related risks.

Ministry of Health and Family Welfare - Government of India (MoHFW), with WHO technical support, has developed and implemented a web-enabled, near real-time electronic information system, called the Integrated Health Information Platform (IHIP). The vision of IHIP is an essential part of India’s National Digital Health Plan. IHIP is designed to serve as a single, centralized mechanism to integrate health information across all health and health-relevant data from various national programs and entities.

Underlying Values and Core Functions of WHO

WHO’s mandate revolves around six (6) leadership priorities specifying (i) advancing universal health coverage (ii) health related sustainable development goals (iii) addressing the challenge of non-communicable diseases and mental health, violence and injuries and disabilities (iv) implementing the provisions of the International Health Regulations (2005) (v) increasing access to quality, safe, efficacious and affordable medical products (vi) addressing the social, economic and environmental determinants of health.

The South – East Asia Region (SEAR) of WHO is made up of 11 countries, with over 1.8 billion people, with India’s population of 1.3 billion. All the Member States of WHO/SEAR (Bangladesh, India, Bhutan, Myanmar, Sri Lanka, Nepal, Indonesia, Maldives, Timor Leste, Democratic People’s Republic of Korea, Thailand), share the common value of the highest attainable standard of health as a fundamental human right. All of WHO actions are based on this and rooted in the underlying values of equity, solidarity and participation.

Mission of the WHO Country Office for India

The mission of WHO India is to improve quality of life of the 1.3 billion people in India by supporting the government in eliminating vaccine preventable and other communicable diseases, reducing maternal and neonatal mortalities, promoting healthy lifestyles, addressing determinants of health, preparing and responding to health emergencies and strengthening health systems for UHC.

WHO Country Office for India has supported the Ministry of Health & Family Welfare to design, develop and deploy the Integrated Health Information Platform. Currently under IHIP three modules are functional:

Health Management Information System (HMIS): It is a Government to Government (G2G) web-based Monitoring Information System that has been put in place by MoHFW to monitor the National Health Mission and other Health programmes and provide key inputs for policy formulation and appropriate program interventions.

Integrated Disease Surveillance Program (IDSP): This is the module developed within IHIP which enables real-time disease surveillance and reporting from any electronic device for 33 major outbreak-prone diseases.

Malaria (VBDC) module: IHIP module to monitor the malaria cases & control activities.

The current vacancy is to strengthen the IHIP IT team support to the MoHFW.

Description of Duties:

The incumbent will work under the overall guidance of the WHO Representative, Deputy Head of WHO Country Office for India, direct supervision of National Professional Officer (High Threat Pathogens) and overall supervision of Team Leader – (Health Security and Emergency Response). S/he will have the following responsibilities in her/his assigned area of work:

A Senior Database Administrator (DBA) will guide and support the team to keep the database up and running smoothly 24/7 to provide a seamless flow of information throughout the platform & related applications, considering both backend data structure and frontend accessibility for end-users. The specific job responsibilities are:

• • Provide technical and operational support activities of Database Servers, including logical and physical database design support, API development, troubleshooting, performance monitoring, tuning, and optimizing;
  • Provide guidance and technical support to entire development team and support teams for appropriate design considerations, development standards, support procedures;
  • Participate in discussions with departments to understand and suggest right design approach for new features, enhancements or integration requirements;
  • Ensure priority and work allocation among support resources and development team;
  • Assist in designing new features, considering overall architecture of the application, input received from field testing and user experience;
  • Build database systems of high availability and quality depending on each end user’s specialised role;
  • Design and implement database in accordance to end users information needs and views
  • Define users and enable data distribution to the right user, in appropriate format and in a timely manner;
  • Provide proactive and reactive data management support and training to users;
  • Determine, enforce and document database policies, procedures and standards;
  • Perform tests and evaluations regularly to ensure data security, privacy and integrity;
  • Monitor database performance, implement changes and apply new patches and versions when required;
  • Provide technical and operational support for Database Servers, including logical and physical database design support, troubleshooting, performance monitoring, tuning, and optimizing;
  • Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage;
  • Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime;
  • Develop Stored Procedures and Database Triggers in support of application development;
  • Participate in the creation of development, staging, and production database instances, and the migration from one environment to another;
  • Responsible for writing, monitoring and maintaining required shell scripts, batch jobs and system performance on Linux/Ubuntu Operating Systems;
  • Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release;
  • Responsible for regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving);
  • Responsible for pro-active remediation of database operational problems;
  • Responsible for Query tuning and preventative maintenance;
  • Other related duties as deemed essential to support IHIP lead technical architect; and
  • Undertake any other activities / tasks as assigned by the supervisors.

QUALIFICATIONS REQUIRED

Education:

Essential: Bachelor’s Degree in computer science or Computer applications or any related field

Desirable: Post graduate degree in computer science and engineering or in any of the fields related to the functions of the post

WHO only considers higher educational qualifications obtained from accredited institutions. The list can be accessed through this link: http://www.whed.net/

Experience:

Essential: At least two years of demonstrable experience in project development with DBA case tools (frontend/backend) and third-party tools, of which at least one year of experience working with any other national level health information systems or similar large scale information system.

Desirable: Experience in database design, development, deployment & troubleshoot; Applicants having experience in working with government health departments, other health actors and working with UN agencies shall be at an advantage.

Competencies:

• Teamwork
• Respecting and promoting individual and cultural differences
• Communication
• Producing results
• Moving forward in a changing environment

Functional Skills and Knowledge:

• Excellent understanding of IHIP or similar Health Information Platform
• Proven working experience as a Database Administrator
• Hands-on with database standards and end user applications
• Excellent knowledge of data backup, recovery, security, integrity and SQL
• Familiarity with database design, documentation, and coding
• Familiarity with programming languages API
• Problem solving skills and ability to think algorithmically
• Hands on with PostgreSQL, MySQL, MSSQL, SQL Developer, PGADMIN, DBeaver, Toad, Benthic, Putty and Jasper Reports and other tools.
• Hands on with Linux /Ubuntu Operating systems usage for writing shell scripts, scheduled jobs, monitoring VM performance.

Language Skills

Essential: Excellent knowledge of written and spoken English and working knowledge of at least one other national language will be an asset.

Remuneration:

Monthly remuneration is INR 2,06,377 taxable as per Indian laws and the appointment will be through Special Services Agreement (SSA) extendable subject to satisfactory performance and continuing need for the function. S/he could be posted anywhere in India as per the project needs.

Additional information:

• Integrated Health Information Platform (IHIP) – Senior Database Administrator is a national of the country (India) in which he/she is to serve, is recruited locally and is not subject to assignment to any official station outside the home country. Only Indian nationals should apply. This Vacancy Notice may be used to fill similar positions at the same level.
• Only candidates under serious consideration will be contacted.

• A written test and interviews will be used as a form of screening

• WHO is committed to workforce diversity.

• WHO prides itself on a workforce that adheres to the highest ethical and professional standards and that is committed to put the WHO Values Charter into practice.
• WHO has a smoke-free environment and does not recruit smokers or users of any form of tobacco.
• This post is subject to local recruitment and will be filled by persons recruited in the local commuting area of the duty station.
• In the event that your candidature is retained for an interview, you will be required to provide, in advance, a scanned copy of the degree(s)/diploma(s)/certificate(s) required for this position. WHO only considers higher educational qualifications obtained from an institution accredited/recognized in the World Higher Education Database (WHED), a list updated by the International Association of Universities (IAU)/United Nations Educational, Scientific and Cultural Organization (UNESCO). The list can be accessed through the link: http://www.whed.net/. Some professional certificates may not appear in the WHED and will require individual review.
• For information on WHO's operations please visit: http://www.who.int.
• WHO has zero tolerance towards sexual exploitation and abuse (SEA), sexual harassment and other types of abusive conduct (i.e., discrimination, abuse of authority and harassment). All members of the WHO workforce have a role to play in promoting a safe and respectful workplace and should report to WHO any actual or suspected cases of SEA, sexual harassment and other types of abusive conduct. To ensure that individuals with a substantiated history of SEA, sexual harassment or other types of abusive conduct are not hired by the Organization, WHO will conduct a background verification of final candidates.
• The incumbent should contribute to ensuring high professional, ethical, and institutional standards of the Organization. S/he should also meet professional conduct expectations, and basic universal norms of honesty, integrity, loyalty, and lawful behavior. This includes compliance with the above, including ability to: perform within existing organizational structures and governance; adhere to WHO's processes; demonstrate gender and cultural sensitivity; demonstrate respectful and constructive interpersonal communication; perform as a team player; and demonstrate due diligence. Any extension of appointment would be subject to programmatic requirements, performance of the incumbent and availability of funds.
• Qualified female candidates are encouraged to apply.

Apply now

Potential interview questions

Added 3 years ago - Updated 1 year ago - Source: who.int