PARTNER CONSULTANT - T-SQL

Happiest Minds Technologies; Bengaluru; Hybrid; INR 1,200,000 - 2,600,000; Full time

Job summary

Happiest Minds Technologies in Bengaluru, India, is seeking an experienced Database Migration Developer with deep expertise in Sybase ASE and Microsoft SQL Server (MSSQL). The role focuses on assessing, converting, optimizing, and migrating database objects, SQL code, and applications from Sybase ASE to SQL Server while ensuring performance and data integrity.

The candidate will work across migration projects, collaborating with application teams, DBAs, architects, and business stakeholders to

Qualifications

• Experience in migrating from Sybase ASE to Microsoft SQL Server (MSSQL).
• Strong SQL and T-SQL coding skills with experience in database objects migration.
• Ability to optimize queries, validate data integrity, and ensure business continuity.

Responsibilities

• Analyze existing Sybase ASE databases, schemas, and application dependencies.
• Convert and migrate database objects including tables, views, stored procedures, triggers, functions, and jobs.
• Convert Sybase SQL/Transact-SQL to MSSQL compatible code and validate migrations.
• Perform data migration and validation activities; optimize post-migration objects.
• Collaborate with application teams and DBAs throughout migration projects.

Skills

Sybase ASE

MSSQL

SQL

T-SQL

Database migration

Performance tuning

Tools

SQL Server/SSMS

Schema comparison tools

Job description

Job Description: Sybase ASE to Microsoft SQL Server (MSSQL) Developer

Position Title

Sybase ASE to MSSQL Migration Developer

Experience

5-10 Years

Location

Bangalore / Chennai / Hyderabad / Pune (Hybrid)

Job Summary

We are seeking an experienced Database Migration Developer with strong expertise in Sybase ASE (Adaptive Server Enterprise) and Microsoft SQL Server (MSSQL). The candidate will be responsible for assessing, converting, optimizing, and migrating database objects, SQL code, and applications from Sybase ASE to SQL Server while ensuring performance, data integrity, and business continuity.

Key Responsibilities

• Analyze existing Sybase ASE databases, schemas, and application dependencies.
• Convert and migrate database objects including:
  • Tables
  • Views
  • Stored Procedures
  • Triggers
  • Functions
  • User Defined Types
  • Jobs and Schedulers
• Convert Sybase SQL, Transact-SQL, and proprietary syntax to Microsoft SQL Server compatible code.
• Perform data migration and validation activities.
• Optimize queries and database objects post-migration.
• Resolve compatibility issues between Sybase ASE and SQL Server.
• Execute schema comparison, code remediation, and testing activities.
• Support performance benchmarking and tuning after migration.
• Develop migration automation scripts wherever feasible.
• Collaborate with application teams, DBAs, architects, and business stakeholders throughout migration projects.