DATABASE SPECIALIST

Terms of Reference

CARE International in Lebanon is seeking a senior-level database specialist (or consultancy firm) to design a programme database that manages beneficiary information and services, performs some data analysis, and create reports. It will include demographic information, project information, services received, scores on various tests, and other related information. The database is to be designed based on a discussion with the CARE Project Manager and MEAL team, along with a 2-3 hour brainstorming workshop will all CARE programme team (10-12 individuals). This workshop will be led by the consultant who will also be responsible for training relevant members of CARE’s team (10-12 individuals) on how to manage and update the database. Developed material will be the property of CARE International in Lebanon.
 

Database functions and specifications

• Import data in xls format and from online servers of beneficiary lists
• Provides layouts/formatting enabling English-only speakers to use the database for review and analysis purposes
• Employs unique identifiers per individual clients/beneficiaries
• Multi-level password protection to assure anonymity of PLHIV clients and confidential information
• Data validation
• User-friendly format (drop down lists, checkboxes, auto populating fields…)
• Data exportable to other software such as Excel
• Usable offline

Other functions may be identified as part of the conceptualization and consultation process.

Deliverables

• Study sources of information, tracking tools, and individual program information needs 
• One 2-3 hour brainstorming session with CARE programme team
• One database designed and ready to use
• Develop, test and validate a database system that will act as an online internal reporting system
• Two training sessions (4 hours each) on how to use, manage and update the database

Qualifications

• Extensive professional experience in database design for international NGO and/or private sector with at least 5 successful, complex databases designed and in current utilization by current or former clients
• Strong skills in database systems (PostgreSQL, SQL server, MySQL) as well in designing and using FileMaker Developer- certified (or equivalent in on job experience) in Microsoft Access 2010 (and/or other proposed software)
• Basic understanding of data security and encryption tools
• Experience producing user guideline manuals and training staff in the use of databases
• Able to design extremely user friendly databases that can be used by individuals with only basic computer literacy

Timeframe

The total process should take 5-6 weeks.