Defining and implementing event triggers that will alert on potential database performance or integrity issues Monitoring usage, transaction volumes, response times, concurrency levels, etc.

Identifying reporting, and managing database security issues, audit trails, and forensics Designing database backup, archiving, and storage strategy

Using Business Intelligence tools and other available resources

To produce reports Perform SQL queries - design, code, test, and aggregate the results to create useful information Write technical documents on database content

Map various databases used in the organization Develop, design, and analyze data architecture and data warehouses

Promote team collaboration, knowledge sharing and effective adaptation of innovative solutions to create cohesion and synergies between the technical units, Programme and ICT teams;

Perform other related duties and replace colleagues, as assigned by the supervisor.Under the direct supervision of the Business Solution & Innovation Lead, and broad guidance of the ICT Manager, the incumbent provides support in the following areas:

Works with Azure DevOps on the development of the full life cycle of software or applications and to support the build, testing, and deploying software applications and to assist general DevOps-associated tasks that Azure DevOps supports

Create and maintain database standards and policies

Support database design, creation, and testing activities

Manage application schemas, application objects, and application performance in the database

Identify and fix application performance issues in the database. Assist in keeping the application up and running with good performance

Defining and implementing event triggers that will alert on potential database performance or integrity issues Monitoring usage, transaction volumes, response times, concurrency levels, etc.

Identifying reporting, and managing database security issues, audit trails, and forensics Designing database backup, archiving, and storage strategy

Using Business Intelligence tools and other available resources

To produce reports Perform SQL queries - design, code, test, and aggregate the results to create useful information Write technical documents on database content

Map various databases used in the organization Develop, design, and analyze data architecture and data warehouses

Promote team collaboration, knowledge sharing and effective adaptation of innovative solutions to create cohesion and synergies between the technical units, Programme and ICT teams;

Perform other related duties and replace colleagues, as assigned by the supervisor.

•     Knowledge of core Cloud Computing services for an Azure/AWS platform.
•     Should have experience in using products such as DevOps, PowerShell and Office 365.
•     Need to be conversant with structured query language (SQL) and relevant database technologies.
•     Familiar with relevant database technologies including SQL Server, MySQL, Oracle, IBMDb2, and MongoDB, among others.
•     In-depth knowledge of at least one programming language and Working knowledge of open-source languages like PHP Familiarity with OOP design principles and experience with third-party libraries and APIs.

Skills

•     Thorough knowledge of modern office procedures and practices.
•     Ability to draft business cases and technical documentation;
•     Ability to handle work in a timely and accurate manner with tact and discretion, as required.
•     Ability to maintain and update knowledge in the use of office technology through in-house courses, on-the-job training and/or self-training

WHO Competencies

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

Use of Language Skills

•     Essential: Expert knowledge of English.

This vacancy notice may be used to fill other similar positions at the same grade level

    Only candidates under serious consideration will be contacted.

    A written test may be used as a form of screening.

    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.

    According to article 101, paragraph 3, of the Charter of the United Nations, the paramount consideration in the employment of the staff is the necessity of securing the highest standards of efficiency, competence, and integrity. Due regard will be paid to the importance of recruiting the staff on as wide a geographical basis as possible.

    Any appointment/extension of appointment is subject to WHO Staff Regulations, Staff Rules and Manual.

    For information on WHO's operations please visit: http://www.who.int.

    The WHO is committed to creating a diverse and inclusive environment of mutual respect. The WHO recruits and employs staff regardless of disability status, sex, gender identity, sexual orientation, language, race, marital status, religious, cultural, ethnic and socio-economic backgrounds, or any other personal characteristics.

    The WHO is committed to achieving gender parity and geographical diversity in its staff. Women, persons with disabilities, and nationals of unrepresented and underrepresented Member States (https://www.who.int/careers/diversity-equity-and-inclusion)are strongly encouraged to apply for WHO jobs.

    Persons with disabilities can request reasonable accommodations to enable participation in the recruitment process. Requests for reasonable accommodation should be sent through an email to reasonableaccommodation@who.int

    An impeccable record for integrity and professional ethical standards is essential. 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 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.

    WHO has a smoke-free environment and does not recruit smokers or users of any form of tobacco.

    WHO also offers wide range of benefits to staff, including parental leave and attractive flexible work arrangements to help promote a healthy work-life balance and to allow all staff members to express and develop their talents fully.

    The statutory retirement age for staff appointments is 65 years. For external applicants, only those who are expected to complete the term of appointment will normally be considered.

    This post is subject to local recruitment and will be filled by persons recruited in the local commuting area of the duty station.

    In case the website does not display properly, please retry by: (i) checking that you have the latest version of the browser installed (Chrome, Edge or Firefox); (ii) clearing your browser history and opening the site in a new browser (not a new tab within the same browser); or (iii) retry accessing the website using Mozilla Firefox browser or using another device. Click the link for detailed guidance on completing job applications: Instructions for candidates