Database Officer (Migration Information and Data Analysis System (MIDAS))

Position Title: Database Officer (Migration Information and Data Analysis System (MIDAS))

Duty Station: Geneva, Switzerland

Classification: Professional Staff, Grade P2

Type of Appointment: Fixed term, one year with possibility of extension

Estimated Start Date: As soon as possible

Closing Date: 19 July 2023

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. Read more about diversity and inclusion at IOM at www.iom.int/diversity.

Applications are welcome from first- and second-tier candidates, particularly qualified female candidates as well as applications from the non-represented member countries of IOM. For all IOM vacancies, applications from qualified and eligible first-tier candidates are considered before those of qualified and eligible second-tier candidates in the selection process.

For the purpose of this vacancy, the following are considered first-tier candidates:

1. Internal candidates
2. Candidates from the following non-represented member states:

Antigua and Barbuda; Barbados; Botswana; Cabo Verde; Comoros; Congo (the); Cook Islands; Dominica; Fiji; Grenada; Guinea-Bissau; Holy See; Iceland; Kiribati; Lao People’s Democratic Republic (the); Madagascar; Marshall Islands; Micronesia (Federated States of); Namibia; Nauru; Palau; Saint Kitts and Nevis; Saint Lucia; Seychelles; Solomon Islands; Suriname; The Bahamas; Timor-Leste; Tonga; Tuvalu; Uzbekistan; Vanuatu

Second tier candidates include:

All external candidates, except candidates from non-represented member states.

Context:

The Border & Identity Solutions (BIS) Unit, within the Immigration and Border Governance (IBG) Division at IOM-HQ level manages the development and implementation of MIDAS, the

IOM-developed Border Management Information System (BMIS) worldwide, in order to assist IOM’s Member states to meet the current complex migration and border management challenges, contributing to orderly and regular management of borders and regulate migration.

MIDAS is currently installed in 28 countries (with potential 10 more countries in the pipeline), and it allows States to collect, process, store and analyse traveller information collected at the border and share them in real time across the entire border crossing points network, including Immigrations’ Headquarters. MIDAS enables migration authorities to easily monitor travellers entering and exiting the national territory by land, air, and sea border crossing points. It also provides a sound statistical basis of migration and mobility data, to ultimately support evidence-based policies in the field of cross border mobility, migration, trade, and health, as well as inform related regional priority-setting.

To eliminate any risks of duplications, as well as mainstreaming the border control processes at Border Control Post and HQ levels, MIDAS has been developed to be interoperable with other BMISs, including the Personal Identification Secure Comparison Evaluation System (PISCES), as well as with international and/or national databases such as INTERPOL’s alert lists. Additionally, IOM and United Nations Office of Counter-Terrorism (UNOCT) have signed an Agreement concerning the United Nations Counter Terrorism Travel Programme (CTTP), which includes the interoperability between MIDAS and goTravel.

Upon request from countries using both MIDAS and other systems such as PISCES, INTERPOL’s i-24/7 and/or goTravel, MIDAS is capable of exchanging traveller data to allow for data consolidation or querying to enhance border management and security.

Considering the expansion of MIDAS worldwide, and the need to further enhance beneficiary countries’ border management capacities, IOM is recruiting a database expert based in IOM’s Headquarters in Geneva to support the interoperability between MIDAS and the above-mentioned systems.

The Database Officer (MIDAS) will work under the overall supervision of the Senior Border and Identity Solutions Specialist and direct supervision of the Identity and Border Management Officer and based in Geneva.

Core Functions / Responsibilities:

