Senior Database Migration Specialist

Job Description:

We seek a highly skilled Senior Database Migration Specialist with extensive experience in data migration, SQL Server, stored procedures, query tuning, and database performance optimization.

This role is critical to successfully migrating approximately 60 legacy databases to a new database version as part of a high-impact modernization project.

The ideal candidate will have a strong technical background, proven expertise in database migrations, and the ability to troubleshoot and optimize complex database systems.

The selected candidate will work closely with cross-functional teams to ensure data integrity, minimal downtime, and optimal performance throughout the migration process.

Key Responsibilities:

• Analyze, plan, and execute the migration of 60 databases from an old version to a new version of the database.
• Develop and implement strategies to ensure data consistency, accuracy, and completeness during migration.
• Identify and resolve potential schema changes, data types, and compatibility issues.
• Write, optimize, and maintain complex SQL queries, stored procedures, and functions to support migration.
• Tune database queries for performance and scalability, ensuring minimal latency and resource consumption.
• Maintain and enhance existing VB.NET applications for data processing or database interaction.
• Ensure the compatibility of VB.NET applications with the updated database architecture.
• Monitor and analyze database performance metrics and implement solutions to address bottlenecks.
• Configure indexes, optimize schemas, and apply best practices for database design.
• Work closely with project managers, analysts, and other developers to understand requirements and timelines.
• Create and maintain comprehensive documentation for migration processes, code changes, and database configurations.
• Provide training or support to the team to transition to the new database version.
• Diagnose and resolve technical issues related to database performance and migration challenges.
• Ensure data security and compliance with organizational standards throughout the project.

Qualifications:

• Technical Skills:
  • Strong proficiency in SQL Server (versions 2016 or later preferred).
  • Expertise in VB.NET application development and maintenance.
  • Proven experience with data migration projects involving multiple databases.
  • Advanced skills in query tuning, performance optimization, and database profiling.
  • Experience with ETL processes and tools is a plus.
  • Knowledge of database security, indexing strategies, and normalization principles.
• Experience:
  • Minimum 5 years of experience as a SQL Developer or Database Engineer.
  • Hands-on experience with large-scale database migrations or upgrades.
  • Familiarity with legacy database systems and strategies for transitioning to modern platforms.
• Soft Skills:
  • Strong analytical and problem-solving abilities.
  • Excellent communication and teamwork skills.
  • Ability to manage multiple tasks and meet deadlines under pressure.
  • Detail-oriented with a commitment to delivering high-quality results.

Benefits:

• Market-leading salary.
• Medical coverage – self and dependents.
• Parents medical coverage.
• Provident fund.
• Employee performance-based bonuses.
• Home internet subsidy.
• Conveyance allowance.
• Profit sharing plan [tenured employees only].
• Life benefit.
• Child care facility.
• Company-provided lunch/dinner.
• Professional development budget.
• Recreational area for in-house games.
• Sporadic on-shore training opportunities.
• Friendly work environment.
• Leave encashment.

Disclaimer: We attribute our success to the unique contributions of our diverse staff. We're committed to fostering a culture of respect that thrives on the varied perspectives and experiences of all individuals we recruit, employ, promote, and compensate. Since day one, we've adhered to a policy that champions a work environment honoring the worth and dignity of each person while being free from all forms of employment discrimination.

Our continuous effort to promote inclusivity extends our commitment to individuals with special needs by providing reasonable accommodations. We actively encourage qualified individuals with special needs to apply for various openings within our company. Should you require assistance in completing the application process or have any inquiries regarding special facilities, please do not hesitate to contact our HR team. Your unique talents and abilities are welcomed and valued here.