IT Operations Assistant (Database Developer) SSA5 - Baghdad, Iraq

.

WFP celebrates and embraces diversity. It is committed to the principle of equal employment opportunity for all its employees and encourages qualified candidates to apply irrespective of race, colour, national origin, ethnic or social background, genetic information, gender, gender identity and/or expression, sexual orientation, religion or belief, HIV status or disability.

ABOUT WFP

The United Nations World Food Programme is the world's largest humanitarian agency fighting hunger worldwide. The mission of WFP is to help the world achieve Zero Hunger in our lifetimes. Every day, WFP works to ensure that no child goes to bed hungry and that the poorest and most vulnerable, particularly women and children, can access the nutritious food they need. WFP corporately has embraced a stronger and more proactive stance on Resilience and Livelihoods, which is now a key pillar of WFP’s “Changing Lives” agenda and will be prominent in the new Strategic Plan, as well as being a top priority for most regions and countries.  In 2023 WFP supported 687,207 people in Iraq. Through providing food for vulnerable people, skills to build futures, and enhanced social protection, WFP is helping the Government of Iraq build people’s food security and resilience. For more information, see wfp.org/countries/iraq and ar.wfp.org/countries/iraq.

ORGANIZATIONAL CONTEXT

Under the supervision of the Business Transformation Officer, the incumbent will be expected to take responsibility for completion of a range of processes and activities requiring interpretation of standard guidelines/practices. The incumbent should be able to recommend a course of action to staff at various levels and may allocate tasks to other staff.

JOB PURPOSE

The IT Operations Assistant will assist as database developer on the following:

• SQL Procedure Development and Maintenance
• Database Structure Maintenance and Creation
• Database System Design
• Scripting for Data Extraction, Movement and Loading
• Documentation
• Performance Monitoring and Tuning
• Full Stack Development including Python backend, Frontend, and Mobile Application Development with proficiency in Odoo Framework.

KEY ACCOUNTABILITIES (not all-inclusive)

1. SQL Procedure Development and Maintenance
   1. Develop, implement, and maintain SQL stored procedures, functions, and triggers.
   2. Collaborate with developers to align SQL procedures with solution logic, providing insights based on previous experience.
   3. Optimize SQL code for enhanced performance and efficiency.
   4. Independently troubleshoot and debug SQL code to promptly resolve issues.
2. Database Structure Maintenance and Creation
   1. Maintain existing database structures in various environments.
   2. Collaborate with the team to ensure database structures align with application and advanced data warehousing requirements.
3. Database System Design
   1. Actively contribute to the design of high-performance, high-availability database systems, incorporating advanced data warehousing components.
   2. Collaborate with system architects to ensure database designs align with overall system architecture, especially emphasizing data warehousing considerations.
   3. Contribute to the development and implementation of database design best practices for data warehousing.
   4. Stay informed about emerging trends and technologies in database system design, particularly in the context of data warehousing
4. Scripting for Data Extraction, Movement, and Loading
   1. Develop and optimize PowerShell scripts for transactional data extraction independently.
   2. Develop scripts to facilitate the loading of transactional data into the database, providing insights on data warehousing requirements.
   3. Collaborate with data analysts to ensure scripts align with advanced data extraction and loading requirements.
5. Documentation
   1. Maintain documentation on development and production configurations, including advanced data warehousing components.
   2. Document logical and physical database designs, emphasizing considerations for both transactional and data warehousing needs.
   3. Capture metadata information for all database objects, with a focus on advanced data warehousing structures.
6. Performance Monitoring and Tuning
   1. Independently monitor database performance, including advanced data warehousing components, and identify areas for improvement.
   2. Implement tuning strategies to optimize database performance, especially for data warehousing workloads.
   3. Collaborate with the operations team to ensure optimal hardware configurations for both transactional and data warehousing needs.
7. Full Stack Development
   1. Develop backend systems using Python, ensuring robustness, scalability, and security.
   2. Design and implement frontend components using modern web technologies such as HTML, CSS, and JavaScript, ensuring a responsive and intuitive user experience.
   3. Develop mobile applications using relevant frameworks and technologies, ensuring cross-platform compatibility and performance optimization.
   4. Proficiency in the Odoo framework is a huge plus, including customization, module development, and integration with backend systems.

WFP LEADERSHIP FRAMEWORK: COMMON STANDARDS OF BEHAVIOUR

Demonstrates the WFP values, principles and standards.

• Values diversity using respectful and inclusive language.
• Stays focused and calm when under pressure.
• Shows humility and a willingness to learn and share knowledge, seeking and acting on feedback, and taking up opportunities to develop.

Drives Results and Delivers on Commitments

• Is accountable for the delivery of results.
• Seeks guidance and support where needed.
• Adapts readily to change adjusting work as needed.

Fosters Inclusive and Collaborative

• Promotes teamwork by sharing ideas and openly raising issues.
• Gives timely and constructive feedback to others.
• Listens attentively to others and shares views.

Applies Strategic Thinking

• Embraces WFP’s vision and how it impacts their role.
• Shows curiosity and implements new ways of doing things when relevant.
• Gathers data and shares knowledge to inform team activities.
• Asks questions to understand the impact of decisions for their objectives.

Builds and Maintains Sustainable Partnerships

• Acts professionally with external partners.
• Works together with partners to deliver common goals.

FUNCTIONAL CAPABILITIES

STANDARD MINIMUM QUALIFICATIONS

Education: Secondary Education with an additional Diploma in computer science, engineering, mathematics, science, or any other relevant qualification is required. Bachelor’s degree in the same areas mentioned above is a strong advantage. 
Experience: At least five (5) years of experience in SQL Programming at the international, national level or in the private sector.
Languages: Fluency in English and Arabic is required. 

DESIRED EXPERIENCES FOR ENTRY INTO THE ROLE

• Experience in Data warehouse projects and requirements gathering is required.
• Experience in shell scripting desired.
• Strong analytical skills needed for gap analysis and source-to-target mapping.
• Experience in understanding the identified gaps and providing solutions, translating them to technical efforts, and estimating the work.
• Experience in conducting code reviews ensuring quality of development and testing procedures and protocol.

TERMS AND CONDITIONS

Position Title: IT Operations Assistant (Database Developer)

Grade: SSA5

Contract: Special Service Agreement

Duty Station: Baghdad, Iraq

Duration of contract: 6 months, with possibility of extension subject to funding availability and satisfactory performance

Salary: Minimum Annual Net Salary is USD 21,441.00

Medical Plan: International valid medical plan for the staff member, spouse, and dependent children

DEADLINE FOR APPLICATIONS

Applications close on 28 May 2024 

.

WFP has a zero-tolerance approach to conduct such as fraud, sexual exploitation and abuse, sexual harassment, abuse of authority and discrimination. All selected candidates will be expected to adhere to WFP’s standards of conduct and will therefore undergo rigorous background verification internally or through third parties. Selected candidates will also be required to provide additional information as part of the verification exercise. Misrepresentation of information provided during the recruitment process may lead to disqualification or termination of employment

WFP will not request payment at any stage of the recruitment process including at the offer stage. Any requests for payment should be refused and reported to local law enforcement authorities for appropriate action.