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)
- Agile 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 | H

📌 Technical Lead Database MS SQL (Pune)
🏢 Fulcrum Worldwide Software
📍 Pune