IT Operations Assistant

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)

SQL Procedure Development and Maintenance

• Develop, implement, and maintain SQL stored procedures, functions, and triggers.
• Collaborate with developers to align SQL procedures with solution logic, providing insights based on previous experience.
• Optimize SQL code for enhanced performance and efficiency.
• Independently troubleshoot and debug SQL code to promptly resolve issues.

Database Structure Maintenance and Creation

• Maintain existing database structures in various environments.
• Collaborate with the team to ensure database structures align with application and advanced data warehousing requirements.

Database System Design

• Actively contribute to the design of high-performance, high-availability database systems, incorporating advanced data warehousing components.
• Collaborate with system architects to ensure database designs align with overall system architecture, especially emphasizing data warehousing considerations.
• Contribute to the development and implementation of database design best practices for data warehousing.
• Stay informed about emerging trends and technologies in database system design, particularly in the context of data warehousing

Scripting for Data Extraction, Movement, and Loading

• Develop and optimize PowerShell scripts for transactional data extraction independently.
• Develop scripts to facilitate the loading of transactional data into the database, providing insights on data warehousing requirements.
• Collaborate with data analysts to ensure scripts align with advanced data extraction and loading requirements.

Documentation

• Maintain documentation on development and production configurations, including advanced data warehousing components.
• Document logical and physical database designs, emphasizing considerations for both transactional and data warehousing needs.
• Capture metadata information for all database objects, with a focus on advanced data warehousing structures.

Performance Monitoring and Tuning

• Independently monitor database performance, including advanced data warehousing components, and identify areas for improvement.
• Implement tuning strategies to optimize database performance, especially for data warehousing workloads.
• Collaborate with the operations team to ensure optimal hardware configurations for both transactional and data warehousing needs.

Full Stack Development

• Develop backend systems using Python, ensuring robustness, scalability, and security.
• Design and implement frontend components using modern web technologies such as HTML, CSS, and JavaScript, ensuring a responsive and intuitive user experience.
• Develop mobile applications using relevant frameworks and technologies, ensuring cross-platform compatibility and performance optimization.
• 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.

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.

Source: https://career5.successfactors.eu//career?career_ns=job_listing&company=C0000168410P&navBarLevel=JOB_SEARCH&rcm_site_locale=en_GB&career_job_req_id=832920