Aezion, Inc
Website:
aezion.com
Job details:
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.
Click on Apply to know more.