Senior Database Engineer

Location: Pune, Bangalore

Remote Type: On Site

Time Type: Full time

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

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.

 

Be aware of recruitment scams

Amadeus Group never charges fees, requests payment, or asks for financial information during recruitment. All legitimate opportunities are communicated solely through official Amadeus channels, including our careers website. Any payment request or outreach via unofficial platforms (e.g., WhatsApp, Telegram) should be treated as fraudulent.