• Candidates
    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
    01 May 2024
  • Duration of Assignment
    One year with possibility of extension
  • Salary
    Php 1,322,652.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

Under the overall supervision of the Chief, ICT Enterprise Architecture and Technology and the direct supervision of the ICT Officer (Database Management), 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

  1. Support the Database Administration Lead in compilation and analysis of business requirements and in the design, development and implementation of information systems and applications.
  2. Coordinate and monitor the deployment of corporate application’s databases upgrades
  3. Carry out SQL Server upgrades (New SQL versions, Service Packs & hotfixes)
  4. Configure and manage system and database user IDs and group permissions
  5. Recommend deployment, backup and optimization strategies according to standard industry best practices
  6. Act as a subject matter expert for large database-driven applications
  7. Support data access analysis and design, DBMS optimization, data integrity, recovery & load strategy.
  8. Oversee backup and recovery on databases is in place
  9. Design and implement high availability of MS SQL based production systems including the disaster recovery solution implementation
  10.  Configure and monitor interfaces with other systems
  11. Configure, and coordinate and oversee maintenance of schema, tables, views, functions, triggers and indexes
  12. Identify opportunities for optimizing business and system effectiveness
  13. Support formal testing and resolve test defects.
  14. Efficient at T-SQL and batch scripting.
  15. Manage the ticket ownership process and provide tier 3 level support
  16.  Provide guidance and training to other staff in the unit
  17.  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 (4) years of relevant professional experience or
  • University degree from an accredited academic institution, with six (6) years relevant professional experience.

Accredited Universities are those listed in the UNESCO World Higher Education Database.

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.
  • In depth knowledge of MS-SQL and Azure database management, backup procedures and tuning techniques.
  • In depth knowledge of T-SQL and ETL processes.
  • Good understanding of database replication processes.

Languages

For this position, fluency in English is required. Knowledge of a second official UN language is desirable.

Values

Respects and promotes individual and cultural differences. Encourages diversity and inclusion.

Maintains high ethical standards and acts in a manner consistent with organizational principles/rules and standards of conduct.

Demonstrates ability to work in a composed, competent and committed manner and exercises careful judgment in meeting day-to-day challenges.

Demonstrates willingness to take a stand on issues of importance.

Shows compassion for others, makes people feel safe, respected and fairly treated.

Core Competencies

Takes ownership for achieving the Organization’s priorities and assumes responsibility for own actions and delegated work.

Encourages and contributes to clear and open communication. Explains complex matters in an informative, inspiring and motivational way.

Continuously seeks to learn, share knowledge and innovate.

Develops and promotes effective collaboration within and across units to achieve shared goals and optimize results.

Produces and delivers quality results in a service-oriented and timely manner. Is action oriented and committed to achieving agreed outcomes.

Managerial Competencies

Provides a clear sense of direction, leads by example and demonstrates the ability to carry out the Organization’s vision. Assists others to realize and develop their leadership and professional potential.

Creates an enabling environment where staff can contribute their best and develop their potential.

Promotes shared values and creates an atmosphere of trust and honesty.

Works strategically to realize the Organization’s goals and communicates a clear strategic direction.

Leads with humility and shows openness to acknowledging own shortcomings.

How to apply

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

FEES

IOM does not charge any fees at any stage of its recruitment process (application, interview, processing, training or other fee). IOM does not request any information related to bank accounts.