Dtb Consultant

Scope of Work CARE international in Lebanon is looking to hire a consultant or firm to design a program database that would both manage beneficiary information, services, some data analysis, and create reports. One consultant and/or consulting firm is sought to develop a new project database.  This team will likely comprise a software developer/ computer programmer who will lead the conceptualization process (requirements gathering process). 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 health  information Data validation User friendly format (drop down lists, checkboxes, auto populating fields…) Data able to be exported to other software such as Excel Able to be used offline Other functions may be identified as part of the conceptualization and consultation process. Expected Outputs Study sources of information, tracking tools, and individual program information needs  Develop, test and validate a database system that will act as an online internal reporting system Gather all relevant data currently located in different databases/software programs and ensure accurate inputting of data archive from various sources into the database; Workshop for users Qualifications The following are the desired qualifications of the consultant(s)/firm: 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