Senior Database Engineer

Amadeus; Pune District; On-site; INR 1,400,000 - 2,200,000; Full time

Job summary

Amadeus in Pune is seeking a Senior Database Engineer with strong SQL Server development and administration skills. The role blends database engineering, performance optimization, production support, and high-availability design to deliver scalable database solutions.

You will review database code, troubleshoot production incidents, and partner with development and architecture teams to ensure resilience and reliability in data platforms.

Qualifications

• 6–8+ years of hands-on Microsoft SQL Server experience.
• Strong T-SQL development and optimization skills.
• Experience with AGs, production support, and tuning.

Responsibilities

• Design, develop, and maintain SQL Server databases supporting operations.
• Review SQL code quality, deployed scripts, and data patterns.
• Tune performance with indexing, partitioning, and query optimization.
• Ensure high availability via SQL Server Always On AG.
• Troubleshoot production issues including blocking and deadlocks.
• Develop and monitor SQL Server Agent Jobs and automate processes.

Skills

SQL Server

T-SQL

Query optimization

Always On

Production support

Azure Data Factory

SSIS

Troubleshooting

Indexing strategies

High availability

Tools

SQL Server Agent

DPA

Extended Events

Job description

Job Title

Senior Database Engineer

We are looking for an experienced Database Engineer (DBE) with strong expertise in SQL Server development and administration. The role requires a blend of database engineering, performance optimization, production support, and high-availability design. The ideal candidate should have hands-on experience reviewing database code, troubleshooting production incidents, and partnering with development and architecture teams to deliver scalable, resilient, and highly available database solutions.

Key Responsibilities

• Design, develop, and maintain SQL Server databases supporting
• Collaborate with Architecture and Development teams to design scalable data-tier solutions, including database schemas, data distribution, reporting, and analytics.
• Review and govern SQL code quality, including T- SQL scripts, stored procedures, deployment scripts, and database design patterns.
• Manage and optimize database performance through query tuning, indexing strategies, partitioning, and other performance-enhancement techniques.
• Ensure high availability, resilience, and fault tolerance through implementation and management of SQL Server Always On Availability Groups.
• Troubleshoot and resolve production database issues, including blocking, deadlocks, slow-running queries, job failures, and database performance bottlenecks.
• Develop and maintain SQL Server Agent Jobs, ensuring proper scheduling, monitoring, and operational support.
• Support data integration processes using SSIS and Azure Data Factory (ADF).
• Upgrade, patch, and maintain SQL Server environments while monitoring overall database health using tools such as DPA and Extended Events.
• Partner with TechOps teams in defining database standards, governance, capacity planning, cost optimization, backup strategies, disaster recovery testing, and business continuity planning.
• Provide technical guidance to application development teams on database design best practices and performance optimization.
• Perform root cause analysis and provide escalation support for critical production incidents.

Required Skills & Experience

Must Have

• 6–8+ years of strong hands-on experience in Microsoft SQL Server.
• Strong SQL Server development expertise with advanced T- SQL knowledge.
• Extensive experience in reviewing and optimizing SQL code, stored procedures, and database deployment scripts.
• Strong understanding of SQL Server Always On Availability Groups (AG).
• Hands-on experience with production support and troubleshooting: Blocking and deadlocks Query performance issues SQL Agent job failures Database performance bottlenecks
• Expertise in query optimization, execution plan analysis, and indexing strategies.
• Experience creating, scheduling, monitoring, and troubleshooting SQL Server Agent Jobs.
• Strong understanding of high availability, disaster recovery, backup, and restore strategies.

Good to Have

• Experience with SSIS package development and maintenance.
• Exposure to Azure Data Factory (ADF).
• Basic knowledge of SSRS Reporting Services.
• Experience working with cloud-based database environments.
• Familiarity with NoSQL databases.
• Experience working in SAFe Agile environments.
• Exposure to Azure DevOps/TFS for incident, change, and work item management.

Preferred Candidate Profile

• Strong database engineering mindset with a focus on reliability, scalability, and performance.
• Proven ability to review and improve database code quality.
• Hands-on experience supporting highly available production environments.
• Strong analytical and problem-solving skills with the ability to perform detailed root-cause analysis.
• Excellent stakeholder management and collaboration skills across Architecture, Development, SRE, and Operations teams.

Diversity & Inclusion

Amadeus aspires to be a leader in Diversity and Inclusion in the tech industry, enabling every employee to reach their full potential by fostering a culture of belonging and fair treatment, attracting the best talent from all backgrounds, and as a role model for an inclusive employee experience.

Amadeus is an equal opportunity employer and committed to an accessible recruitment process. All qualified applicants will receive consideration for employment without regard to gender, race, ethnicity, sexual orientation,age, beliefs, disability or any other characteristics protected by law.