Senior Engineer, IT Data [T500-24307]

ANSR is hiring for one of its clients.

About American Airlines:

To Care for People on Life's Journey. Together with our American Eagle regional partners, we offer thousands of flights daily to more than 350 destinations in more than 60 countries.

American Airlines is transforming the way it delivers technology to its customers and team members worldwide.

Americans Tech Hub in Hyderabad, India, is our latest technology office location and home to team members who drive technical innovation and engineer unrivalled digital products to best serve Americans customers and team members. With U.S. tech hubs in Dallas-Fort Worth, Texas and Phoenix, Arizona, our new team in Hyderabad, India enables better support of our 24/7 operation and positions American to deliver industry-leading technology solutions that create a world-class customer experience.

INTRO:

Are you ready to explore a world of possibilities, both at work and during your time off? Join our American Airlines family, and youll travel the world, grow your expertise, and become the best version of you. As you embark on a new journey, youll tackle challenges with flexibility and grace, learning new skills and advancing your career while having the time of your life. Feel free to enrich both your personal and work life and hop onboard!

WHY YOULL LOVE THIS JOB:

Youll join a diverse, high performing engineering team that takes pride in technical excellence and builds the database platforms powering one of the worlds most complex operational environments. Your work directly strengthens the reliability, scalability, and profitable airline.

Youll be part of an organization that treats database platforms as strategic assets. This includes everything from infrastructure engineering and performance optimization to database lifecycle management, storage architecture, integration patterns, monitoring, automation, and governance. Youll help shape the standards and capabilities that enable data to flow securely, efficiently, and intelligently across the enterprise.

WHAT YOULL DO:

This list is intended to reflect the current job but there may be additional essential functions (and certainly non-essential job functions) that are not referenced. Management will modify the job or require other tasks be performed whenever it is deemed appropriate to do so, observing, of course, any legal obligations including any collective bargaining obligations.

• Work closely with application teams and architects to design, implement and support database solutions that provide insights to make better decisions
• Design, administer, and support SQL Server database platforms across development, test, and production environments, ensuring high availability, performance, and reliability.
• Design, implement, and maintain database infrastructure including installation, configuration, patching, upgrades, backup/restore strategies, disaster recovery, and security hardening.
• Perform advanced performance tuning and optimization (indexing strategies, query tuning, execution plan analysis, resource governance, storage optimization).
• Collaborate with application teams to design efficient database schemas, data models, and integration patterns that support scalable and resilient systems.
• Support and execute SQL Server migrations to cloud platforms, including assessment, planning, data movement, cutover, and validation.
• Manage and optimize cloud database resources, including sizing, scaling, performance configuration, cost management, backup/restore policies, and security controls for Azure/AWS database deployments
• Enforce security via Transparent Data Encryption (TDE), Database Vault, and Key Vault.
• Implement cloud based high availability and disaster recovery architectures, such as zone redundant deployments, geo replication, and automated failover strategies.
• Automate routine DBA tasks using PowerShell, TSQL, and enterprise automation tools to improve consistency, reliability, and operational efficiency.
• Monitor database health and capacity using enterprise monitoring tools; proactively identify and resolve issues related to performance, availability, storage, and security.
• Implement and support high availability and disaster recovery solutions (Always On Availability Groups, Failover Clustering, Log Shipping, Replication).
• Ensure compliance with data governance, auditing, encryption, and security standards; participate in vulnerability remediation and risk mitigation.
• Participate in on call rotation and provide support for complex database incidents, root cause analysis, and long-term remediation.
• Contribute to the development of DBA standards, best practices, documentation, and operational runbooks.
• Mentor junior engineers and collaborate with cross functional teams to elevate database engineering maturity and operational excellence.

ALL YOULL NEED FOR SUCCESS:

Minimum Qualifications Education & Prior Job Experience:

• Bachelors degree in computer science, Engineering, Information Systems, or related field (or equivalent experience).
• 5+ years of hands-on experience as a SQL Server DBA, supporting mission critical, high availability environments.
• Strong expertise with SQL Server, including installation, configuration, patching, backup/restore, performance tuning, indexing strategies, query optimization, and security hardening.
• 3+ years of experience with high availability and disaster recovery technologies (Always On Availability Groups, Failover Clustering, Log Shipping, Replication).
• 1+ years of experience with cloud database platforms, preferably Microsoft Azure (Azure SQL Managed Instance, Azure SQL Database, SQL Server on Azure VMs).
• 1+ years of experience with automation and scripting using PowerShell and T SQL.

Preferred Qualifications Education & Prior Job Experience:

• 1+ years managing Oracle, PostgreSQL or MySQL database platform supporting large-scale applications or data engineering solutions
• 1+ years experience with IaC tools, CI/CD automation for database code deployments using GitHub Actions, Azure DevOps
• 1+ years' experience with enterprise monitoring tools
• Airline Industry Experience

Skills, Licenses, and Certifications:

• Expertise with the Azure Technology stack for data management, data ingestion, capture, processing, curation and creating consumption layers
• Expertise in providing practical direction within the Azure Native cloud services Azure Certification (preferred)
• Combination of Development, Administration & Support experience in several of the following tools/platforms required:
• Scripting: Python, PowerShell, SQL
• Data Platforms: SQL Server, Oracle, PostgreSQL, MySQL, Snowflake, Redis Cache, Teradata, MongoDB

LANGUAGE / COMMUNICATION SKILLS:

Ability to effectively communicate both verbally and written with all levels within the organization

Physical ability necessary to safely and successfully perform the essential functions of the position, with or without any legally required reasonable accommodations that do not pose an undue hardship. Note: If the Company has reason to question an employees physical ability to safely and/or successfully perform the positions essential job functions, the HR team generally will engage in an interactive process to determine whether a reasonable accommodation is appropriate. HR (working with the operation) ordinarily first speaks with the team member directly and they mutually identify the physical demands of the job that are or may be impacted by the employees obvious or known condition. Then, if necessary, HR would request medical documentation from the team members treating physician or others to confirm the employees ability to perform those essential job functions safely and successfully.

FEEL FREE TO BE YOURSELF AT AMERICAN:

Are you ready to feel a tremendous sense of pride and satisfaction as you do your part to keep the largest airline in the world running smoothly as we care for people on lifes journey? Feel free to be yourself at American.

COMPETENCIES:

• Caring
• Collaboration
• Development
• Future
• Result