Sr Data Architect, IT

Job Description Intro

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 on board!

• This job is a member of the Information Technology Team within the Information Technology Division.
• Responsible for working closely with a highly talented team of database administrators and engineers, in the design, implementation, and support of enterprise standard databases based on business area requirements. You will drive the identification, definition, and implementation of database backup/recovery and security strategies; install and support DBMS (Database Management Systems) software and tools; be responsible for various database activities, including monitoring, tuning, capacity, migrating, upgrading, troubleshooting, and consulting.

• Plan and implement database designs, including the creation and maintenance of cloud databases.
• Allocate resources such as Storage / Compute / Memory. Implement strategies for HA, Failover DR and Replication.
• Fine-tune database systems to enhance performance, scalability, and reliability - including monitoring and optimizing database query performance, indexing etc.
• Establish access and authentication controls to secure data, setup encryption, masking as required.
• Manage and monitor performance, security, and availability of databases.
• Implement database backup and disaster recovery procedures.
• Work with development teams to optimize database usage and query performance.
• Coordinate and manage migration of databases to Azure platform.
• Perform capacity planning and demand forecasting for database systems.
• Identify and troubleshoot any database-related issues in a timely manner.
• Stay current with the latest Azure technologies, trends, and techniques.

Minimum Qualifications
- Education & Prior Job Experience

• Bachelor's degree in Computer Science, Computer Engineering, Technology, Information Systems (CIS/MIS), Engineering or related technical discipline, or equivalent experience/training
• 5 years applicable experience in the design/administration/ support of one or more DBMS platforms required (Azure DB offerings, SQL Server 2019, Oracle 19c)

Preferred Qualifications
- Education & Prior Job Experience

• Master's degree in Computer Science, Computer Engineering, Technology, Information Systems (CIS/MIS), Engineering or related technical discipline, or equivalent experience/training
• 7+ years applicable experience in the design/administration/ support of one or more DBMS platforms required (Azure DB offerings, SQL Server 2019, Oracle 19c)
• Airline Industry experience

Skills, Licenses & Certifications

• Cloud & Database Platforms:
  • Microsoft Azure
  • Azure DB’s (Azure SQL, Postgre
    
    SQL, Cosmos)
  • Azure Database for Postgre
    
    SQL/MySQL
  • SQL Server 2019/2022
• Certifications:
  • AZ-900:
    Microsoft Azure Fundamentals
  • DP-300:
    Administering Relational Databases on Microsoft Azure
  • AZ-104:
    Microsoft Azure Administrator
• Performance & Monitoring:
  • Alerts and monitoring using Profiler, Resource Monitor, Shell scripting
  • Third-party appliances
  • Oracle Enterprise Manager Grid Control

Feel free to take advantage of all that American Airlines has to offer:

• Travel Perks:
  Ready to explore the world? You, your family and your friends can reach 365 destinations on more than 6,800 daily flights across our global network.
• Health Benefits:
  
  On day one, you’ll have access to your health, dental, prescription and vision benefits to help you stay well. And that’s just the start, we also offer virtual doctor visits, flexible spending accounts and more.
• Wellness Programs:
  We want you to be the best version of yourself – that’s why our wellness programs provide you with all the right tools, resources and support you need.
• 401(k) Program:
  Available upon hire and, depending on the workgroup, employer contributions…