RFQ C004721 Geospatial System Operator (The Hague)

Duties:

• Design conceptual, logical, and physical spatial data models;
• Implement enterprise geodatabases using Microsoft SQL Server;
• Optimize complex SQL queries and spatial joins;
• Create stored procedures, triggers, and database functions;
• Deploy and manage geodatabases for ArcGIS Enterprise;
• Monitor database health and resource utilization;
• Implement performance monitoring tools;
• Optimize Storage straegies for large datasets;
• Automate database maintenance tasks (vacuum, indexing, statistics updates);
• Develop scripts for backup validation and restore testing;
• Translate business requirements into spatial database architecture;
• Collaborate with GIS analysts, developers, and IT teams;
• Provide technical documentation and system diagrams;
• Lead troubleshooting and root cause analysis;
• Contribute to architectural decision-making;
• Integrate in current Image provisioning Team;
• Operate established multi-source imagery provisioning service including trouble shooting;
• Manage all relevant imagery and other data;
• Suggest improvements, discuss with supervisor and implement as agreed;
• Maintain provisioning environment;
• Maintain user-facing GIS web-based tools, e.g. dashboards, portals, etc.
• Support multidisciplinary teams of users and technical and operational stakeholders;
• Participate in technical and operational meetings, offering advice and seeking solutions;
• Support NATO in the development of recommendations for updates to current services;
• Provide meaningful input to envisioning IT solutions that fit best NATO requirements.

Requirements:

• Valid security clearance at minimum NATO S*CR*T level;
• Education – BSc or equivalent in a geospatial or IT domain;
• Minimum 3 years' experience Microsoft SQL Server & Database Development, including:
• Advanced SQL (complex joins, CTEs, window functions, indexing strategies);
• Stored procedures, functions, triggers;
• Query optimization and performance tuning;
• Data modeling (conceptual, logical, physical);
• Normalization and denormalization strategies;
• ETL process design;
• Minimum of 3 years' experience and deep knowledge in all IT aspects of the Esri enterprises, including:
• ArcGIS Pro
• ArcGIS Portal and components
• ArcGIS Server, advanced publishing mechanisms and best practices
• Minimum of 3 years' experience and deep knowledge in configuration and maintenance of Esri components (Experience Builder, Dashboards, Story Maps, etc.)
• Excellent knowledge of Commercial Satellite Imagery, formats and metadata;
• Excellent knowledge of vector data manipulation and data management in a complex multi- network/multi-user environment;
• Experience in automating GIS workflows;
• Solid experience in working in a Microsoft environment with shared data access;
• Ability to independently plan and execute assigned project tasks under guidance, taking into account policies, programmer goals, priorities, funding and other planning constraints;
• Ability to receive and execute tasking in accordance with direction from NCI Agency staff;
• English Fluent

Desirables:

• Knowledge Java/Python scripting skills;
• Knowledge of NATO responsibilities and organization;
• Knowledge of NATO Functional Area Services;
• Knowledge of NATO Communication and Information Systems Infrastructure;
• Prior experience of working in an international environment comprising both military and civilian elements;
• Knowledge of Microsoft Word/Excel, PowerPoint, SharePoint;
• NATO and/or military experience;
• Highly motivated, good communication skills, team player.