Location - New Delhi Experience - 8Years

Vacancies - 1

Job Summary

We are seeking an experienced DBA &

- Data Migration Specialist to manage database administration, legacy data migration, data validation, and database performance optimization for Government IT and e-Governance projects. The candidate will be responsible for developing migration strategies, reviewing migration scripts, ensuring data accuracy and integrity, validating dashboards and reports, and maintaining reliable, secure, and high-performing database environments.

Key Responsibilities

1.

Database

Administration &

- Performance Management

- Administer, configure, monitor, and maintain relational databases such as PostgreSQL, MySQL, Oracle, or Microsoft SQL Server.

- Review database architecture, schema design, indexing strategies, queries, and execution plans.

- Monitor database performance, availability, storage utilization, and resource consumption.

- Identify and resolve performance bottlenecks, query inefficiencies, and database-related issues.

- Manage database backup, recovery, replication, access controls, and disaster recovery procedures.

- Ensure database security, data integrity, availability, and compliance with applicable policies.

2.

Legacy Data Migration

Strategy &

- Mapping

- Develop and review legacy data migration strategies for transferring data from existing systems to new applications and databases.

- Assess source and target databases, legacy data structures, data formats, dependencies, and migration risks.

- Prepare and validate source-to-target data mapping documents, transformation rules, and migration specifications.

- Identify duplicate, incomplete, inconsistent, obsolete, or invalid records before migration.

- Define data cleansing, transformation, normalization, and validation procedures.

- Plan migration activities, timelines, rollback mechanisms, and contingency arrangements to minimize operational disruption.

- Coordinate with application teams, business analysts, and project stakeholders to ensure migration requirements are met.

3.

Migration Script

Assessment &

- Execution Oversight

- Review SQL scripts, ETL workflows, stored procedures, and data transformation logic used for migration.

- Assess migration scripts for accuracy, completeness, performance, security, and data integrity.

- Validate data extraction, transformation, loading, and error-handling mechanisms.

- Oversee migration testing, trial runs,



production migration activities, and post-migration verification.

- Identify migration risks, resolve technical discrepancies, and recommend corrective actions.

- Maintain migration logs, exception reports, execution records, and rollback documentation.

4. Data Reconciliation &

- Accuracy Validation

- Perform source-to-target data reconciliation to verify that migrated data is complete, consistent, and accurate.

- Validate record counts, field-level values, relationships, business rules, and referential integrity.

- Identify and investigate missing records, duplicate entries, transformation errors, and data mismatches.

- Coordinate with business and technical teams to resolve discrepancies and obtain validation confirmation.

- Conduct post-migration quality checks and document reconciliation results.

- Ensure appropriate approval and acceptance of migrated datasets before production sign-off.

5. Dashboard &

- Reporting Data Accuracy

- Validate the accuracy and consistency of data displayed in dashboards, MIS reports, analytical reports, and management information systems.

- Verify report calculations, aggregations, filters, totals, and underlying database queries against source records.

- Ensure dashboard indicators and reports reflect approved business rules and validated datasets.

- Investigate discrepancies between database records, application screens, dashboards, and generated reports.

- Coordinate with reporting, business intelligence, and application teams to resolve data quality issues.

- Prepare data validation reports and maintain supporting evidence for review and approval.

6. Data Governance, Security &

- Documentation

- Implement data quality controls, database access management, and appropriate audit mechanisms.

- Ensure compliance with applicable data privacy, retention, archival, and information security requirements.

- Maintain database documentation, data dictionaries, schema details, migration plans, and validation records.

- Support database audits, technical reviews, testing activities, and operational handover.





- Coordinate with project managers, developers, QA teams, infrastructure teams, and government stakeholders.

Key Deliverables

- Legacy data migration strategy and source-to-target mapping documents.

- Database assessment and performance review reports.

- Migration script assessment and validation reports.

- Data cleansing, transformation, and migration execution documentation.

- Source-to-target reconciliation and data accuracy validation reports.

- Dashboard and MIS report data validation reports.

- Database backup, recovery, security, and operational documentation.

- A signed Migration Review Note for each engagement, documenting the migration approach, script assessment, reconciliation results, identified discrepancies, corrective actions, data quality status, and review approval.

Required Qualifications &

- Experience

- Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related discipline.

- Relevant experience in database administration, data migration, data validation, and database performance management.

- Strong knowledge of SQL and relational database management systems such as PostgreSQL, Oracle, MySQL, or Microsoft SQL Server.

- Experience in legacy database assessment, source-to-target mapping, data transformation, and migration planning.

- Practical knowledge of migration script review, ETL processes, data reconciliation, and data integrity validation.

- Experience in database performance tuning, query optimization, indexing, backup, and recovery.

- Ability to validate MIS reports, dashboards, and application data against source databases.

- Robust analytical, troubleshooting, documentation, and stakeholder coordination skills.

Preferred Skills

- Experience in Government IT, public sector, or e-Governance projects involving legacy system modernization.

- Familiarity with ETL tools, data integration platforms, and database migration utilities.

- Knowledge of database monitoring, high availability, replication, and disaster recovery.

- Experience with large-volume data migration and post-migration reconciliation.

- Understanding of data governance, audit trails, data privacy, and information security requirements.

- Familiarity with BI and reporting platforms such as Power BI or equivalent tools.

Qualification - B.E./B.Tech./MCA/M.Tech. or equivalent in Engineering, Computer Science, IT, Management or a related discipline.

📌 DBA & Data Migration Specialist (Delhi)
🏢 Luminous Infoways
📍 Delhi