Technical Lead Database MS SQL

Fulcrum Worldwide Software; Pune District; Hybrid; INR 1,500,000 - 2,100,000; Full time

Job summary

Fulcrum Worldwide Software is seeking a Technical Lead Database (MS SQL) in Pune to lead database design and oversee development efforts. You will mentor junior developers, review code, and coordinate with business and development teams to drive technical decisions.

Strong SQL Server and ETL skills are essential for delivering scalable data solutions. The role requires hands-on leadership with a focus on performance tuning, query optimization, and data integrity across complex databases.

Qualifications

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

Responsibilities

• Lead database solution design and architecture.
• Mentor junior developers and conduct code reviews.
• Coordinate with business and development teams to drive decisions.
• Review code to ensure quality and scalability.
• Drive technical decisions and deliver robust DB solutions.

Skills

Microsoft SQL Server

Database design

Complex SQL

Stored Procedures

Functions

Views

Triggers

Performance tuning

ETL development

Database troubleshooting

Data integrity

Code reviews

Technical leadership

Team coordination

Education

6–10 years SQL Server development

Tools

Azure SQL

AWS RDS

Job description

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

New York (HQ) | Buenos Aires | Chicago | Helsinki | Lisbon | London | Melbourne | Mumbai | Pune | So Paulo