IT Solutions Associate (Database Developer) - SC6 - Islamabad

DEADLINE FOR APPLICATIONS 20 January 2025-23:59-GMT+05:00 Pakistan Standard Time (Karachi) 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 World Food Programme is the world’s largest humanitarian organization saving lives in emergencies and using food assistance to build a pathway to peace, stability and prosperity, for people recovering from conflict, disasters and the impact of climate change
At WFP, people are at the heart of everything we do and the vision of the future WFP workforce is one of diverse, committed, skilled, and high performing teams, selected on merit, operating in a healthy and inclusive work environment, living WFP's values (Integrity, Collaboration, Commitment, Humanity, and Inclusion) and working with partners to save and change the lives of those WFP serves.

To learn more about WFP, visit our website: https://www.wfp.org WHY JOIN WFP?

• WFP is a 2020 Nobel Peace Prize Laureate
• WFP offers a highly inclusive, diverse, and multicultural working environment
• WFP invests in the personal & professional development of its employees through a range of training, accreditation, coaching, mentorship, and other programs as well as through internal mobility opportunities
• A career path in WFP provides an exciting opportunity to work across the various country, regional and global offices around the world, and with passionate colleagues who work tirelessly to ensure that effective humanitarian assistance reaches millions of people across the globe
• We offer an attractive compensation package (please refer to the Terms and Conditions section of this vacancy announcement)

About Job Job Title: IT Solutions Associate (Database Developer) Grade: SC6 Type of contract: Service Contract Duration: 12 Months Duty Station: Islamabad, Pakistan Date of Publication: 7th January, 2025 Deadline of Application: 20th January, 2025 This Vacancy Announcement is for Pakistan Nationals Only Note: This vacancy announcement will also be used to build a roster of prequalified applicants for future opportunities within same job profile at the current or lower level in Pakistan TERMS & CONDITIONS
WFP offers a competitive benefits package including salary, pension, leave plus a medical insurance JOB PURPOSE The Software/Database Developer is responsible for designing, developing, and integrating database solutions and software applications to support BNP's (Benazir Nashonuma Programme) daily operations. This includes facilitating data exchange with internal and external stakeholders and enhancing the decision-making process.
The professional is seconded to BISP, working with Project Management Unit (PMU), and reports operationally to the IT Solution Developer Team Lead and technically to the Nutrition Unit's Information Management Officer at WFP KEY RESPONSIBILITIES (not all-inclusive, nor exhaustive): 1. Design and implement complex database models that align with business requirements.
2. Create and manage tables, indexes, views, and other schema objects in Exadata.
3. Analyze and optimize SQL queries to ensure high performance, particularly in a distributed Exadata environment.
4. Develop and optimize PL/SQL code, stored procedures, triggers, and functions.
5. Implement and manage partitioning strategies to enhance performance on large datasets.
6. Develop scripts for data migration and ETL processes using DBs/tools such as MySQL, Oracle, or Oracle GoldenGate.
7. Design and maintain data replication and synchronization across systems, ensuring minimal downtime.
8. Create professional dashboards and provide support for optimizing dashboard infrastructure performance.
9. Translate conceptual data models into physical database structures with expertise in data modeling.
10.Provide technical support to team members and collaborate to achieve software development and implementation goals.
11.Write complex database queries in a big data environment with hands-on expertise.
12.Offer training and mentoring to team members on effective data utilization and respond to related queries.
13.Design, develop, and implement system and software technical specifications following organizational infrastructure and guidelines.
14.Design databases with integrated security features to safeguard data, pre-test databases for analysis, and produce actionable reports.
15.Maintain databases as required and generate reports for various analyses and presentations.
16.Provide technical assistance to team members, fostering collaboration to complete development and implementation tasks.
17.Support and provide evidence for audit-related activities.
18.Assist in payment-related matters and integration with financial institutions.
19.Support the PMU team and WFP Nutrition team in report generation and capacity building.
20.Create professional documentation for existing and new systems 21.Perform any other tasks as assigned by the reporting manager or as required in a team environment QUALIFICATIONS & EXPERIENCE Education: First level university degree in Computer Sciences, Computer Engineering, Information Technology or a related field. Preference will be given to graduates from HEC approved top ranking local and foreign recognized universities Experience: A minimum of 6 years of experience in software/database design or Systems Engineer on enterprise level projects in organizations preferably CMMI certified and roll out for health development projects

• Proven experience in the structural design of a database according to various system requirements
• The candidate must have prior experience in taking over & enhancement of legacy code intensive applications
• The candidate should have strong background in Systems design and implementation (UML modeling, documentation) including knowledge and experience with Systems life cycle development methodologies

Knowledge & Skills:

• Proven database programming experience with MySQL and Oracle with PL SQL, SQL/ Optimization, Oracle / SQL Server (large scale Systems)
• Knowledge and experience using the ORACLE database platform is desirable
• Proficiency in dashboard development
• Analytical and Documentation skills, presentation of report
• Should be able to work on Web, Windows Services, Web APIs, Encryption, application development in .Net Framework and must be proficient in PHP and its framework
• Experience with developing native Android applications will be preferred. Mobile& GIS devexperience will be a plus
• Familarity with encryption and information security best practices

Language: General Service (Field): Fluency in both oral and written communication in English and Urdu HOW TO APPLY To be considered, interested candidates are invited to apply via (https://www.wfp.org/careers/job-openings). Only short-listed candidates will be contacted 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 WFP LEADERSHIP FRAMEWORK
WFP Leadership Framework guides to the common standards of behavior that guide HOW we work together to accomplish our mission
REASONABLE ACCOMMODATION
WFP is dedicated to fostering diversity, equity, and inclusion. Our recruitment process is inclusively crafted to welcome candidates of all backgrounds, celebrating diversity and ensuring a respectful environment for all. We aim for an accessible and fair recruitment journey. Should you need any reasonable accommodations or have accessibility concerns, please reach out to us confidentially at [email protected]. Our DEI team is here to ensure your full participation in our recruitment process NO FEE DISCLAIMER
The United Nations does not charge any application, processing, training, interviewing, testing or other fee in connection with the application or recruitment process. Should you receive a solicitation for the payment of a fee, please disregard it. Furthermore, please note that emblems, logos, names and addresses are easily copied and reproduced. Therefore, you are advised to apply particular care when submitting personal information on the web
REMINDERS BEFORE YOU SUBMIT YOUR APPLICATION

• We strongly recommend that your profile is accurate, complete, and includes your employment records, academic qualifications, language skills and UN Grade (if applicable)
• Once your profile is completed, please apply, and submit your application
• Please make sure you upload your professional CV in the English language
• Kindly note the only documents you will need to submit at this time are your CV and Cover Letter
• Additional documents such as passport, recommendation letters, academic certificates, etc. may potentially be requested at a future time
• Please contact us at [email protected] in case you face any challenges with submitting your application
• Only shortlisted candidates will be notified

All employment decisions are made on the basis of organizational needs, job requirements, merit, and individual qualifications. WFP is committed to providing an inclusive work environment free of sexual exploitation and abuse, all forms of discrimination, any kind of harassment, sexual harassment, and abuse of authority. Therefore, all selected candidates will undergo rigorous reference and background checks.
No appointment under any kind of contract will be offered to members of the UN Advisory Committee on Administrative and Budgetary Questions (ACABQ), International Civil Service Commission (ICSC), FAO Finance Committee, WFP External Auditor, WFP Audit Committee, Joint Inspection Unit (JIU) and other similar bodies within the United Nations system with oversight responsibilities over WFP, both during their service and within three years of ceasing that service.