Consultant – Oracle PL/SQL Developer with Java Experience, HQ Gaza (Local)

BACKGROUND
UNRWA has signed a Memorandum of Understanding (MoU) with UNICC that aims to enhance
livelihood and human development opportunities to Palestine refugees in Gaza. By this new
collaboration, UNRWA becomes a provider of Information Management, Technology services and
capacity augmentation to UNICC technical team, on a cost recovery basis through IMTD/IT Service
Center (ITSC) in HQ-Gaza.
United Nations International Computing Center (UNICC) is a UN agency that provides IT services to
other UN agencies on a cost recovery basis.
UNRWA Information Management and Technology Department (IMTD) is seeking an Oracle PL/SQL
Developer with Java Experience who will responsible for full life-cycle of medium to large sized
complex projects; strong technical skills; strong ability to understand complex business processes.
Develops solutions based on extensive technical knowledge, skills and experience; influences client
towards innovative/integrated solutions.
The consultant will report administratively to Head Information Technology Service Centre at
Headquarter Gaza and technically to United Nations International Computing Center (UNICC).

DESCRIPTION OF DUTIES AND RESPONSIBILITIES
The Consultant will perform all or part of the duties below in addition to any other duties that might
be assigned.

ANALYSIS AND REQUIREMENTS GATHERING

• Gather complex system requirements by meeting with clients and researching existing technology to understand the business requirements and possible solutions for new applications.

DESIGN AND DEVELOPMENT

• Develop/change data input, files/database structures, data transformation, algorithms, and data output by using appropriate computer language/tools to provide technical solutions for complex application development tasks.
• Document code and associated processes by adhering to development methodologies, adding code comments and appropriate documentation to various knowledge-base system(s) to simplify code maintenance and to improve support.
• Provide thought leadership in designing and developing innovative integrated solutions.
• Provide guidance in application design and development to more junior staff.

TESTING AND DOCUMENTATION

• Test all changes by using the appropriate complex test scenarios to ensure all delivered solutions work as expected and errors are handling in a meaningful way.
• Author and maintain documentation by writing audience-appropriate materials to serve as technical and/or end-user references.

IMPLEMENTATION AND MAINTENANCE

• Implement changes by adhering to the change management policies and procedures for any given project to communicate to all parties the nature, significance, and risk factors of the solution.
• Monitor changes and resolve complex problems by responding as they occur, by reviewing all processing and output of the newly implemented solution, and by proactively ensuring the solution works successfully in order to satisfy the customer requirements and to provide a smooth transition to the new solution.
• Provide support by investigating and resolving issues, including complex issues to ensure prompt, effective service.

MINIMUM QUALIFICATIONS AND EXPERIENCE

• A university degree from an accredited educational institution in Computer Science, Information Technology or related discipline.
• At least 5 years of experience in developing Oracle Database, ETL and procedures design and development.
• Expert knowledge ORACLE DB.
• Expert knowledge ORACLE PL/SQL (develop ETLs, complex procedures and packages).
• Good knowledge of version control tools and process (i.e. SVN, GIT).
• Good knowledge of JAVA and Spring Framework.

COMPETENCIES

• Excellent written and verbal communication skills, interpersonal and collaborative skills.
• High degree of initiative, dependability and ability to work with little supervision.
• High level of personal integrity, as well as the ability to professionally handle confidential matters, and show an appropriate level of judgment and maturity.
• Ability to deliver quality results.
• Excellent time management, organization, and attention to detail.
• Exemplary customer service skills.
• Demonstrable critical thinking and problem solving.
• Ability to provide and implement independently high quality, secure, and scalable solutions.

DESIRABLE QUALIFICATIONS

• Familiarity with Oracle eBusiness Suite (eBS).
• Familiarity with Jira, iReport.
• Good knowledge of Web Technologies, CSS and JavaScript.
• Oracle Business Intelligence.
• Experience participating in Agile projects.

CONDITIONS OF SERVICE

• The duration of the consultancy is 6 to 11 months, extendable according to performance and availability of funds.
• Remuneration for this consultancy will be around 1,600 USD and will depend on the qualifications and experience of the consultant.
• The Consultant will be based in Gaza.

APPLICATION PROCESS
Applicants should submit a cover letter and CV or UN Personal History Form demonstrating clearly the
knowledge and experience required to meet the consultancy requirements via
consultancy@unrwa.org indicating the title of this consultancy “Oracle PL/SQL Developer with Java
Experience” in the subject line of the message. The deadline for the submission of applications is 19
August 2020.

UNRWA is an equal opportunity employer and welcomes applications from both women and men.
UNRWA encourages applications from qualified women. Only those applicants shortlisted for
interview will be contacted. UNRWA is a non-smoking environment.