Job Title

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.American’s 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 American’s 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.Job Description:Sr Engineer, IT DataINTRO:Are you ready to explore a world of possibilities, both at work and during your time off? Join our American Airlines family, and you’ll travel the world, grow your expertise, and become the best version of you. As you embark on a new journey, you’ll 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 YOU’LL LOVE THIS JOB:You’ll join a diverse, high performing engineering team that takes pride in technical excellence and builds the database platforms powering one of the world’s most complex operational environments. Your work directly strengthens the reliability, scalability, and profitable airline.You’ll 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. You’ll help shape the standards and capabilities that enable data to flow securely, efficiently, and intelligently across the enterprise.WHAT YOU’LL 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 decisionsDesign, administer, and support Oracle 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, including SQL tuning, AWR/ASH analysis, optimizer statistics management, indexing strategies, and wait event diagnostics. Design, Implement and manage Oracle HA/DR solutions such as RAC, Data Guard, Goldengate, ASM, RMAN, and Cluster ware, ensuring resilient and fault tolerant architectures.Collaborate with application teams to design efficient database schemas, data models, and integration patterns that support scalable and resilient systems.Automate operational tasks using Shell scripting, PL/SQL, Python, or Ansible to improve consistency, reliability, and operational efficiency.Support and execute Oracle database migrations to cloud platforms, including assessment, planning, data movement, cutover, and validation.Enforce security via Transparent Data Encryption (TDE), Database Vault, and Key Vault.Manage and optimize cloud database resources, including sizing, scaling, performance configuration, cost management, backup/restore policies, and security controls for Azure/AWS database deploymentsImplement cloud based high availability and disaster recovery architectures, such as zone redundant deployments, geo replication, and automated failover strategies.Automate routine DBA tasks to improve consistency, reliability, and operational efficiency.Monitor database health and capacity using OEM, AWR, ASH, and enterprise monitoring tools; proactively identify and resolve issues related to performance, storage, availability, and security. 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 YOU’LL NEED FOR SUCCESS:Minimum Qualifications – Education & Prior Job Experience:Bachelor’s degree in computer science, Engineering, Information Systems, or related field (or equivalent experience).10+ years of hands-on experience as an Oracle DBA, supporting mission critical, high availability environments.Strong expertise with Oracle including installation, configuration, patching, upgrades, backup/restore, performance tuning, indexing strategies, query optimization, and security hardening.5+ years of experience with high availability and disaster recovery technologies. 3+ years of experience with cloud database platforms (OCI, Azure, AWS2+ years of experience with automation and scripting.Preferred Qualifications – Education & Prior Job Experience:3+ years managing SQL Server, PostgreSQL or MySQL database platform supporting large-scale applications or data engineering solutions2+ years' experience with CI/CD automation for database code deployments using GitHub Actions, Azure DevOps2+ years' experience with enterprise monitoring tools 1+ years' experience with IaC tools for cloud database infrastructureAirline Industry ExperienceSkills, Licenses, and Certifications:Expertise with the Azure Technology stack for data management, data ingestion, capture, processing, curation and creating consumption layersExpertise in providing practical direction within the Azure Native cloud servicesAzure Certification (preferred)Combination of Development, Administration & Support experience in several of the following tools/platforms requiredScripting: Python, Bash, SQL, PLSQLData Platforms: SQL Server, Oracle, PostgreSQL, MySQL, Snowflake, Redis Cache, Teradata, MongoDBLANGUAGE / COMMUNICATION SKILLS:Ability to effectively communicate both verbally and written with all levels within the organizationPhysical 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 employee’s physical ability to safely and/or successfully perform the position’s essential job functions, the HR team generally willengage 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 employee’s obvious or known condition. Then, if necessary, HR would request medical documentation from the team member’s treating physician or others to confirm the employee’s 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 runningsmoothly as we care for people on life’s journey? Feel free to be yourself at American.COMPETENCIES:CaringCollaborationDevelopmentFutureResult