SQL Lead Developer

TechDigital Group; Providence (RI); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading tech consulting firm based in Providence, Rhode Island is seeking a Database Migration Lead with over 10 years of SQL development experience. You will lead the migration from Sybase to SQL Server, ensuring performance and data integrity. Key responsibilities include designing migration scripts, optimizing schemas, and collaborating closely with teams. Proven experience with SSIS and database administration is essential for this role.

Qualifications

• 10+ years in SQL development and database administration.
• Hands-on experience with Sybase ASE and SQL Server.

Responsibilities

• Lead the database migration effort to SQL Server.
• Design and execute migration scripts and stored procedures.
• Optimize SQL Server schema and indexing.
• Validate data integrity and performance post-migration.
• Document database changes and support production cutover.

Skills

T-SQL

Stored procedures

Triggers

Views

SSIS

Data migration tools

Query optimization

Execution plan analysis

Tools

Sybase ASE

SQL Server

Job description

Mandatory Skills

• T-SQL, stored procedures, triggers, views.
• SSIS, BCP, and other data migration tools.
• Query optimization and execution plan analysis.

Experience level:

• 10+ years in SQL development and database administration.
• Hands-on experience with Sybase ASE and SQL Server.

Job Description
Lead the database migration effort, ensuring a like-to-like transition from Sybase to SQL Server with a focus on performance, scalability, and data integrity.
Key Responsibilities:

• Design and execute migration scripts and stored procedures.
• Optimize SQL Server schema, indexing, and partitioning.
• Validate data integrity and performance post-migration.
• Collaborate with application and ETL teams for seamless integration.
• Document database changes and support production cutover