Data Migration

Spektrum have a wide range of exciting opportunities in several global locations. We are always looking to add great new talent to our team and look forward to hearing from you.

Spektrum supports apex purchasers (NATO UN EU and National Government and Defence) and their Tier 1 supplier ecosystem with a wide range of specialist services. We provide our clients with professional services specialised aerospace and defence sales delivery and operational subject matter expertise. We are looking for personnel to join our team and support key client projects.

Who we are supporting

The NATO Communication and Information Agency (NCIA) is responsible for providing secure and effective communications and information technology (IT) services to NATOs member countries and its partners. The agency was established in 2012 and is headquartered in Brussels Belgium.

The NCIA provides a wide range of services including:

• Cyber Security: The NCIA provides advanced cybersecurity solutions to protect NATOs communication networks and information systems against cyber threats.
• Command and Control Systems: The NCIA develops and maintains the systems used by NATOs military commanders to plan and execute operations.
• Satellite Communications: The NCIA provides satellite communications services to enable secure and reliable communications between NATO forces.
• Electronic Warfare: The NCIA provides electronic warfare services to support NATOs mission to detect deny and defeat threats to its communication networks.
• Information Management: The NCIA manages NATOs information technology infrastructure including its databases applications and servers.

Overall the NCIA plays a critical role in ensuring the security and effectiveness of NATOs communication and information technology capabilities.

The program

Assistance and Advisory Service (AAS)

The NATO Communications and Information Agency (NCI Agency) is NATOs principal C3 capability deliverer and CIS service provider. It provides maintains and defends the NATO enterprise-wide information technology infrastructure to enable Allies to consult together under Article IV and when required stand together in the face of attack under Article V.

To provide these critical services in the modern evolving dynamic environment the NCI Agency needs to build and maintain high performance-engaged workforce. The NCI Agency workforce strategically consists of three major categorises: NATO International Civilians (NIC)s Military (Mil) and Interim Workforce Consultants (IWC)s. The IWCs are a critical part of the overall NCI Agency workforce and make up approximately 15 percent of the total workforce.

Role ID 2026-0039

Role Background

The JISR Centres (JISRC) Vision is to assure information superiority for NATO. Our Mission is to deliver support and protect valued Intelligence Surveillance and Reconnaissance (ISR) capabilities expertise and services to maximize operational effectiveness for NATO.

Part of the JISRC portfolio is the delivery of the Intelligence Functional Services Spiral 2 (INTEL-FS SP2) project to all headquarters of the Allied Command Operations (ACO) and its missions. This includes the migration of the dataset of its predecessor INTEL-FS SP1 into SP2. The migration strategycovering scope sequencing and transformation logichas already been defined. The objective of this engagement is to perform test runs refine scripts complete validated data transfer and ensure post-migration integrity and performance.

NCIA invites qualified vendors to submit quotations for the execution phase of this database migration project. The migration plan and mapping documentation have been completed in- house. The selected vendor will lead the technical execution of the migration activities in collaboration with internal staff under a deliverable-based contract.

Role Duties and Responsibilities

The contractor will be responsible for executing and validating the migration process according to the approved migration plan. Specific tasks include:

• Conducting a dry-run migration to verify end-to-end workflow and uncover potential issues.
• Refining migration scripts and parameters to ensure accuracy efficiency and error handling.
• Performing pre-migration backup and system validation confirming backup completeness and integrity.
• Executing the live migration in coordination with internal teams.
• Conducting post-migration data validation and reporting any discrepancies.
• Leading discrepancy resolution and implementing necessary corrections.
• Conducting performance tuning and optimization of queries and database configurations after migration completion.

The contract will be managed through milestone-based deliverables as follows:

• Deliverable 1 Dry-Run & Script Refinement Report
  • Completion of dry-run migration.
  • Updated scripts and parameters.
  • Documented results and known issues.
• Deliverable 2 Pre-Migration Backup & Validation Certification
  • Validated and documented backups of all relevant databases.
  • Confirmation of readiness for live migration.
• Deliverable 3 Live Migration Completion Report
  • Executed migration with no critical errors.
  • Delivery of migration logs and checkpoint records.
• Deliverable 4 Post-Migration Data Validation Report
  • Data validation results showing record counts field-level comparisons and discrepancy analysis.
  • All identified discrepancies logged and categorized for action.
• Deliverable 5 Discrepancy Resolution & Performance Optimization Summary
  • Verified resolution of discrepancies.
  • Performance tuning adjustments and validation metrics.
  • Final acceptance sign-off from internal project lead.

Essential Skills Experience and Certifications

• Experience executing database migrations for complex or sensitive systems.
• Expert in Postgresql and Microsoft SQL Server
• Knowledgeable / familiar with XSLT
• Comfortable using command line interfaces in Linux
• Deep understanding of data validation reconciliation and performance optimization.
• Proven ability to deliver results in a fixed deliverable-based contract model.
• Proven ability to integrate and work in a multinational team.

Language

• Fluent in Business English.

Working Location

• The Hague Netherlands

Working Policy

• Onsite

Travel

• Some travel to other NATO sites may be required

Security Clearance

• Valid National or NATO Secret personal security clearance

We never know what new opportunities might be just over the horizon. If this opportunity isnt for you please feel free to send us your resume anyway and be the first to know if something suitable for your skills and experience comes up.