3610 Geospatial System Operator

• Geospatial Engineering
• Operations and Maintenance
• ArcGIS

Required Security Clearance: NATO SECRET

DUTIES AND ROLE

• 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 strategies 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.

Do you have experience in SharePoint?, Do you have a Bachelor's degree?, * The candidate must have a currently active NATO SECRET security clearance.

• 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

Desirable skills/experience:

• 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.