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.
