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
- 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 (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
Inclusion and respect for diversity
Respects and promotes individual and cultural differences. Encourages diversity and inclusion.
Integrity and transparency
Maintains high ethical standards and acts in a manner consistent with organizational principles/rules and standards of conduct.
Professionalism
Demonstrates ability to work in a composed, competent and committed manner and exercises careful judgment in meeting day-to-day challenges.
Courage
Demonstrates willingness to take a stand on issues of importance.
Empathy
Shows compassion for others, makes people feel safe, respected and fairly treated.
Core Competencies
Accountability
Takes ownership for achieving the Organization’s priorities and assumes responsibility for own actions and delegated work.
Communication
Encourages and contributes to clear and open communication. Explains complex matters in an informative, inspiring and motivational way.
Managing and sharing knowledge
Continuously seeks to learn, share knowledge and innovate.
Teamwork
Develops and promotes effective collaboration within and across units to achieve shared goals and optimize results.
Delivering results
Produces and delivers quality results in a service-oriented and timely manner. Is action oriented and committed to achieving agreed outcomes.
Managerial Competencies
Leadership
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.
Empowering others
Creates an enabling environment where staff can contribute their best and develop their potential.
Building Trust
Promotes shared values and creates an atmosphere of trust and honesty.
Strategic Thinking and Vision
Works strategically to realize the Organization’s goals and communicates a clear strategic direction.
Humility
Leads with humility and shows openness to acknowledging own shortcomings.