Job: DATABASE MANAGER

Location: Nicosia, Cyprus
Deadline: Tuesday, 06 August 2013 

Description

DATABASE MANAGER

Location : Nicosia, CYPRUS

Application Deadline : 06-Aug-13

Type of Contract : Individual Contract

Post Level : International Consultant

Languages Required : English

Starting Date : (date when the selected candidate is expected to start) 02-Sep-2013

Expected Duration of Assignment : 1 year with possibility of extension

Background

The Committee on Missing Persons (CMP) in Cyprus is mandated to exhume, identify, and return the remains of people listed as missing as a consequence of the tragic events of 1963-1964 and 1974. This will enable the relatives of the victims to recover remains of their loved ones, arrange for a proper burial and close a long period of anguish and uncertainty, thereby promoting a process of reconciliation between both communities. The latter will be further encouraged by the important participation of bi-communal scientific teams at all stages of the process.

The CMP is composed of one Greek Cypriot Member, one Turkish Cypriot Member, and a Third Member nominated by the ICRC and appointed by the Secretary-General of the United Nations. UNDP provides operational support to the activities of the CMP and UNDP Partnership for the Future Programme (UNDP-PFF) manages the 'Support to the CMP' project (DEX).

The Database Manager is based in the CMP Anthropological Laboratory (CAL). The incumbent reports to the CMP Third Member and works in a close contact with the UNDP-PFF Operations Team.

Duties and Responsibilities

Summary of Key Functions:

• Database Management (Main Function);
• Hardware and software packages management;
• Networks administration;
• Web content management;
• Logistic Support;
• Other Duties and Responsibilities.

Database Management

Database Management is the main function of this position and there are two databases to be administered.

Antemortem / Anthropological / Postmortem Database

The Antemortem / Anthropological / Postmortem Database has already been installed on the IBM server with RAID system and based on Microsoft Access. Tasks required for the facilitation of data management and quality control are as follows:

• Physical management of all ante mortem files, ensure that ante mortem element of database is up to date;
• Update database with DNA results for each sampled element;
• Update database with the new sites code (newly opened excavation site);
• Update database with the new case code analysis upon receive the remains from the field;
• Check final inventory of remains, odontogram, sex, age and stature estimation, transfer DNA sample code to the re-associated bodies, pathology report, final inventory of commingled elements, movement of remains, movement of artefacts, final inventory of un-associated artifacts, retained artefacts;
• Check bone photos and ensure that photos correspondent to the anthropological description;
• Transfer photo from CDs received from the field archaeologists to the server and prepare chain of custodies;
• Ensure that proper coding is used for each site and each case, updating identified cases in ante mortem section with case numbers and updating cases in summary lab section with names of identified persons;
• Verification of consistency of the data entered in the database;
• Research into specific cases as required.

DNA database

Required tasks for the management of DNA database are as follows:

• Install database on the server for the identification process;
• Assign policy of the user level which will ensure that data will be used only by authorized persons such as identification coordinator and forensic anthropology coordinators;
• Maintain the database.

Reporting:

Generation of analytical and statistical reports comprising of:

• Anthropological reports: summary report, inventory report, osteology report, pathology report, report on commingled remains and associated data art facts;
• Archaeological reports: reports from data collected by the field staff, location and characteristics of the excavation sites, and the ante mortem information;
• Monitor information entered into the database by the field members and check consistency of each anthropological report;
• Update Lab and Field weekly reports and monthly report;
• Generate field reports on the request of CMP;
• Generate queries in the database for statistic reports on the request of the CMP Members as well as on request of the donors;
• Develop database on the request of the scientists related to latest scientific methods used in the identification process, including the design and development of forms and reports using Visual Basic code to set requested criteria.

Hardware and software packages management

Manages hardware and software packages, focusing on the achievement of the following results:

Server installation/configuration/maintenance

• IBM Server X series M3 with RAID controller;
• SAN Server for backup purposes;
• Software installation/configuration/maintenance;
• Microsoft Server 2008;
• Microsoft Windows;
• Microsoft Office;
• Symantec Antivirus;
• Device Lock Security software.

Workstation (personal computer) installation/configuration/maintenance

Networks administration

Ensures efficient networks administration, focusing on achievement of the following results:

• Monitoring of the computing resources to provide a stable and responsive environment;
• Monitor security of the networks;
• Defining network users and security attributes, configuring network printers and providing user access;
• Backup of server on a weekly and monthly basis;
• Monitoring of backup and restoration procedures;
• Timely upgrade of LAN infrastructure and Internet connectivity to meet requirements;
• Installation and maintenance of structural cabling, switches, fibre optic connections, patch panels, etc.;
• Liaise with UNFICYP ICTS section to maintain connection between the laboratory and UN server (Lotus Note is connected to UN Domain Server).

Web content management

Provides web content management services , focusing on achievement of the following result:

• Update of CMP Web Site content through content management interface;
• Liaise with web site content management system providing company for changes required.

Logistic Support

