Talent.com
Data Migration Specialist

Data Migration Specialist

Mobile Programming LLCNoida
30+ days ago
Job description

Job Title : Data Migration Specialist (MySQL to PostgreSQL)

Location : Noida, India

Experience Required : 6+ Years

Employment Type : Full-Time

Job Overview :

We are seeking an experienced Data Migration Specialist to join our team for a critical migration project. The ideal candidate will have hands-on experience in migrating large-scale databasesspecifically from MySQL to PostgreSQL. The candidate should possess a strong understanding of data structures, migration tools, performance tuning, and must be able to work in a fast-paced project environment.

Key Responsibilities :

  • Lead the end-to-end data migration process from MySQL to PostgreSQL (~800GB of data).
  • Design and implement data migration strategies ensuring data integrity, consistency, and minimal downtime.
  • Analyze existing MySQL schemas and map them effectively to PostgreSQL.
  • Optimize and tune PostgreSQL for performance post-migration.
  • Identify and resolve migration-related issues such as datatype mismatches, stored procedures, and triggers.
  • Work closely with DevOps, DBAs , and application teams to validate the migration process.
  • Create detailed documentation of the migration process, validation steps, and fallback mechanisms.
  • Support post-migration testing and ensure system stability.

Required Skills & Qualifications :

  • Bachelors degree in Computer Science, Information Technology, or related field.
  • Minimum of 6 years of hands-on experience in database management and migrations.
  • Proven experience in migrating large datasets (~800GB or more) from MySQL to PostgreSQL.
  • Strong knowledge of SQL scripting, database performance tuning, and schema conversion.
  • Familiarity with tools like pgLoader, AWS DMS, Ora2Pg, or custom migration scripts .
  • Good understanding of database design, indexing, replication, and backup / restore strategies.
  • Excellent problem-solving and communication skills.

    • Preferred Qualifications :

  • Experience working in cloud environments (AWS, GCP, Azure) with database services.
  • Familiarity with ETL tools and data warehousing concepts.
  • Experience in handling production-level migrations with zero / low downtime.

    • Why Join Us?

  • Opportunity to work on a high-impact, large-scale data migration project.
  • Collaborative and fast-paced work environment.
  • Competitive salary and performance-based growth.

    • (ref : hirist.tech)

    Create a job alert for this search

    Data Migration Specialist • Noida