20 October 2017
PDF/Print version
Returning applicants, please log in
Not registered? Register here
List of closed vacancies
Return to current vacancies list
Vacancy Notice No: IARC/13/FT388
Title: Database Developper - Local recruitment
Grade: G5
Contract type: Fixed-term Appointment
Duration of contract:  One year - position expressly established for a limited duration of one year. Any extension subject to availability of extra-budgetary funding.
Date: 16 September 2013
Application Deadline: 6 October 2013 Vacancy Filled
Duty Station:  Lyons, France
Organization unit: IARC (IARC)
Section of Nutrition and Metabolism (NME)/Nutritional Epidemiology Group (NEP)
Within the Section of Nutrition and Metabolism (NME), the overall objectives of the Nutritional Epidemiology
Group (NEP) are to investigate the role of diet, nutrition (micronutrient deficiency, fatty acid balance,
under/over-nutrition), hormonal factors, physical activity and energy balance on cancer risk, with particular
consideration of gene-diet/nutrient/environment interactions.
Description of duties:
Under the supervision of Statistician and in collaboration with NEP Scientists and IT staff, the database developer is expected to:

- Analyse the current EPIC database (schema, procedures, screens,.).
- Migrate the current Oracle Database/Forms from Version 10 to Version 11.

- Redefine the schema of the database to store the additional data.
- Improve performance of calculation procedures.

- Write PL/SQL procedures to load, compute and extract data.
- Create forms to be used by data-managers to manage data and run procedures.
- Create reports on data process, data availability and quality checks.
- Improve the existing procedures to import/export data.

- Write ad hoc documentation on the database.
- Optimize the overall performance of the database.
- Participate in the data management.
Essential: Completion of secondary school with scientific orientation or equivalent, with subsequent specialised training in the field of data management recognized by a diploma (BTS/DUT or equivalent).

Desirable: A higher degree in a related field would be an asset.
Excellent knowledge of Oracle V10 or V11.
Excellent knowledge of Oracle/Forms and PL/SQL language.
Knowledge of Windows and Linux environnement.
Ability to work autonomously in a pressured environment and to prioritize.
Ability to write technical relevant documentation.
Tact, professionalism and flexibility in assisting others.
At least 5 years of professional experience in Oracle database management and programming. Proven experience in designing databases, writing PL/SQL programs and developing user interface.
Excellent knowledge of English or French with a good working knowledge of the other.
Additional Information:
This recruitment is restricted to candidates residing up to a maximum of 50 kms from Lyons.

Salary: per annum Euro 37,825, net of tax.

This vacancy is open to applicants of either sex.
WHO/IARC is committed to workforce diversity.
WHO/IARC has its own Staff Health Insurance and Pension plans and is not part of the French Health Insurance ("SÚcuritÚ Sociale"), the French Pension system or the French unemployment benefit agency("Assedic").
Any appointment/extension is subject to WHO Staff Regulations, Staff Rules and WHO Manual.

Only candidates under serious consideration will be contacted for interview and test.

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

Online applications are strongly encouraged to enable WHO to store your profile in a permanent database. Please visit WHO's e-Recruitment website at: The system provides instructions for online application procedures.
All applicants are encouraged to apply online as soon as possible after the vacancy has been posted and well before the deadline stated in the vacancy announcement.

WHO is committed to workforce diversity.
Any appointment/extension of appointment is subject to WHO Staff Regulations, Staff Rules and Manual. Only candidates under serious consideration will be contacted.

Vacancy Filled

This vacancy is shown for viewing only. It is not currently open for applications
IARC has a smoke-free environment and does not recruit smokers or users of any form of tobacco.