Data Base Programmer And Manager

 The Database Programmer and Manager is responsible for ensuring the accuracy and completeness of data collection, and adherence to agreed protocols and further analysis when required. The Position requires the following Computer Skills: Knowledge in PostgreSQL database administration and management General SQL querying. Programming: Python/Django, HTML, JavaScript and Bootstrap for UI Linux and some virtualization technologies knowledge ( e.g. Vagrant) Administering web servers like Apache httpd and nginx.  He/ She reports to the Hospital Manager. SPECIFIC ACTIVITIES Database Programming Leads in database design and architecture and implement database systems based on specified requirements. Creates complex functions, scripts, stored procedures and triggers to support application development. Developes database tables and dictionaries. Developes security procedures to protect databases from unauthorised usage. Assistes in preparing database functional and design specifications. Writes scripts, stored procedures and functions for database system. Performs quality assurance tests for ensuring data integrity and quality. Evaluates the database and recommend improvements for performance efficiency. Troubleshootes and resolves database problems, queries and error reports in accurate and timely manner. Interacts with staff to understand the database requirements. Writes instructions or teach employees how to use the software and provide programmatic guidance and support to team members when needed. Leads in identifying process improvements for database performance, reliability and stability. Identifies any issues related to database performance and provide corrective measures. Ensures data quality and integrity in databases. Maintaines accurate and complete database programming documentations. Performs data back-up and archival on regular basis. Evaluates the new database and in place improvements for performance efficiency. Data Collection   Formulates, implements, and enforces proper data collection policies and procedures   Trains and educates staff on proper data collection processes and on data collection tools and equipment  Ensures quality data collection techniques are established for reporting agencies  Establishes data quality standards and works with staff to ensure standards are met  Assists WTTC team management with data collection requirements  Provides on-going consultation and technical assistance  Determines with WTTC management team data needed to be collected and the appropriate data resources for specific research topics. Data System Management  Works closely with WTTC management team to submit data  Assists staff with set-up, testing, and implementation of data collection software  Ensures data system is effective and operational   Troubleshoots data submission errors and data error issues Responsible to develop data collection and evaluation methodologies Manages contracts with data collection software vendor (or ICRC Biuret and Geneva) Maintains close working relationship with software vendor in close collaboration with Hospital Manager and IT services. Ensures that all software updates are properly installed and rolled out with IT services support. Performs and documents procedures for data preparation including data cleaning, standardization and analysis  Consults with staff on data coding problems and assists in developing means to correct the problems  Develops and implements evaluation methodology related to various health data programs to determine completeness and adequacy of the data collection procedure. Maintains databases, developed reports and worked on quality assurance. Data reporting and analysis  Evaluates current recode-keeping systems to improve operations and patient care  Understands and ensures data governance and standards (confidentiality) Prepares monthly, quarterly, and annual data reports including analysis for distribution  Develops ad-hoc reports as necessary  on request of the Hospital Manager and/ or Health coordinator Presents data at conferences and ICRC meetings where needed Develops and maintains access data research portal  Shares data with other as needed in accordance with ICRC regulations and with agreement of the Health coordinator. Attends and participate in related data meetings as required May be required to represent WTTC/ICRC in meetings in and outside Tripoli Plays a key role in all research activities and contributes to reporting accordingly. Analyses and interpret a broad range of complex health information Developes and maintain databases on health from different departments  Effectively communicates the results of such analyses to specialist and non-specialist audiences. Undertakes audits and support research as required. Respondes in a timely and effective manner to ad-hoc queries on health information. Achieves and mange complete and clean data including completion of coding quality check. Leads, develops and manages the production of performance indicator data related to WWTC areas of care.  Treatment of information Registers and treats information (general and specific) accurately and with confidentially  Minimum required knowledge & experience:  University degree or professional diploma 3 - 5 years work experience in a similar field Very good knowledge of written and spoken English Excellent computer skills Team leadership skills Very good analytical skills   Standard function description: Performs various data processing on computer independently Performs internal and external follow-up of individual cases Carries out translations Ensures follow-up and updates of files/databases Trains data entry operators Participates in establishing and implementation of procedures