Role:Senior Lead Database Engineer – SQL Server
Relevant Experience: At least 8+ years of relevant experience are required
Location: Bengaluru, KA or Coimbatore, TN
Notice period: We are Open – Preferred Who can Join as soon as possible
Opportunity: Full time
About Aezion:
Aezion is a technology solutions provider specializing in custom software, AI-driven solutions, and enterprise digital transformation.>
Aezion is one of the trusted digital engineering providers in the USA and we live by the adage that our word is our bond. Our Promise is to get it right or make it right. We accomplish this by investing the effort to exceed client expectations from start to finish – architecting, designing, developing, hosting, maintaining, and supporting our clients throughout the project lifecycle. We believe that work is ministry – an expression of our values. Our goal is to honor our commitments to clients and the life energies of Aezion employees through results that transform clients into lifelong partners.
Working at Aezion:
We are a mission-driven company guided by our values: Love, Dependability, Humble Confidence, Inclusion, Speed & Innovation. We operate with a service-first mindset and measure success through customer outcomes and delivery excellence.
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.
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.