DBA & Data Migration Specialist

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