Posts
Position Title:Database Administrator
Organization:The Second Financial Management and Accountability Programme (FINMAP II)
Primary Location:Kampala,Uganda
Job Type : Full-time Employment
Terms:Contract for one (1) Year
Closing date: 20th June 2014
Brief Company Profile:
The Second Financial Management and Accountability Programme (FINMAP II) is
a wide programme
designed as the prime framework for implementation of
Government of Uganda Public Financial Management (PFM) reforms. It comprises
interventions both at central and local government levels and involves a number
of components and several stakeholders, including Development Partners.
The implementation of FINMAP II entails a significant amount of
coordination effort at all levels. This coordination requirement is met through
the contracting of Staff to support specific Programme areas. FINMAP II
requires the services of a Database Administrator to support the implementation
of financial management systems in the Public Financial Management Office of
the Ministry of Local Government:
A) Background
The Government of Uganda (GoU) designed a Second Financial Management and
Accountability Programme (FINMAP II) as a successor program to the
Financial Management
and Accountability Programme (FINMAP). The primary purpose of the FINMAP II
is to deepen
and consolidate reforms in public financial management (PFM) aiming at
further strengthening and sustaining accountability and transparency in public
financial management, improving governance, and maximizing the Government’s
efforts towards poverty eradication
A large component of FINMAP is focused on the deepening, extension and
expansion of
the Oracle based Integrated Financial Management System (IFMS) to more
Government
Agencies and Local Governments. In Local Governments, the IFMS has
implemented in
eight (42) Districts, Kampala City Council Authority and its five (5)
Divisions. In addition,
the Government is following a three-tier strategy for implementation of PFM
systems in
Local Governments as follows:
1) Tier 1 Local Government
The local governments under this category will be computerized using the
oracle based
IFMS. We believe that these local governments have the basic infrastructure
to support
computerization using oracle. Government intends to roll out IFMS to
another 22 Local
Governments.
2) Tier 2 Local Governments
The 2nd Tier system will provide a simple but modern fiscal management
system , which
is effective, user friendly and with relatively low maintenance costs. This
will cover all
the remaining districts, municipal councils and some big town councils. The
procurement of
the 2nd tier solution is currently ongoing.
3) Tier 3 Local Governments
The remaining town councils together with all the sub-county councils will
be supported to
improve their manual financial management systems in the short run. In the
long run, this
category is expected to gradually move to the tier 2 system.
As a principle, Government intends to deploy the computerized systems in a
phased and
coordinated manner starting with the local governments that have the basic
infrastructure
to support the implementation and capacity to sustain the systems even
after the end of
the projects supporting them.
These systems are intended to improve budgeting, accounting and reporting
to enable
local governments plan and use their financial resources more effectively
and efficiently.
The three levels will have to be tightly coordinated and kept in harmony to
work as a
single system with a common goal.
As part of the implementation of FINMAP, a PFM Systems Office has been
established in the Ministry of Local Government to spearhead and support
implementation of PFM systems in local governments.
B) General Responsibilities;
The Database Administrator will be responsible for technically supporting
the relational
database management systems (RDBMSs) at the Ministry of Finance, Planning
and Economic Development Data Centre for the automated financial management
systems in local governments.
C) Specific Duties and Responsibilities;
(i) Maintain availability and integrity of LG databases through multiple
access schemes.
(ii) Monitor the LG relational databases to optimize database performance,
resource use,
and physical implementations of the database.
(ii) Address various database integration issues including migration
between disparate
databases, integration, maintenance/ conversion, capacity planning issues
and new application.
(iv) Monitor and maintain database security and database software.
(v) Develop RDBMS test environments as may be required from time to time.
(vi) Facilitate sharing of common data by overseeing proper key and index
management
and data dictionary maintenance.
(vii) Monitor and manage database backups, logs , and journals together
with systematic
data restoration and/or recovery procedures required.
(viii) Install, maintain and upgrade database software.
(ix) Maintain various database related documents such as manuals and
programmers
handbooks including developing GoU user unit tailored manuals, where
necessary.
(x) May provide 24 hour on-call support where required.
(xi) Maintains broad knowledge of state-of-the-art technology, equipment,
and/ or
systems.
(xii) Perform any other job-related duties assigned by management from time
to time.
D) Qualifications and Experience
1. Bachelor`s degree in IT related discipline such as Computer Science,
Statistics, Mathematics
Physics , and Business Administration.
2. Specialized Database Administration training and qualifications for
common large RDBMSs
e.g. Oracles, SQL are a must.
3. Experience of a minimum of two years directly related to duties and
responsibilities as
specified is essential.
E) KNOWLEDGE, SKILLS, AND ABILITIES REQUIRED
1. Ability to implement and troubleshoot programming changes and
modifications, to program ,
configure, manage, and maintain the operation of complex relational
databases.
2. Ability to develop and manipulate large complex data sets.
3. Knowledge of computer and / or network security systems, applications,
and hardware.
4. Knowledge of data integrity methods and techniques.
5. Ability to perform acceptance testing on computer systems, applications,
and hardware.
6. Ability to install, maintain , modify, and upgrade database software.
7. Technical writing skills.
8. Knowledge of current technological developments/ trends in area of
expertise.
9. Ability to operate on a scheduled 24-hour on-call basis.
10. Strong inter- personal and communication skills.
11. Output-oriented
F. Deliverables
At the end of his assignment, the Database Administrator is expected to
have successfully :
(i) Implemented the LGPFM systems in local governments.
(ii) Strengthened the ICT function in local governments.
(iii) Built capacity among LG staff to continue with the reforms.
G. Contract and Reporting Arrangements
The Database Administrator will be hired against a seven months (07) time-
base contract.
The Database Administrator will report to the Local Governments PFM Systems
Manager but will work closely with the Data Centre team in the Ministry of
Finance
Planning and Economic Development (MoFPED) and the PFM team in the Ministry
of
Local Government (MoLG).
The Database Administrator will be required to provide the following
reports:
(i) Quarterly performance reports
(ii) Annual performance reports
(iii) An end assignment report within two weeks after completion of the
contract.
MoLG will provide office space and relevant office facilities (furniture,
computer and
printing facilities, telephone, and email/ internet access) during the
period of the
assignment.
Annex B: Employee`s Reporting Obligations
The Employee in the discharge of his duties will ensure timely achievement
of the
outputs linked to the terms of reference and a timely submission of the
following reports.
1. Weekly brief report
2. Monthly Progress Reports
3. End of Assignment (Terminal) Report
Mode of Application:
Applications should be addressed and submitted to the address below by
1700hrs on 20 June 2014.
The Programme Coordinator
The Second Financial Management and Accountability Programme (FINMAP II)
Ministry of Finance, Planning & Economic Development
Finance Building; 3rd Floor, Office 3.4
Plot 2/12 Apollo Kaggwa Road
P O Box 8147
KAMPALA
Tel: 256-41-4707900,
e-mail: finmap@finance.go.ug
