Senior/Lead Database Engineer - SQL Server

Role : Senior Lead Database Engineer SQL Server Location : Bengaluru/Coimbatore Notice period : Max 30 days 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 databasesunderstanding data flow, dependencies, and gapsand 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. Role : Senior Lead Database Engineer SQL Server Location : Bengaluru/Coimbatore Notice period : Max 30 days 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 databasesunderstanding data flow, dependencies, and gapsand 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 relea