• Research new technology to be implemented within the process;
• Submit requirements and coordinate with the UNDP-PFF regards to purchases;
• Liaison with the UN Engineering Section to coordinate maintenance at the Lab;
• Act as point of contact between vendors / contractors and the CMP Lab to coordinate deliveries and installation of various equipment and scheduled service (generator, air-conditioning equipment, etc

Other Duties and Responsibilities

• Create chains of custody;
• Administration of documents for the CMP anthropological laboratory;
• Manage the CMP anthropological laboratory Security System, entry access point for personnel;
• Prepare chain of custody forms;
• Help the anthropologists, under their supervision, in the handling of remains;
• Attend weekly CMP meeting if invited by the CMP Members;
• Procurement Focal Point for CMP anthropological laboratory;
• Asset Focal Point for CMP anthropological laboratory.

Impact of Results

The key results have an impact on the overall efficiency of the CMP Anthropological Laboratory.

Competencies

Corporate Competencies:

• Demonstrates commitment to UNDP's mission, vision and values;
• Displays cultural, gender, religion, race, nationality and age sensitivity and adaptability;
• Highest standards of integrity, discretion and loyalty.

Functional Competencies:

Knowledge Management and Learning

• S hares knowledge and experience and provides helpful advice to others in the office;
• Provides helpful feedback and advice to others in the office.

Development and Operational Effectiveness

• Ability to provide IT support services including IT hardware/infrastructure support, other IT applications support, web site content management;
• Excellent knowledge of PC/LAN operating systems, Microsoft Windows, corporate ICT security and viral protection systems, knowledge of web design, knowledge of Microsoft Windows network administration, ERP;
• Strong analytical skills;
• A bility to provide input to business process re-engineering, elaboration and implementation of new systems.

Leadership and Self-Management

• Focuses on result for the clients and respond positively to feedback;
• Consistently approaches work with energy and a positive, constructive attitude;
• Demonstrates strong oral and written communication skills;
• Remains calm, in control and good humored even under pressure;
• Responds positively to critical feedback and differing points of view;
• Solicits feedback from staff about the impact of his/her own behavior.

Required Skills and Experience

Education:

• Bachelors degree in Computer Science or related discipline. Masters degree in Information systems or Information Management is desirable but is not a requirement;
• Microsoft and Cisco certifications are strong asset including Cisco Certified Network Administrator / Cisco Certified Network Engineer and Microsoft Certified Professional / Microsoft Certified Systems Engineer.

Experience:

• Minimum 4 years of relevant experience in the area of Information and Communication Technologies including database management, hardware and software packages management, networks administration and web content management.

Language Requirements:

• Fluency in English;
• Knowledge of Greek and/or Turkish is a strong asset but not a requirement.

Other:

• Valid driving license is required for the use of office cars for the official purposes as requested by the supervisor.

Application:

Interested individual consultants must submit the following documents/information to demonstrate their qualifications:

• Motivation/Cover Letter : Explaining why they are the most suitable for the work;
• Personal History (P11) : Applicants are required to fill and sign a P11 Form and submit it together with the online application. The UNDP P11 Form can be downloaded from: http://europeandcis.undp.org/files/hrforms/P11_modified_for_SCs_and_ICs.doc
• References: Contact details of 3 references;
• Financial Proposal : Financial proposal will specify the daily fee in EUR per working day and shall cover all expenditures including fees, health insurance, vaccination, international (all travel to join duty station/repatriation travel) or local travel (place of residence to office and office to place of residence), cost of living and any other relevant expenses related to the performance of services. Leave benefits (annual, sick, paternity, maternity) are not applicable to Individual Contractor and absent days including weekends and office holidays are not payable.

Evaluation / Selection Process:

All applicants will be screened against qualifications and the competencies set above. Candidates fully meeting the requirements will be further evaluated based on the criteria below.

Technical Criteria (CV review and interviews) - 70 % of total evaluation- max. 70 points:

CV review: 30 points

• Educational qualifications and certifications as defined in the ToR (15 points)
• Experience as defined in the ToR (15 points)

Only candidates who obtained at least 70% of points from the CV desk review (who will score at least 21 points) will be invited for an interview

Interview: 40 points

• Experience in Database Management (10 points);
• Experience in other IT functions: hardware and software packages management, networks administration and web content management (10 points);
• Experience in working in a post-conflict setting (10 points);
• Language: Fluency in English (10 points).

Only those individual consultants who obtained at least 70% of points from the interview (28 out of 40) will be considered for financial proposal evaluation.

Financial Criteria - 30 % of total evaluation - max. 30 points.

• Financial scores will be calculated using the formula [lowest offer / financial offer of the candidate x 30].

UNDP applies the 'Best value for money approach' - the final selection will be based on the combination of the applicants qualification and financial proposal.

Payment Term:

• Monthly lump-sum payable upon submission of the monthly time-sheet and progress report and certification by the CMP Third Member.

General Conditions:

General Conditions of contract for the services of Individual contractor can be downloaded from: http://web.undp.org/procurement/documents/UNDP_GCC_IC_Final_English.pdf.

UNDP is committed to achieving workforce diversity in terms of gender, nationality and culture. Individuals from minority groups, indigenous groups and persons with disabilities are equally encouraged to apply. All applications will be treated with the strictest confidence.

More Info and Application