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.