Technical Lead Database MS SQL

Role & responsibilities

Technical Lead Database (MS SQL)

Experience

• 610 years
• 0-15 Days joiner

Employment Type

• Permanent

Shift

• 10:00 AM 7:00 PM (IST)

Key Skills Required

• Strong expertise in Microsoft SQL Server

• Database design and development

• Writing and optimizing:

• Complex SQL queries

• Stored Procedures

• Functions

• Views

• Triggers (if applicable)

• Performance tuning and query optimization

• ETL development and optimization

• Database troubleshooting

• Data integrity and connectivity issue resolution

• Code reviews and mentoring developers

• Technical leadership and team coordination

Good-to-Have Skills

• Azure SQL or AWS RDS
• Agile/Scrum experience
• Previous experience as a Technical Lead

Leadership Expectations

This is not just a developer role. The company expects someone who can:

• Lead database solution design
• Mentor junior developers
• Review code
• Coordinate with business and development teams
• Drive technical decisions

Interview Topics You Should Prepare

If you're planning to apply, expect questions on:

• SQL query optimization
• Indexes (Clustered vs Non-clustered)
• Execution Plans
• Deadlocks and Blocking
• Transactions and Isolation Levels
• Stored Procedures vs Functions
• CTEs, Temp Tables, and Table Variables
• Window Functions (ROW_NUMBER, RANK, LEAD/LAG)
• Dynamic SQL
• ETL concepts
• SQL Server Agent Jobs
• Database Backup & Restore
• Azure SQL basics (if mentioned on your resume)
• Leadership scenarios and code review practices

Overall Assessment

This role is best suited for someone with:

• 6–10 years of hands-on SQL Server development experience
• Strong performance tuning expertise
• Experience leading a team or acting as a module/technical lead
• Excellent communication and mentoring skills

Regards,

SumeetKadale
Senior Recruiter-TAG

Email: [email protected]
Office: Plot no 23/4. Rajiv Gandhi Infotech Park, Pkase-III Hinjewadi, SEZ, Pune - 411057

New York (HQ)| Buenos Aires | Chicago | Helsinki | Lisbon | London

Melbourne | Mumbai | Pune | So Paulo