World Food Programme
tendersglobal.net
Job Description
<!–
Description
–>
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.
<!—
Recommend your friend
<!–
–>
To help us track our recruitment effort, please specify on the application form/indicate in your cover letter where (tendersglobal.net) you saw this job posting.
Related Jobs/Tenders
-
TRAINEE (M/W/D) BANKING / ZAHLUNGSVERKEHR
ReplyHamburgHamburg -
Field Service Engineer (Domestic Appliances)
Ernest Gordon RecruitmentAbertillery, Blaenau GwentAbertillery, Blaenau Gwent- Temporary
-
IOM : National Consultant -Social behaviour change communication strategy review and implementation and capacity building of IPs and community stakeholders
World Health OrganizationNairobi, KenyaNairobi, Kenya- Contract
-
Chef(fe) de Projet – Projet UNHCR -RCA
INTERSOSCentral African RepublicCentral African Republic- Contract