This website uses cookies to ensure a better experience. By using our service, you accept the use thereof. Click to view more information about cookies

Senior Database Engineer Hargeisa (Hargeysa)

Posted by Food and Agriculture Organization of the United Na Private Woqooyi Galbeed
  • Company: Food and Agriculture Organization of the United Nations
  • Experience: >10 years
  • Studies: Master
  • Category: IT - Internet - E-business
  • Contract: Temporary
  • Salary: Undefined
Under the overall supervision of the Officer in Charge (O.I.C.) FAO Somalia and under the direct supervision of the Senior Information Systems Advisor, the incumbent will perform the duties as defined below:BackgroundFAO Somalia implements numerous humanitarian and relief projects throughout Somalia targeting hundreds of thousands of beneficiaries. FAO partners with local service providers who collect data on each activity and beneficiary. The data collected enables FAO to better track the activity, and understand the household dynamics of its beneficiaries. Currently, much of the data are being collected using a standard data entry system which uses web-based forms and a backend MySQL database. The application runs on laptops which then send the data via email to Nairobi where it is stored, processed, and analyzed. The system is primarily structured to allow quick form creation and deployment, and data entry/storage. ObjectiveFAO Somalia is planning to dramatically increase the amount of data collected from each beneficiary household. The additional information will be collected during field work and via remote surveys (call center). The new information also needs to be mined in order to extract critical indicators which each sector will use to better understand the characteristics of their beneficiaries. The additional data and analytical needs will dramatically increase the requirements of the current database system. The current database needs to be prepared to handle a much larger load for storage and processing, and have the ability to automate and simplify analysis using business-intelligence type tools. Duties and responsibilitiesFAO Somalia requires a senior database engineer with experience in designing and implementing large relational databases for business intelligence purposes. The expert is required to review the current systems, business processes, and capacities and write a report which defines the design and change requirements for the new systems. The report will include a project plan, detailed scope for hardware, software, capacity, and guidelines for programming (database schema, scripts, optimization, etc) the enhanced system. The report should provide all necessary pieces to turn into a project plan which can be shared with potential programmers for in-house or outsourcing purposes.The expert will conduct individual and group meetings with members of Information Technology, Information Management, and some sectors in order to better understand the existing systems and the future needs. The foreseen steps are as follows:Review and Assess Research existing database, applications, including the biometrics software, the form management tools, other FAO software  Review a series of existing data collection forms and questionnaires which are being used by FAO Somalia to collect data in the field Review descriptive document (concept notes, system requirements documents, others) to better understand the work. Review existing capacities, procedures, tools, and business processesDefine Solution via ReportBased upon the assessment, draft a document and present internally. The report includes details on how to modify or redo aspects of the current system for the increased work load and analytical needs. The report will include detailed steps on the work plan in the following areas: Database enhancements:o design a schema (in E-R diagram) including data dictionaries o recommendations for script changes (provide examples)o recommendations for store procedures, functions, views, triggers, etco recommendations for indexes, constraints, foreign keys, queries, o recommended best practices and standards to be maintained.  Application and Programming requirements:o define application requirements (changes or new), o recommend enhancements or existing OSS/other tools, o recommend and give examples of code changes,  Optimizations o define optimization requirements for planned system to be able to handle hundreds of thousands of beneficiaries for maximum performance Train programmers in standards, best practices, and required modifications Work plan – detailed time line with steps including proposed test plan Budget – an estimated budget for additional hardware/software/capacities Staffing – develop ToRs for required staff  Hardware/Software Support and Maintenance – define the support Required Competencies:QualificationsUniversity level degree in software engineering or related field.Technical Competencies and Experience Requirements 12+ years experience designing and developing complex database models using OSS.  12+ years experience working as a database mining expert or similar using OSS.  5+ years experience with BI application architecture and development 5+ years experience as an advisor working with various clients on needs and requirements definitions, and estimation experience 5+ years experience in project management related to BI/data mining/analysis Systematic and efficient approach to work assignments  Able to comprehend appropriate solutions for different clients Strong analytical background  Ability to communicate complex concepts in a simple way Ability to work under pressure and work extra hours to meet deadlines  Extreme attention to details Excellent working knowledge of English
✔ Do not forget to mention AFRIBABA during your call!
Contact the advertiser ( Food and Agriculture Organization of the United Na)
Share this ad
Contact the advertiser
For a better visibility, place your ad in VIP
Report any scams attempts
100% 1
0% 0 dislikes
likes, 0 dislikes
afribaba.so is not responsible for the advertised product

Do you have something to sell, to rent, any service to offer or a job offer?

Post it at afribaba.so, it is 100% free ✔, local ✔, easy ✔, reliable ✔ and super fast ✔
Sell, Offer, Rent, Bargain, Search, Buy all you want for free. Yes 100% free Hargeisa (Hargeysa) Courses, Tutoring, Training
Are you looking for a job? Upload your resume online at the Job search section of afribaba.so 100% free.

1