Consultant – Database Architecture, NHA

  • GiZ
  • Job Reference Code: C-DA
Last date of application

Consultant – Database Architecture, National Health Authority, New Delhi

1. POSITIONS VACANT: Consultant – Database Architecture, National Health Authority, New Delhi


The Indo-German Universal Health Coverage Programme (IGUHCP) is part of Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH, Germany’s enterprise for international cooperation. GIZ works with Indian ministries at the Centre and State Governments for implementation of bilateral cooperation projects.

IGUHC works closely with National Health Authority under Ministry of Health and Family Welfare (MoHFW) and with selected state governments to provide policy advise and implementation support in the areas of Universal Health Coverage, Health Systems Strengthening, Social Health Insurance and health security. Other government ministries/agencies with which IGUHC works closely are NITI Aayog, ESIC, Ministry of Labour and Employment (MoLE), ICMR etc.

In the course of the COVID-19 pandemic, the programme is supporting the Governments at national and State level in implementing additional measures. The objective of these measures is to increase COVID-19 testing and treatment measures across the different regions.

Considering the extreme burden on State health system due to COVID and other health services that the health facilities and the workforce is required to perform, it is crucial to frequently analyse the needs and gaps in the health system to maintain delivery of essential health services. Therefore, Department of Health GoUP with support of GIZ-IGUHC would like to establish an IT cell, which can support the Monitoring and Surveillance related activities.

As part of IGUHC Professional Programme it is proposed to hire a team of consultants who will support the  IT cell.  Consultants shall support in the design, development, maintenance of various IT systems for delivery and monitoring of health services in all districts of Uttar Pradesh.


The Consultant – Database Architecture will support the NHA and coordinates his/her activities with the designated official of the NHA.

The incumbent will support the SHA in IT related activities and Database Management related to PM-JAY and state scheme. S/he shall support the SHA in all database related aspects. This includes but is not limited to all data warehousing, data management, performance tuning, maintaining backup, troubleshooting, training and providing technical support to field team and documentation.

Key Responsibilities:
Specific tasks:
(1) To make himself/herself thoroughly familiar with the processes, inputs and outputs of PM-JAY. To acquire an in-depth understanding of the IT guidelines of the scheme and role of IT at various interfaces of IT and program management; 

(2) Provide advice to NHA about setting up the necessary IT Infrastructure, Document & outline data architecture design and ongoing data management methodologies;
(3) Coordinate with the current IT team of PM-JAY within NHA and the National Informatics Centre (NIC) and any other IT agency hired by the NHA/ SHA;
(4) Attend the various training provided by the central or NIC team from time to time. To provide trainings to the functionaries national and state level as and when required by NHA/SHA;
(5) Maintain database by identifying and solving database requirements; supporting users;
(6) Review service related reports (e.g.:  database backups, maintenance, monitoring);
(7) Ensure service related issues are identified on a daily basisand resolved within established SLAs;
(8) Respond to database related alerts and escalations and coming up with strategic solutions to recurring problems;
(9) Analyze software requirements in regard of database and identify database requirements for new systems;
(10) Understand the requirements of the upper layer software, provide guidance to the software engineers for database operations;
(11) Support database functions by designing and coding utilities;
(12) Perform monitoring and troubleshooting by;
(a) Choose and apply monitoring tools
(b) Increase the performance of the tools
(c) Troubleshooting database problems
(d) Provide performance reports

(B) Documentation:
(1) Perform data analysis and produce reports in various formats including graphs, charts and when required;

(2) Develop and maintain technical documents database design documentation and operating manuals on how to use the IT system, Database for NHA/SHA and other stakeholders for PM-JAY and State health insurance schemes;
(3) Prepare reports etc. as per the need of the NHA and GIZ as per the need of the health department of GoUP, and GIZ-IGUHC.


Graduate degree/diploma in computer engineering, information technology or computer application or computer science or any other equivalent degree from a recognized institute/university.


(1) At least 8-10 years of post-qualification relevant professional experience in IT development and Management including database;
(2) Experience in troubleshooting and resolving database integrity issues, performance issues, connectivity issues, security issues etc.

Skills and Competencies:
(1) Strong knowledge of backups, restores, recovery models replication;
(2) Knowledge of open source technologies;
(3) MySQL/SQL Development and support – ability to write and troubleshoot SQL Code and design stored procs, functions, tables, views, triggers, indexes, constraints;
(4) Excellent computer proficiency and knowledge of commonly used software packages like MS Word, Excel, Power Point; knowledge of database, software is highly desirable;
(5) Ability to work independently when required;
(6) Excellent oral and written communication skills in English and Hindi;
(7) Demonstrated ability to work in a multi-disciplinary team.

5. VACANCY DETAILS: One vacancy

The offer made to the selected candidate shall be commensurate with qualifications, experience, and salary history.

7. LOCATION: The Consultant will be placed in National Health Authority in New Delhi and will be responsible for supporting the implementation of Ayushman Bharat PM-JAY Pan-India.

The post-holder shall be engaged on a consultancy contract, initially for a period of one year, extendable thereafter, on the basis of performance and approval by NHA.


Strategic Alliance Management Services P Ltd.
1/1B, Choudhary Hetram House, Bharat Nagar
New Friends Colony, New Delhi 110 025
Phone Nos.: 011-41011564/65; 4081 9900


Eligible candidates interested in the position are requested to apply using the link at the earliest.