VN 001-002/2022
National ICT Officer (Database Administration) (2 positions)
Manila (Global) Administrative Centre (MAC)
Philippines
Open to Internal and External Candidates
Job classification
National Officer
Grade
NO-A
Duty station
Manila (Global) Administrative Centre (MAC)
Location
Manila
Type of Appointment
Fixed term, one year with possibility of extension
Closing date
Duration of Assignment
One Year with possibility of extension
Salary
Php 1,189,184.00 per annum net of taxes

Established in 1951, IOM is a Related Organization of the United Nations, and as the leading UN agency in the field of migration, works closely with governmental, intergovernmental and non-governmental partners. IOM is dedicated to promoting humane and orderly migration for the benefit of all. It does so by providing services and advice to governments and migrants.

IOM is committed to a diverse and inclusive work environment. Internal and external candidates are eligible to apply to this vacancy. For the purpose of the vacancy, internal candidates are considered as first-tier candidates.

Context

The position is based in Manila Administrative Centre (MAC), headed by the Director of MAC. Information and Communications Technology (ICT) is one of the divisions with its operations delocalized to MAC.

Under the overall supervision of the Chief, Enterprise Architecture and Technology and the direct supervision of the ICT Officer Database Administration Lead, the successful candidate will be responsible for managing and maintaining optimum operation of all MS SQL production and non-production databases; and design/implementation and maintaining strict security rights to sensitive data as per IOM’s data protection principles.

Core Functions / Responsibilities
  • Support the Database Administration Lead in compilation and analysis of business requirements and in the design, development and implementation of information systems and applications.
  • Coordinate and monitor the deployment of corporate application’s databases upgrades.
  • Carry out SQL Server upgrades (New SQL versions, Service Packs & hotfixes).
  • Configure and manage system and database user IDs and group permissions.
  • Recommend deployment, backup and optimization strategies according to standard industry best practices.
  • Act as a subject matter expert for large database-driven applications.
  • Support data access analysis and design, DBMS optimization, data integrity, recovery & load strategy.
  • Oversee backup and recovery on databases is in place.
  • Design and implement high availability of MS SQL based production systems including the disaster recovery solution implementation.
  • Configure and monitor interfaces with other systems.
  • Configure, and coordinate and oversee maintenance of schema, tables, views, functions, triggers and indexes.
  • Identify opportunities for optimizing business and system effectiveness.
  • Support formal testing and resolve test defects.
  • Efficient at T-SQL and batch scripting.
  • Manage the ticket ownership process and provide tier 3 level support.
  • Provide guidance and training to other staff in the unit.
  • Perform any other related duties as may be assigned
Education
  • Master’s degree in Computer Science or a related field from an accredited academic institution, with four years of relevant professional experience or
  • University degree from an accredited academic institution, with six years relevant professional experience.
Experience
  • 6 years of experience as a Database administrator or similar role.
  • Excellent understanding of MS SQL database systems and architectures.
  • Extensive years of experience of managing disconnected databases.
  • Extensive years of experience in reporting services, data warehousing or data analytics and visualization.
  • Experience in project management.
  • Experience in cloud databases management (Azure, AWS).
  • Strong organizational skills and ability to manage multiple tasks.
  • Ability to work effectively and harmoniously with colleagues from varied cultures and professional backgrounds.
Languages

English and French are the working languages of the UN Secretariat. For this position, fluency in English is required. Knowledge of a second official UN language is desirable.

Values
Inclusion & respect for diversity
  • Shows respect and sensitivity towards gender, culture, ethnicity, religion, sexual orientation, political conviction and other differences.
  • Encourages the inclusion of all team members and stakeholders while demonstrating the ability to work constructively with people with different backgrounds and orientations.
  • Promotes the benefits of diversity; values diverse points of view and demonstrate this in daily work and decision making.
  • Challenges prejudice, biases and intolerance in the workplace.
Integrity & transparency
  • Upholds and promotes the Standards of Conduct and Unified Staff Regulations and Rules.
  • Delivers on commitments; manages the organization’s resources reliably and sustainably.
  • Embraces and encourages transparency, balancing this with the need for discretion and confidentiality as appropriate.
  • Maintains impartiality and takes prompt action in cases of unprofessional or unethical behaviour.
  • Does not abuse one’s position and acts without consideration of personal gain. Is motivated by professional rather than personal concerns.
Professionalism
  • Demonstrates professional competence and mastery of subject matter and willingness to improve knowledge and skills.
  • Seeks to raise professional standards in self and others through daily work and activities.
  • Adapts quickly to change and is decisive and versatile in face of uncertainty.
  • Shows self-control and persistence when faced with difficult problems, and remains calm in stressful situations.
  • Is conscientious and efficient in meeting commitments, observing deadlines and achieving results.
Core Competencies
Accountability
  • Demonstrates individual responsibility for defining and delivering on the Organization’s priorities.
  • Delegates authority to match responsibilities, and holds staff accountable for agreed-upon commitments.
  • Consistently assumes responsibility for Divisional or Departmental actions by explaining successes, failures, and proposing remedial actions.
  • Invests significant time in creating a culture of accountability and responsibility by using experience and advice to guide others.
Communication
  • Clearly and simply communicates the IOM mandate and seeks opportunities to represent the organization externally to promote its mandate.
  • Communicates confidently, commands attention and respect when speaking, and projects credibility.
  • Influences others and negotiates effectively through a persuasive, flexible approach.
  • Keeps staff informed of decisions and directives of senior management and communicates them in a manner that ensures understanding and acceptance.
Managing and sharing knowledge
  • Promotes the development and use of organization-wide knowledge sharing systems that capture all relevant information from sources inside and outside of the Organization.
  • Leads in defining and prioritizing the Organization’s knowledge needs.
  • Establishes and fosters a culture that encourages change, innovation and continuous learning.
  • Encourages and supports others to be innovative and actively generates new perspectives on own and team’s work.
Teamwork
  • Advocates for collaboration across the Organization and creates collaborative systems and integrated processes to achieve Organizational goals.
  • Builds consensus for task purpose and direction with colleagues at all levels.
  • Monitors and evaluates the effectiveness of partnerships and takes action to enhance their effectiveness.
  • Identifies and breaks down barriers to cooperation within teams, and between teams, units, sections, divisions, and organizations.
Delivering results
  • Challenges self and team to deliver high quality results, in line with Organizational goals.
  • Leads and facilitates work planning, alerting those involved of potential obstacles and helping to identify suitable alternative options as needed.
  • Persuades management to undertake new projects and services that benefit internal and external clients; uses performance standards to monitor projects.
  • Tailors organizational targets to meet changing demands in the external environment.
How to apply

Interested candidates are invited to submit their applications online by clicking on the below APPLY button and completing the profile registration.