Senior Database Engineer

1127 Amadeus Software Labs India Private Limited; Pune District; On-site; INR 1,500,000 - 2,300,000; Full time

Job summary

Amadeus Software Labs India Private Limited is seeking a Senior Database Engineer to design, develop, and optimize SQL Server databases. The role requires collaboration with Architecture and Development teams to deliver scalable, highly available data solutions and robust production support.

You will review SQL code, tune queries, implement AGs, build SSIS/ADF workflows, and manage SQL Server Agent Jobs. Strong data modeling, performance tuning, and incident response skills are essential for

Qualifications

• 6-8+ years of hands-on experience in Microsoft SQL Server.
• Expertise in SQL Server development, performance optimization, and administration.
• Experience reviewing database code, troubleshooting production incidents, and ensuring high availability.

Responsibilities

• Design, develop, and maintain SQL Server databases supporting critical applications.
• Collaborate with Architecture/Development to create scalable data-tier solutions and analytics.
• Review and govern SQL code quality, including T-SQL scripts, stored procedures, and deployment scripts.
• Tune queries, optimize indexing, partition data, and implement performance improvements.
• Ensure high availability with SQL Server Always On and manage DR/testing planning.

Skills

SQL Server

T-SQL

Query optimization

Always On AG

Production support

SQL Server Agent Jobs

Performance tuning

Tools

SSIS

Azure Data Factory

SSRS Reporting Services

DPA

Extended Events

Job description

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

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. We are Amadeus and we make travel work better for everyone, everywhere. As part of our global team of 20,000+ passionate team members across 100+ locations, you'll join a community united by a love for travel and technology. We're not just shaping the future of travel; we're using it as a force for good, enriching lives and supporting our planet. Here, you'll be free to innovate and grow with driven colleagues. Join us on a journey where you will help us bring the world closer!