"Alerted.org

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!

Why you'll love this job

+ ​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.

What you'll do

+ Translates a logical data model or user specifications into a physical design

+ Ensures detailed physical design of data structures and database complies with enterprise standards, guidelines, procedures, and processes

+ Creates physical database structures based on physical design for development, test, and production environments

+ Coordinates with systems engineers to configure servers for DBMS product installation and database creation

+ Implements monitoring procedures to maximize availability and performance of the database, while meeting defined SLAs

+ Investigates, troubleshoots, and resolves database problems

+ Identifies, defines, and implements database backup / recovery and security strategies

+ Oversees and sets DBMS platform performance and availability improvements measures based on metric analysis

+ Leads highly complex capacity planning, workload modeling, system maintenance/ administration, and diagnostics

+ Architectures and designs enterprise databases and data warehouse

+ Leads implementation and administration of Oracle 11g & 12c Single and Multi-Tenant RAC environment on ASM/ACFS, Data Guard in Linux/Unix environment

+ Contributes to architectural direction and provides the expertise for design and performance of the database structures, assists with database performance tuning, database capacity issues, replication and other distributed data issues.

+ Creates, coordinates and administers databases, including base definition, structure documentation, operational guidelines, and security.

+ Applies established data management best practices and recommends improvements

+ As Primary Administrator Oracle Database Appliance (ODA) machines, designs, implements, patches, and troubleshoots performance and capacity planning for CPU and storage

+ Responsible for design of, implementation and administration of SQL Server replication and/or AlwaysOn Availability Groups.

+ Assists with other information technology projects, as assigned, within the general scope of regularly assigned responsibilities and related qualifications.

+ Provides on-site, and on-call support, as needed

All you'll need for success

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 (Oracle 11g/12c and SQL Server 2008/2012/2014)

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 (Oracle 11g/12c and SQL Server 2008/2012/2014)

+ Airline Industry experience

Skills, Licenses & Certifications

+ Cloud & Database Platforms:

+ Azure SQL Database

+ Cosmos DB

+ Azure Database for PostgreSQL/MySQL

+ Azure Resource Manager (ARM) templates

+ Azure Monitor, Log Analytics, Application Insight

+ Certifications:

+ AZ-900: Microsoft Azure Fundamentals

+ DP-300: Administering Relational Databases on Microsoft Azure

+ DP-900: Microsoft Azure Data Fundamentals

+ AZ-104: Microsoft Azure Administrator

+ Database Design & Administration:

+ Extensive experience in design, implementation, support, and administration of databases

+ Automation of database maintenance across multiple servers

+ SQL Server Master/Target server architecture

+ Oracle Real Application Clusters (RAC)

+ High Availability & Disaster Recovery:

+ AlwaysOn, Mirroring, Log Shipping, Clustering

+ Oracle Data Guard and Oracle GoldenGate replication

+ Performance & Monitoring:

+ Alerts and monitoring using Profiler, Resource Monitor, Shell scripting

+ Third-party appliances

+ Oracle Enterprise Manager Grid Control

+ Security & Compliance:

+ Implementation of database security standards

+ Installations, service packs, hotfix updates, and upgrades

+ Capacity Planning & Infrastructure:

+ Database capacity planning

+ Engineered system implementation and administration

+ Integration & Reporting:

+ Supporting SSIS, SSRS, and SQL sentry

+ Development Methodologies & Toolchains:

+ Agile methodologies

+ DevOps toolchain technologies

What you'll get

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 to your 401(k) program are available after one year.

+ Additional Benefits: Other great benefits include our Employee Assistance Program, pet insurance and discounts on hotels, cars, cruises and more

Feel free to be yourself at American

From the team members we hire to the customers we serve, inclusion and diversity are the foundation of the dynamic workforce at American Airlines. Our 20+ Employee Business Resource Groups are focused on connecting our team members to our customers, suppliers, communities and shareholders, helping team members reach their full potential and creating an inclusive work environment to meet and exceed the needs of our diverse world.

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 life’s journey? Feel free to be yourself at American.

EQUAL EMPLOYMENT OPPORTUNITY/ AFFIRMATIVE ACTION POLICY

American Airlines maintains a continuing policy of nondiscrimination in employment. It is our policy to provide equal opportunity and access for all persons, without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or status as a disabled veteran or other protected veteran, in all phases of the employment process and in compliance with applicable federal, state, and local laws and regulations. This policy of nondiscrimination shall include, but not be limited to, the following employment decisions and practices: hiring; upgrading; promotions; demotions or transfers; layoffs; recalls; terminations; rates of pay or other forms of compensation; selection for training, including apprenticeship; and recruitment or recruitment advertising.