Job description: Database, Data Migration & Cybersecurity Specialist
Scope of Work
The consultant will lead data migration, database administration, cybersecurity and disaster recovery activities required for production deployment of the MIS.
Data inventory and migration baseline
- Identify and inventory relevant existing MIS databases, spreadsheets, registers, electronic files and other legacy data sources relating to the five SWD social protection programs;
- map source data to the target MIS database structure;
- establish baseline source record counts and expected migration totals;
- identify duplicate, incomplete, inconsistent and invalid records;
- agree data-cleansing, migration, exception and reconciliation protocols with SWD; and
- prepare a detailed data migration and cutover plan.

Data cleansing, transformation and migration
- Develop and/or refine ETL routines for extraction, transformation and loading;
- standardize and validate names, dates, household relationships, program identifiers, identity information and other key fields;




- implement duplicate-detection and exception-management procedures;
- load validated records initially into staging tables;
- undertake repeated migration rehearsals prior to production cutover;
- maintain auditability between original source records and migrated records;
- document and resolve migration exceptions with SWD; and
- execute the final production data migration following approval of the migration-readiness gate.

Data reconciliation and quality assurance
- Compare source and target record counts for each program and major entity;
- reconcile household, individual, beneficiary, entitlement and payment-related records;
- establish data-quality indicators and exception reports;
- conduct targeted sampling and validation with SWD program staff;
- ensure that unresolved discrepancies are documented and formally addressed; and
- prepare formal data migration and reconciliation sign-off documentation.

Database architec

📌 Database, Data Migration (Ghaziabad)
🏢 Datamatics
📍 Ghaziabad