Database specialist

Result of ServiceA. New module added to the technical assistance needs database (see output 1). B. Enhanced PIC database, including interface translation (see output 2). C. Enhanced websites display and converted modules (see output 3). D. Produced report on options for a new document management system (see output 4). Work LocationHome Expected duration6 months Duties and ResponsibilitiesThe Secretariat of the Basel, Rotterdam and Stockholm Conventions (BRS Secretariat) brings together the three leading multilateral environmental agreements that share the common objective of protecting human health and the environment from hazardous chemicals and wastes. REPORTING AND SPECIFIC TASKS TO BE PERFORMED BY THE CONSULTANT Under the supervision of Ms. Claire Morel, Information Systems Officer, the individual contractor will perform the following tasks: Output 1: Add a new module to the technical assistance needs database (estimated duration: one month). The individual contractor will add to the technical assistance needs assessment database the latest information collected during the biennium. To achieve this task, the information collected will be repackaged and uploaded to the database. The visualization dashboards will be updated to accommodate the new information, and translations will be applied where applicable. Output 2: Further enhance the PIC database (estimated duration: two months). Following the recent rollout of the new version of the Prior Informed Consent (PIC) database, a number of enhancements and bug fixes are required, including interface translations. Output 2.a (estimated duration: one month): The following improvements shall be implemented: new properties should be added in the HTML editor; enabling multiple yearly values for production, use, import, export; enabling changing multiple chemicals identifiers without saving after each change; and adding a check for duplicate entries on the chemical form. Output 2.b (estimated duration: one month): The following improvements shall be implemented: links to the Final Regulatory Actions (FRAs) and Import Responses (IRs) should be added in the dashboards; enable sorting of recently published FRAs and IRs in search results; fix the failure list query to include import responses that are not valid; and add a demo account feature to the public forms. Output 3: Further enhance the BRS websites display (estimated duration: two months). Output 3.a (estimated duration: one month): Websites stylesheets and templates shall be optimized for performance, as well as visual aspects on desktops and mobile devices. Webpages content that are still using the old stylesheet should be re-packaged, for instance on webpages with text displaying the wrong background color, or wrong margins should be adjusted. The left column should be hidden when empty and its display better organized on mobile devices. Output 3.b (estimated duration: one month): in order to prepare the upgrade to the newest version of the website’s content management system (DotNetNuke), information handled by incompatible modules such as “Live Content” and “Reports” should be converted to use BRS standard technology based on Kendo UI library cards and grids components. The individual contractor will develop configurable widgets based on Kendo UI, and then migrate the information contained in the old modules and implement those new widgets on the targeted webpages. Output 4: Report on available options for the BRS Secretariat to replace its document management system (estimated duration: one month). The BRS Secretariat will need to replace its document management system. The individual contractor will undertake market research and provide a report with options to help the BRS Secretariat to select the most appropriate replacement solution. Qualifications/special skillsHigh school diploma or equivalent is required. A minimum of 7 years of progressively responsible working experience in the field of computer programming, database design and data analysis from complex databases is required. Proven experience in system's analysis and design, computer programming, including advanced programming skills in MS VB or C# for .NET platform, using MS SQL Server databases, and good understanding of latest web technologies such as HTML 5 and CSS.3 is also required. Experience in the development and configuration of web applications based on DotNetNuke content management system and OData restful web services, using .NET, JQuery, and Kendo UI, is desired. Experience in using and configuring document management systems is desirable. Experience in working with international organizations dealing with environmental issues is desirable. LanguagesEnglish and French are the working languages of the United Nations Secretariat. For this position, fluency in English is required. Fluency in another UN official language is desirable. Additional InformationNot available. No FeeTHE UNITED NATIONS DOES NOT CHARGE A FEE AT ANY STAGE OF THE RECRUITMENT PROCESS (APPLICATION, INTERVIEW MEETING, PROCESSING, OR TRAINING). THE UNITED NATIONS DOES NOT CONCERN ITSELF WITH INFORMATION ON APPLICANTS’ BANK ACCOUNTS.