Lead SQL Developer/Architect

Aezion, Inc; Bengaluru; Hybrid; INR 3,000,000 - 5,500,000; Full time

Job summary

Aezion, Inc is seeking a Senior Lead Database Engineer with deep expertise in Microsoft SQL Server, operating in hybrid environments (on prem + cloud). You will design, develop, and maintain SQL Server databases, optimize T-SQL objects, and lead database standards for OLTP and reporting workloads.

The role emphasizes data discovery, migration from legacy systems, performance tuning, and automated deployments. Collaboration with DevOps, applications, analytics, and business teams is essential.

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.

Responsibilities

• 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.
• 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.
• 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.
• 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.
• 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.

Skills

SQL Server

T-SQL

Performance tuning

Hybrid architecture

Data migration

Data profiling

Job description

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

• 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

• 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.
• 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.