IT Solutions Associate (Database Developer) - SC6 - Islamabad

Tags: climate change Law finance English language Environment
  • Added Date: Tuesday, 07 January 2025
5 Steps to get a job in the United Nations

DEADLINE FOR APPLICATIONS20 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 and follow us on social media to keep up with our latest news: YouTube, LinkedIn, Instagram, Facebook, Twitter, TikTok.

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

Recommended for you