Data Migration

The JISR Centre's (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 strategy-covering scope, sequencing, and transformation logic-has 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.

Do you have experience in XSLT?, * 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., * Valid National or NATO Secret personal security clearance

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., The NATO Communication and Information Agency (NCIA) is responsible for providing secure and effective communications and information technology (IT) services to NATO's 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 NATO's communication networks and information systems against cyber threats. * Command and Control Systems: The NCIA develops and maintains the systems used by NATO's 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 NATO's mission to detect, deny, and defeat threats to its communication networks. * Information Management: The NCIA manages NATO's information technology infrastructure, including its databases, applications, and servers. Overall, the NCIA plays a critical role in ensuring the security and effectiveness of NATO's communication and information technology capabilities. The program Assistance and Advisory Service (AAS) The NATO Communications and Information Agency (NCI Agency) is NATO's 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 categorise's: 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.