Database Specialist

Consultancy for Database Specialist
Terms of Reference
Background:

Saferworld is an independent non-governmental organisation that works to prevent and reduce violent conflict and promote cooperative approaches to security. We work with civil society, governments and international organisations to encourage and support effective policies and practices through advocacy, research and policy development, and through supporting the development of local capacities and structures.

Saferworld is currently implementing a design and field test component of its new Conflict and Governance Mapping (CGM) Project in Mogadishu, Somalia. The project aims to provide high quality analysis of Somalia’s peace and conflict dynamics, drawing on primary and secondary data, to international actors currently engaged in Somalia to transform their understanding of governance-related issues as well as aid them in monitoring and evaluation efforts.

Saferworld wishes to hire a consultant with extensive experience in the design of database structures to assist the CGM project.

The task/Scope of work:

• Design and construct a database for the CGM project;

• Ensure accurate inputting of data received from various sources and partners into database;

• Perform data analysis by producing graphs, charts etc. as directed by the Project Manager;

• Maintain and further develop the structure or format of the database as required, incorporating ideas and amendments from the CGM project;

• Train CGM project staff on the use of the database;

• Develop and maintain documentation database/design documentation and operating manual on how to use the database for the CGM project;

• Work with the Web Application Developer to develop and maintain a web interface for the database, in consultation with the Project Manager;

• Maintain strict confidentiality in all aspects of the work;

• Undertake any other tasks assigned by the Project Manager;

Person specification:

Minimum Requirements:

Education: University degree in Computer Sciences or related technical field;
Any Microsoft certifications in Access or SQL Server would be preferred;

Work experience:

• Minimum of 4 years work experience in database design or database administration, data management and data analysis,

• Significant experience analysing data and producing reports;

• Ability to use Microsoft Access databases i.e. enter data, update records and fields, modify database structure, generate customized reports;

• Experience programming Microsoft Access databases;

• Experience with SQL and VBA;

• Ability to design the structure of the database and write appropriate interfaces (e.g. Microsoft Excel) for data entry and ensure data quality and security.

• Experience in training project personnel in the use of database management software applications;

• Experience in writing and maintaining database design documentation and operating manuals;

• Maturity and professional ability to handle sensitive information and ability to respect the confidentiality of such information while working with Saferworld CGM Project and even after the contract ends.

Core Competencies

 Systematic and efficient approach to work assignments;  Good judgment and analytical ability;  Ability to manipulate large data sets, and excellent attention to detail;  Employs a proactive approach to foresee road-blocks and resolve them;  Excellent communication skills;

How to apply:

Applications should be submitted by e-mail no later than 12 June 2012 to Marie Aziz at recruitment@saferworld.org.ukFor terms of reference please go to http://www.saferworld.org.uk/about/jobs.