Database Administrator – Ministry of
Economy and Finance (MEF) –
Management Systems International is a Washington, DC based international development firm with a 35-year history of delivering development results across the world. We operate in some of the most challenging political and economic climates in the world, including Pakistan, Afghanistan, South Sudan and Iraq. MSI currently employs 800 development experts in the fields of public sector management, monitoring and evaluation, governance and anti-corruption. For more information on MSI, please visit our website at http://www.msiworldwide.com . MSI has recently become a Tetra Tech Company.
Founded on October 1 st , 1988, the Centre de Formation et d’Encadrement Technique (CFET) is a private Haitian firm specializing in Management and Human Resources Development. CFET’s mission is to contribute to improved worker performance and to facilitate access to talented professionals whose skills match the needs and professional ethical codes of clients. CFET, in partnership with Management Systems International (MSI) manages the USAID KONEKTE program in order to provide technical support to the Government of Haiti.
Launched by USAID in November 2012, KONEKTE (KONesans E Konpetans TEknik) is a program designed to assist the Government of Haiti (GOH) with increasing capacity within Haitian ministries by identifying and placing experienced advisors in key positions. KONEKTE is a partnership between a Haitian firm (Centre de Formation et d’Encadrement Technique (CFET)), USAID, and the GOH, which aims to build local capacity to create a more stable and viable Haiti. KONEKTE’s main partner within the GOH is the Office of Management and Human Resources (OMRH). KONEKTE works closely with the OMRH to identify high-level advisors through a transparent and competitive recruitment process that prioritizes the expertise of Haitians and the Haitian Diaspora. Each Advisor is placed in a department to bridge a competence gap. In addition, consistent with the objectives of the USAID Forward initiative, KONEKTE strengthens the OMRH’s ability to ensure the sustainability of the program’s achievements.
The General Management (GM) of the Ministry of Economy and Finances is responsible for carrying out the project. The GM organized an operational group comprised of 10 ministry agents and concerned several general management teams and agencies associated with the ministry. This operational group or project committee is specifically in charge of defining and implementing the Information Technology Master Plan. The General Director names the Chief of Party to lead the operational group.
The expert will run the mission under the direction of the operational group’s Chief of Party and under the General Director’s supervision. The Haitian team Assistance à la Maitrise d’Ouvrage (AMOA) supports the work of the operational group. AMOA’s mission began on April 1st, 2015 and is ensured by two experts.
The Office of Management and Human Resources (OMRH) together with the Finance Ministry and with technical support from KONEKTE, a program financed by USAID, is recruiting a Database Administrator to strengthen the IT Unit and transform it into a fully-fledged Information Systems Department.
**To Note: With equal competence, preference will be given to Haitian professionals.**
***USAID/Haiti has the right to annul this post at any time.***
Closing Date: October 19, 2016
Location and Duration of Position:
The position will last for 18 months. The Database Administrator will be based at the MEF in Port-au-Prince, Haiti and will be under the General Director’s supervision.
After the earthquake eruption on January 12th, 2010, the MEF’s IT infrastructure was partially destroyed. Important reconstruction took place and service is now restored and has even surpassed what it was before the quake. The time has now come to advance and progress towards a more integrated and reliable IT system, against the back drop of the public finance reform’s strategy and action plan implementation, which the government adopted in May of 2014.
The MEF’s IT unit is responsible for the Ministry’s IT developments, including infrastructure projects connected to the Ministry’s diverse property networks. Within this context, an Information Technology Master Plan was produced, which allowed for IT development planning over a period of 5 years (2014-2019). The implementation of this Information Technology Master Plan must be considered quickly to guarantee the rapid introduction of diverse IT solutions. This must be done while observing the Master Plan’s application planning timeline. The Information Technology Master Plan’s recommendations include reinforcing the IT unit and transforming it into a genuine Information Systems Department.
The Haitian Civil Service is characterized by a lack of professionalism, due to the absence of public policies, standards, procedures and management tools necessary to organize and develop its structures. Staffing and nominations in particular do not conform to any well-defined framework, which leads to inappropriate conditions in human resource recruitment. Recruitment processes subjected to external pressures contribute to turning public service into a political tool, marked by structural weaknesses, lack of professional motivation and subsequent inefficiency. It is clear that provided services do not meet the population’s expectations.
The OMRH was created in 2005 as a response to the need to develop public policies in recruitment streamlining and in strengthening civil service structures. OMRH is in charge of steering this vast institutional reengineering project that offers coaching to ministries and autonomous agencies, permitting them to implement their sector reform plans in human resource management.
Six years later, this action took on full significance after the Haitian government took the initiative to reactivate OMRH, making it fully functional with the necessary resources to fulfill its mission. Among others, this mission is to pilot reform programs in ministries and institutions that are part of the civil service.
This support to the MEF serves to strengthen the IT Unit and transform it into a fully-fledged Information Systems Department through the recruitment of a Database Administrator. This mission is within a limited period of time. At the end of this mission the MEF will designate an administrative personnel member who will be in charge of continuing the mission and overseeing its continuous operation.
One objective will consist of consolidating the department responsible for running the Ministry of Economy and Finance’s information systems. Implementing the Information Technology Master Plan and building different MEF entities will generate a great number of important business applications and new IT infrastructure tools. These applications will involve daily database use. The Ministry must guarantee the data’s quality and availability in real time through permanent maintenance of these databases.
In particular, these databases consist of Back Office applications on which rest essentially a large part of the Ministry of Economy and Finance’s main functions. They regroup the ERP/IFMIS, the GED and other crosscutting applications, including the Information Systems Department, which must ensure optimal running conditions. As a result, a priority of the Database Administrator post is guaranteeing data quality and constant availability.
The Database Administrator, as part of the MEF, is one of the pillars on which the Operations Department rests. As such, the main objectives will be, among others, to:
- Define database standards in accordance with SI responsibilities
- Initiate good practices in development team operations
- Conceive and model databases
- Ensure technical support and assistance to IT specialists and users
- Administer and maintain databases
- Administer data repository
Overall, the Database Administrator conceives, manages and administers database management systems: he or she ensures information coherence, quality, security and permanent accessibility.
This person also carries out technological surveillance in order to anticipate updates and maintain the adequacy of database performance and specificities, while still conforming to the Ministry’s SI strategic direction. In order to achieve the defined objectives, the Database Administrator will dedicate him or herself to a set of activities concerning the functions of the job. These functions are the following:
- Database Conception and Modeling;
- In close collaboration with the SI architect, put in place database standards, recommend good practices in development team operations;
- Carry out database implementation choices with respect to specifications and in collaboration with different project actors (project manager, architects, integrators, ERP consultants, IT decision experts);
- Define database parameters in an optimal way;
- Define database security rules (physical and logical) as well as basic use standards;
- Model the base and conceive the tables and keys;
- Take into account internal specificities (MEF management or internal entities as requesters) and external ones (any direct or indirect partner interacting with SI or the MEF) in collaboration with the infrastructure architect, particularly concerning base size (capacity planning);
- Database and Repository Administration and Maintenance;
- Create bases and insert data on physical supports;
- Create dimensions for servers;
- Guarantee the data’s quality and availability through maintaining and improving performance (tuning) and operations (improving automating, optimizing processing and queries, configurations);
- Monitor database object access performance statistics, thus working to ensure tuning;
- Manage loading increases (monitor volume) in terms of data access;
- Administer access authorizations for users as well as data security issues with the supervisor in accordance with the Information Systems Security Policy (PSSI);
- Manage version migrations and manage configuration more generally;
- Update programs and correct possible bugs (go through patches) and give approval before production launches;
- Recommend saving apparatuses (backup) for operations services to carry out in order to ensure data base integrity, especially archives and data purging;
- Define quality standards and develop control panels to ensure monitoring;
- Ensure supervision tools are monitored and study all incidents that occurred to understand their level of seriousness and origins;
- Develop and execute test programs and procedures, during migrations or following an incident;
- Ensure backups are done correctly (tests in a back up center) and secure movements on data;
- Ensure data recuperation and rehabilitation (disaster recover) following a serious incident.
- Technical Support and Assistance to IT Specialists and Users;
- Ensure support for developers and operational technicians;
- Assist MOA on the technical side in developing tools mastery;
- Make technical support available to users at level 2 and define intervention procedures in order to resolve possible problems;
- Immediately intervene in case of incident limiting data base performance or information access.
- Database Control and Technological Surveillance
- Ensure technological surveillance in order to maintain adequate database performance and specificities in accordance with the Ministry’s business group needs;
- Monitor and control evolutions of existing database versions to improve them;
- Test and validate database management systems as part of migrations or technological evolution;
- Define usage and operating standards for database management systems;
- Ensure document updates on the base structure, and operating and production procedures;
- Present new products or new versions to the Operating or Development Managers.
IV. REQUIRED QUALIFICATIONS AND EXPERIENCES
- Technical Qualifications and Skills: Masters degree (BAC + 5) in one of the following fields: IT and/or telecoms, IT networks and security systems, engineering (IT, telecom, general); Database Administrator Professional Qualification Certification (CQP) is a plus; good knowledge of global information systems, SI architecture and applications already in use in the Ministry is also a plus.
- Work Experience: More than 7 years of professional experience; Database Director; Development and Studies Engineer; Administrator or Network Systems Engineer; Network Administrator.
- Specific Experience: Already has 5 years experience as a System or Network Administrator; participated in ERP type software integration.
- Personal Skills: In terms of general activities, the Database Administrator must showcase his or her versatility, openness, and responsiveness to IT projects management. Ability to work on a multidisciplinary team and under pressure. Persons chosen for this job must be able to support MEF in ministries, agencies and decentralized services across the country. Honed skills in negotiations and preparing for technical meetings.
- IT Skills: Software mastery. Mastery of SQL query language; knowledge of Shell scripts under UNIX, Windows; knowledge of environment (clients, activity sector, sensitive data) and enterprise operations; mastery of security-related risks; certification in Oracle or Microsoft SQL server a plus;
- Language Skills: Mastery of technical English indispensable (documentation in English); Excellent knowledge of French (report writing).
Note: This post is reserved for Haitian professionals only. Women are strongly encouraged to apply.