Database Applicant Consultant

Company profile


Crown Agents

Based in United Kingdom of Great Britain and Northern Ireland

We are an international development company that partners with governments, aid agencies, NGOs and companies in nearly 100 countries. Taking on clients’ fundamental challenges, we make lasting change to the systems and organisations that are vital for people’s well-being and prosperity. We bring an agile and resourceful approach to complex development issues.

Job Details
Employer: Crown Agents
Job Title: Database Applicant Consultant
Job Type: Full-Time
Location: Somalia
Category: Other

Crown Agents are pleased be recruiting a Database Applicant Consultant for an upcoming proposal


The Federal Government of Somalia (FGS) presented the PFM self-assessment report and a proposed PFM strengthening initiative (2013-2016) to Development Partners on April 4 2013. The self-assessment report highlighted weaknesses in the PFM systems which include

  1. weaknesses in revenue collection and management

  2. absence of long term budget planning and policy analysis to underpin annual budget formulation and execution

  3. lack of transparent comprehensive procurement and reporting on use of state resources.

Since then, the Government set out a PFM Reform agenda to address the weaknesses identified in the assessment. The PFM reforms are anchored on four platforms:

  1. instituting PFM fundamentals for budget credibility;

  2. effective budget execution and financial accountability;

  3. improved policy formulation, planning and budget preparation; and

  4. institutional structures; Strategic Human Resource Management (SHRM); Financial Management Information Systems (FMIS); and cross-cutting issues. The cross-cutting platform provides the beam that holds the whole reform platforms together to meet the overall PFM reform objectives.

FMIS Conceptual Model

The SFMIS is cognizant of the Somalia local context and avoids the ‘disruptive big-bang’ IFMIS implementation. The conceptual model for the SFMIS architecture was designed as a ‘fit-for-purpose’ bespoke solution to support the government treasury operations as a centralized processing system in the first instance and set the stage for future implementation of a packaged Computer of the Shelf (COTS). After learning phase and rehabilitation of government offices and with a cohort of graduates from the PFM education and training program, a full IFMIS implementation was conceptualized to cover the full PFM cycle with gradual modular roll-out to line ministries. A detailed needs assessment has been undertaken with the following deliverables

  1. Statement Of User Requirements (SOUR) – hardware and applications;

  2. Conceptual Design covering the re-engineered business processes with process maps with description of the processes and flow charts;

  3. System Design Document including conceptual diagram of the SFMIS architecture with key functional components of the proposed solution;

  4. upgraded SCoA for 2013 budget execution;

  5. change management and training plan; and (v) an interim Bespoke SFMIS for Treasury Management with user guide. The Government has recruited an individual application development consultant and FMIS Manager to oversee the development and deployment of the application and the supporting infrastructure. In addition, a dedicated SFMIS team of Government counterpart has been established.

About what you will be doing

The Key objectives of the assignment will be to undertake a structured quality assurance review of the SFMIS to confirm;

  1. implementation progress is in line with the conceptual design and Statement of User requirements and identify any implementation gaps
  2. the system has appropriate systems security controls in place
  3. identify existing and potential gaps and risks
  4. undertake end to end system security architecture review
  5. make practical recommendations and structured road-map to mitigate the identified risks, system improvements to the system enhance sustainability. As part of recommendations you will be expected to develop an SFMIS quality assurance program covering SFMIS IT Governance, IT Security Architecture Strategy, Support and Capacity Building.Project Timeline/Duration and Location

Project Timeline/Duration and Location

This role is subject to a successful bid. If successful, the contract for this assignment will run for a period of 3 months. The assignment will be undertaken in Mogadishu and Garowe, Somalia and based at the Ministry of Finance. You may be expected to occasionally visit procuring entities where SFMIS is implemented, together with the designated SFMIS focal point in the Ministry of Finance.

What you will need

As the Database Application Consultant, you will need the following minimum qualifications and competencies:

  • 5 plus years of work experience in development or administration of web-based/distributed SQL DBA/ equivalent public sector applications.
  • Experience installing and maintaining databases and replication in production environments.
  • Experience with SQL Server replication methods such as Data Guard/Golden Gate is preferable Demonstrated depth of knowledge of key technologies (e.g. RAC, ASM, OEM/Grid Control, RMAN, and Partitioning).
  • Performance tuning and optimization of SQL.
  • Required to deal and understand complex data models and object relational database mapping as it relates to system performance and stability.
  • Cursory knowledge of SQL Server 2005/2012R2, SQL. Advanced knowledge of SQL administration and tuning a plus.
  • Languages: C#, VB, .Net, Java, Shell Scripting, SQL Plus Reporting.
  • Experience with Oracle/Linux Engineered Systems (Exadata/ODA) is an added advantage.
  • Managing Software Development Projects and Use Source control (e.g. Git, Subversion)
  • Data mining skills.
  • Fluency in English.

About us

You’ll be working with Crown Agents which is a high impact social enterprise passionate about transforming the future for millions of people. Since our creation in 1833 we have worked across the globe to improve public services and drive economic growth. Our expertise is finding new solutions to difficult problems for clients in the areas of health, governance, economic growth, humanitarian action and supply chain services. We work with and train leaders at local, national and international level to achieve lasting change drawing on our insight and experience.

What’s on offer

Crown Agents offers a competitive benefits package.
In your application, please state your willingness to be based in Mogadishu and Garowe, Somalia and your daily fee rate.


Please submit your application by applying to the job announcement on our website:

Publish date: 2018-05-27 14:58:40
Premium Job: No
Back   Back   Print   Print   Company's jobs   Company's jobs     Views   Hits:357   Apply to this job   Apply       Add note     Add note        

You are here: Home