Job Summary
The incumbent of this post will effectively manage to provide reliable and secure ICT services in support of all OPCW programmes and activities.
Full lifecycle (Sourcing, Planning, design, development, test, implementation, administration, maintenance and support, decommissioning) of Information and Communication Technologies systems and services, including but not limited to: Local and Wide Area Networks, Unified Communications, Internet, Intranet, World Wide Web, Data Centre services, Business Systems, Infrastructure Systems, Mobility (remote access), and underpinning services, systems and contracts to deliver such services to the OPCW.
Main Responsibilities
Under the supervision of the Head, IS Operations, Infrastrucure and Support, the incumbent performs the following duties:
• Full lifecycle (provisioning, design, installation, administration, maintenance, troubleshooting and performance optimisation) of all SQL servers across the organisation, including SQL servers dedicated to specialized applications. Development or acquisition and use of the tools necessary to perform and automate these operations.
• Set up and maintain database environments for all stages of the software development lifecycle.
• Architect and manage internal and external data connections for analytics platforms.
• Support ICT projects and initiatives as domain expert in the area of databases, data conversion, database performance, and data integration with managed systems.
• Support ICT solutions that make use of SQL databases, particularly ECM, administrative, and Business Intelligence systems. Contribute to the lifecycle of such systems as the domain expert in the area of databases, covering security, connectivity, auditing, platform, middleware, etc.
• Develop procedures for maintenance, disaster recovery, security, backups, restores, rebuild and reorganize indexes. Coach and empower colleagues to share daily tasks, aiming an adequate level of support, which is not excessively dependent on one person.
• Performance tuning and optimization of database schema, indexes, stored procedures etc. Proactively monitor capacity and performance of all SQL server databases and other databases, automating such monitoring when practical.
• Manage ICT projects as required.
• Act as technical lead of ICT projects where the key components are databases, data integration, data migration, middleware, and other affiliate technologies / solutions.
• Manage the successful and smooth transition between pre-production and production phases of new solutions.
• Act as technical lead in the containment and resolution of critical incidents as required.
Education
Essential: Advanced university degree in Computer Sciences, Information Technology, Information Management, Engineering, Mathematics or a field related to Information Technology; a first level university degree in combination with qualifying experience (minimum 7 years) may be accepted in lieu of the advanced university degree. An equivalent or specialised training in combination with qualifying experience (minimum 11 years) may be accepted in lieu of a university degree.
Practical knowledge of developing, testing, deploying, tuning, securing, auditing, and maintaining relational databases based on SQL technologies, supporting solutions developed in-house, ERP, ECM, and specialist applications.
Knowledge of protocols, security, capacity management concepts and performance tuning.
Knowledge of Microsoft-Based environments, including Windows Networking and IIS
Desirable: Microsoft Certification(s) in the area of data management, windows server, Microsoft Azure, and Business Intelligence are highly desirable.
Knowledge and Experience
Essential:
• At least five years of related experience in the IT field with an emphasis on database design, administration and optimization based on Microsoft SQL, middleware technologies and other platform software based on the Microsoft portfolio of technologies supporting specialist applications, web portals, ECM, ERP, business intelligence.
• Experience with data modelling, stored procedures, index tuning.
• Experience creating and supporting scripts aiming at automation and performance optimization.
• Experience with Disaster Recovery Plans, in particular in the area of data recovery.
• Experience in leading IT Projects and/or coordinating the work of consultants.
• Experience in designing corporate database architecture for organisations with 500+ users.
• Experience in writing technical documentation, support manuals aimed at 1st and 2nd level of support.
• Experience with reporting, query tools and practices of this specific domain.
• Experience with transforming data via standardization, cleaning, data repair, matching, and data migration.
• Experience with managing data from multiple sources including internal, external, and data hosted with 3rd parties and data integration.
Desirable:
• Experience working with highly confidential information systems.
• Knowledge and experience of windows network administration and windows servers.
• Previous work experience in UN and/or other international organisations is desirable.
• Experience managing Windows Server 2008/2012/2016/2019/2022 environments.
• Experience managing Microsoft Group Policy.
• Experience with Web server administration using Microsoft IIS.
• Experience in system maintenance, networking, and security services, load monitoring, and backup.
• Experience in server hardware and software, virtualization, storage area networks.
• Experience in various application support, configuration and maintenance.
• Experience in troubleshooting network clients and servers.
• Experience in High Availability environments.
• Experience as a system analyst/programmer.
• Experience with the ERP cloud based solutions.
• Experience with Microsoft Azure architecture and administration.
Skills and Competencies
To succeed in this role you will need the following skills and competencies:
• Ability to quickly learn and deliver results on a broad array of products and technologies (new and legacy);
• Ability to hand over operational procedures and coach/empower junior personnel and peers.
• Ability to analyse problems and react quickly in problematic situations with minimum supervision.
• Excellent planning and organising skills.
• Excellent communication skills, both oral and written.
Language Requirements:
Fluency in English is essential and a good working knowledge of one of the other official languages (Arabic, Chinese, French, Russian, and Spanish) is desirable.