1. Contribute to the development of relevant solutions to facilitate the MIDAS-PISCESinteroperability for requesting Member States, including relevant testing and participation in coordination meetings with the Counter Terrorism Bureau of the United States Department of State.
2. Contribute to the development of relevant solutions to facilitate the MIDAS-goTravelinteroperability for requesting Member States, including testing and participation in coordination meetings with UNOCT.
3. Contribute to the successful interoperability and testing of MIDAS with Advance PassengerInformation System (APIS), Fixed INTERPOL Network Database (FIND), Mobile INTERPOL Network Database (MIND), as well as other databases as requested.
4. Analyse existing MIDAS built-in reports and develop new views and stored procedures to enhance MIDAS data visualization and reporting tools.
5. Develop and implement MIDAS archiving system, including the development of an archiving strategy to optimize servers’ hard drive space.
6. Develop MIDAS Data Exchange Services “Old files” cleaning procedures to optimize MIDAS servers’ hard drive space management and ensure their implementation in countries using MIDAS.
7. Review existing scripts and tables’ structures and provide optimized version to enhance insert and update queries.
8. Prepare, deliver and evaluate MIDAS Data Exchange Services trainings to requesting country Offices and Governments (including hardship locations) as required, using the MIDAS HQ training packages and guidelines.
9. Provide remote and/or on-site support to government counterparts and Country Offices’ MIDAS ICT focal points during MIDAS roll-out at targeted BCPs and Immigration’s Headquarters, including (but not limited to) relevant data management, data back-up, database upgrades and monitoring.
10. Provide remote and onsite technical support and capacity building to requesting CountryOffices and Governments (including hardship locations) in countries in which MIDAS is or will be installed, to facilitate its sustainability, including support concerning relevant interoperability with PISCES, INTERPOL’s databases, APIS (including goTravel), national databases, etc.
11. Provide remote and/or on-site MIDAS troubleshooting support while ensuring knowledge transfer to government counterparts and Country Offices’ MIDAS ICT focal points through regular mentoring sessions.
12. Support MIDAS software development on specific modules as assigned by the supervisor.
13. Keep an updated record (Note for File) on the assistance requested by and provided to country Offices and government counterparts.
14. Perform such other duties as may be assigned.

Required Qualifications and Experience:

Education

• Master’s degree in Information Systems, Computer Science, Mathematics, Business Administration, or a related field from an accredited academic institution with two years of relevant professional experience; or,
• University degree in the above fields with four years of relevant professional experience.

Experience

• Experience in relational database management and administration, especially in Microsoft SQL Server 2014 and higher, is compulsory;
• Experience working with border management information systems will be an advantage;
• Experience in the implementation and administration of Microsoft Windows Server OS2012/2016 and higher;
• Experience in object-oriented programming on .Net framework using Visual Studio IDE and C#;
• Experience in capacity-building initiatives and training delivery on software’s use and/or installation, including briefs and presentations for senior management.

Skills

• Close familiarity with Microsoft SQL Server and similar IT system products;
• Close familiarity with border management and migration-related subjects;
• Solid technical documentation writing skills for system analysis and design, including drafting user manuals;
• Capacity to anticipate and prepare responses to changing IT needs.

Languages

IOM’s official languages are English, French, and Spanish.

For this position, fluency in English is required (oral and written). Working knowledge of Spanish or French is an advantage.

Proficiency of language(s) required will be specifically evaluated during the selection process, which may include written and/or oral assessments.

Notes

Accredited Universities are the ones listed in the UNESCO World Higher Education Database (https://whed.net/home.php).

Required Competencies:

Values – all IOM staff members must abide by and demonstrate these five 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 – behavioural indicators level 2

• 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.
• Managing and sharing knowledge: Continuously seeks to learn, share knowledge and innovate.
• 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.

IOM’s competency framework can be found at this link.

https://www.iom.int/sites/default/files/about-iom/iom_revised_competency_framework_external.pdf

Competencies will be assessed during a competency-based interview.

Other:

Internationally recruited professional staff are required to be mobile.

Any offer made to the candidate in relation to this vacancy notice is subject to funding confirmation.

This selection process may be used to staff similar positions in various duty stations. Recommended candidates endorsed by the Appointments and Postings Board will remain eligible to be appointed in a similar position for a period of 24 months.

The list of NMS countries above includes all IOM Member States which are non-represented in the Professional Category of staff members.

Appointment will be subject to certification that the candidate is medically fit for appointment, accreditation, any residency or visa requirements, and security clearances. Subject to certain exemptions, vaccination against COVID-19 will in principle be required for individuals hired on or after 15 November 2021. This will be verified as part of the medical clearance process.

Vacancies close at 23:59 local time Geneva, Switzerland on the respective closing date. No late applications will be accepted.

How to apply

To apply, interested applicants are invited to submit their applications HERE via the IOM e-Recruitment system by 19 July 2023.

IOM only accepts duly completed applications submitted through the IOM e-Recruitment system. The online tool also allows candidates to track the status of their application.

Only shortlisted candidates will be contacted.

For further information please refer to: www.iom.int/recruitment

Posting period:

From 06.07.2023 to 19.07.2023

No Fees:

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

Requisition: VN 2023 275 Database Officer (Migration Information and Data Analysis System (MIDAS))

(P2) Geneva, Switzerland (58236070) Released

Posting: Posting NC58236071 (58236071) Released