Lead SQL Developer/Architect

Description:

Senior Lead Database Engineer SQL Server.

Bengaluru/Coimbatore.

Fulltime.

Role Summary.

We are seeking a Senior Lead Database Engineer with deep expertise in Microsoft SQL Server, operating primarily in hybrid environments (on prem + cloud).

This role combines strong database development, administration, performance engineering, and automated deployments, with a critical emphasis on data discovery and migration from legacy systems.

The ideal candidate is highly analytical, has a strong data mindset, and excels at exploring complex, undocumented legacy databases understanding data flow, dependencies, and gaps and bringing clarity to enable successful modernization and migration initiatives.

Key Responsibilities :SQL Server Engineering :

• Design, develop, and maintain SQL Server databases with a focus on performance, scalability, and reliability.

• Develop and optimize T SQL objects (stored procedures, functions, views, indexes).

• Lead database design standards across OLTP and reporting workloads.

• Balance hands-on development and administration, ensuring operational stability and engineering excellence.

Hybrid Administration & Performance :

• Own SQL Server administration across on prem and cloud/hybrid environments.

• Ensure high availability, backup/restore, disaster recovery, and security best practices.

• Proactively identify and resolve performance issues using execution plans, Query Store, DMVs, and wait stats.

• Establish capacity planning and performance baselines.

Automated Deployments & Database CI/CD :

• Implement database-as-code using SQL Server Database Projects (SSDT / .sqlproj).

• Build and maintain automated database deployment pipelines across environments.

• Manage schema versioning, environment consistency, and controlled releases.

• Partner with DevOps teams to align database deployment with application CI/CD.

Legacy Data Exploration & Migration :

• Deeply analyze and profile legacy SQL Server and upstream data sources.

• Understand and document data flows, dependencies, and lineage across systems.

• Identify data quality issues, gaps, redundancies, and inconsistencies.

• Design and execute data migration strategies, including validation and reconciliation.

• Translate data findings into actionable insights for modernization and migration planning.

Leadership & Collaboration :

• Serve as the technical lead for database engineering initiatives.

• Mentor engineers and enforce database best practices.

• Collaborate with applications, analytics, and business teams to surface hidden data risks and opportunities.

• Drive informed architectural decisions through data analysis.

Required Qualifications :

• 8+ years of hands-on experience with Microsoft SQL Server.

• Strong expertise in T SQL development and performance tuning.

• Proven experience with SQL Server Database Projects and automated deployments.

• Deep experience with legacy system analysis and data migrations.

• Strong understanding of SQL Server internals and hybrid architectures.

• Ability to independently explore complex data environments and bring clarity.