Database 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: · Windows SQL Server 2012 and 2014 · Writing Queries Using Microsoft SQL Server Transact · Implementing and Maintaining Microsoft SQL Server Reporting Services · Programming: VB.NET, PHP, HTML and other · Databases management, and designs (SQLServer, Mysql, Oracle and other, MS Access) He/ She reports to the Hospital Manager. SPECIFIC ACTIVITIES Database Programming · Lead in database design and architecture and implement database systems based on specified requirements. · Create complex functions, scripts, stored procedures and triggers to support application development. · Develop database tables and dictionaries. · Develop security procedures to protect databases from unauthorised usage. · Assist in preparing database functional and design specifications. · Write scripts, stored procedures and functions for database system. · Perform quality assurance tests for ensuring data integrity and quality. · Evaluate the database and recommend improvements for performance efficiency. · Troubleshoot and resolve database problems, queries and error reports in accurate and timely manner. · Interact with staff to understand the database requirements. · Write instructions or teach employees how to use the software and provide programmatic guidance and support to team members when needed. · Lead in identifying process improvements for database performance, reliability and stability. · Identify any issues related to database performance and provide corrective measures. · Ensure data quality and integrity in databases. · Maintain accurate and complete database programming documentations. · Perform data back-up and archival on regular basis. · Evaluate 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 · Work 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. · Maintained 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. · Attend 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. · Analyse and interpret a broad range of complex health information · Develop and maintain databases on health from different departments · Effectively communicate the results of such analyses to specialist and non-specialist audiences. · Undertake audits and support research as required. · Respond in a timely and effective manner to ad-hoc queries on health information. · Achieve and mange complete and clean data including completion of coding quality check. · Lead, develop and manage 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