Vacancy title:
Database Specialist

Jobs at:
Rural Electrification Agency (REA)

Deadline of this Job:
14th September 2018

Duty Station:
Kampala, Uganda

Summary
Date Posted: 31st August 2018 , Base Salary: Not Disclosed , Employment Type: Full-Time

The Rural Electrification Agency (REA) is implementing the Electricity Connections Policy (ECP) whose goal is to increase electricity access from the current 20% to 60% by 2027. The ECP was designed to address the major challenges that have kept electricity connections low and hence enable acceleration of connectivity throughout Uganda.The ECP targets to achieve an average minimum of 300,000 connections per year in order to achieve this goal.

JOB DETAILS:

The connections will be made by the licensed electricity distribution companies. These include: Umeme Limited, Kilembe investments Limited, Bundibugyo Energy Cooperative Society Limited, Kyegegwa Rural Electric Cooperative Society Limited, Pader —Abim Multipurpose Electric Cooperative Society Limited, West Nile Rural Electrification Company, Kalangala Infrastructure Services and Uganda Electricity Distribution Company Limited.

The Rural Electrification Agency (REA) will be responsible for the operationalization oi the ECP. As part of the efforts to support eiticient and effective implementation of electricity connections, REA is establishing a database system to enable efficient management of the connections data under the ECP.

REA seeks to engage the services os a Database Specialist to establish and manage the connections database under the forementioned ECP. REA is seeking to recuit individuals of high integrity, dedication, and dedication for the position of Database Specialist whose details can be viewed and obtained on the procurement notice board of REA at REA offices on www.rea.or.ug

Main Purpose
The Database Specialist will he responsible int the porlotntstncn. integrity and security oi the electricity connections database. The specialist will carry out the design, planning, development and maintenance ot the connections database, as well as troubleshooting any issues on behalf of the users.

Scope of the assignment and Key Responsibilities
Database Design and Set Up

•  Establish the needs of users and map out the conceptual design forthe database, considering both back-end organization of data and front-end accessibility tor end~users.
  
•  Establish mechanisms and develop formats for regular collection, validation, verilicatlon, processing and management of electricity connections data.
  
•  Develop and maintain a comprehensive user—friendly, accurate and efficient database of electricity connections.
  
•  Contribute expertise to applications, operations, and technical support teams to support the design of the database.
  

Manage Database Performance

•  Assesse database performance by developing a protocol for measurement of results and identification of problem areas. Provide fast responses to front-end users.
  
•  Monitor database performance, user access and security; evaluate and resolve processing and programming problems; design database management tools; and address user questions.
  
•  Review, validate and analyse the collected connections data and information and produce regular accurate statistics and analytical technical reports on the performance of the Electricity
  
•  Distribution Service Providers with respect to achievement ot connection targets.
  
•  Review the growth trend of connection numbers with emphasis on the deviations from the set targets, and prepare monthly, quality and annual connections progress report
  
•  Ensure that the Service Providers maintain an up-to-date connections database that is integrated with REA’s central databse
  
•  install and test new versions of the database management system (DBMS)
  
•  Maintain data standards, including adherence to the Data Protection Act.
  
•  Develop, manage and test back-up and disaster recovery plans.
  
•  Ensure that storage and archiving procedures are functioning correctly
  
•  Prepare access and control policies and procedures
  
• Develop guidelines for stakeholder access, use and acquisition of connections data, as well as protection of information.
  
•  Ensure that customer connection information is accurate y captured and updated in the GIS system. Manage and mai ntain multidimensional databases, user accounts, database availability, recovery, and reporting
  
•  Ensure an up-to-date and accurate database of connection information with no duplication.
  

User Support

•  Train users to utilize the system to enter and extract data
  
•  inform end users of changes in database
  
•  Create complex query definitions that allow data to be extracted

Qualification and Experience

•  Bachelor's degree in Information Technology. Computer Science, and Business Computing, statistics or other closely related field.
  
•  Certifications in database management, GIS
  
•  A master's degree in Information Technology, Business Computing and Statistics will be an added advantage.
  
•  At least seven (07) years’ demonstrated work experience ina reputable organization preferably in Uganda's electricity nectar, with experience in collection, validation and analysis of large and management of large databases.
  
•  Excellent analytical skills.
  
•  High level ot computer literacy, with experience in the use oi‘ relevant packages.
  
•  Highly motivated, innovative, pro-active and committed team player.
  
•  Excellent written and verbal communication skills. Fluency in English.
  
•  Excellent report writing skills.
  

Period of pertormance
The assignment shall be for a period of 2 (Two) Years subject to probation period of 6 (Six) months, and renewable subject to satisfactory pertormance
Reporting:
The Database Specialist shall report to the Manager, Connections Department
Duty Station: ‘
The Database Specialist position will be based in Kampala.