Location : DFW Headquarters Building 7 (DFW-SV07)
Cities :
Requisition ID : 77814

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!

Why you'll love this job

• This job is a member of the Information Technology Team within the Information Technology Division.
• Responsible for designing, developing, implementing and tuning complex enterprise level database systems, tools, and business intelligence solutions.
• Responsible for designing and building Oracle RAC systems, administering, maintaining Oracle relational databases and assisting the application development teams in optimizing schema design and SQL statements.

What you'll do

• Serve as subject matter expert for Oracle and other database related technologies.
• Work in live transaction databases, operational data stores and small data mart environments.
• Write queries, stored procedures, functions and views.
• Respond to user requests for new tables, procedures, views and reports.
• Use data modeling tools to optimize overall database schemas for targeted environments and use.
• Develop both new databases as well as extending, consolidating and tuning existing database environments.
• Develop SSIS packages to transfer data from live transaction environments.
• Develop reports with Cognos, Tableau.
• Act as subject matter expert for data management principles, modeling, design, and development for a large data environment.
• Guide and govern code based best practices and standards.
• Manage/administer the development, quality assurance and user acceptance testing database.
• Track and document data layer for applications and systems.
• Tune and troubleshoot database performance issues.
• Perform code reviews and set direction and priority for work items.
• This position will include off hours work to perform database changes after core business hours.
• Support production environment with flexible weekly rotating pager.

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.
• 3 years of experience as an Oracle DBA.
• Built and supported Oracle 11g/12c databases in RAC environments with ASM on Linux/Unix based systems.
• Knowledge of RHEL/Oracle Linux.
• Knowledge of Oracle RAC with well-organized approach to database administration, performance, backup/recovery and troubleshooting and tuning.
• Knowledge of Oracle SQL, PL/SQL and shell scripting with KSH/Bash.

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.
• 5+ years of experience as an Oracle DBA.
• Experience with PostgreSQL and/or MySQL.
• Experience with database support in IaaS or PaaS.
• Experience with Data Guard and Golden Gate or SharePlex software.
• Experience with PaaS/IaaS solutions in Azure or IBM Cloud.
• Working experience with Data Bricks and Azure Data Lake.
• Exposure to ADX (Azure Data Explorer) and ADF (Azure Data Factory).
• 5+ years of experience developing, troubleshooting and tuning Microsoft SQL.
• 5+ years of high volume, high profile, enterprise database operations experience.
• 5+ years of experience creating scripts (vbscript, Powershell, or shell) in a professional environment.
• Real work experience within a data warehouse environment.
• Experience with Active Directory domains, account administration, and Windows security.
• Airline industry experience.

Skills, Licenses & Certifications

• Experience and understanding of various SQL Server features (i.e. SSIS, SSAS, SSRS, XML).
• Experience with writing deployment scripts or deployment packages (executable) for various target environments like development, test and production.
• Experience with SQL Server Agent Jobs and its troubleshooting.
• Experience managing database assets within a source control system (i.e. TFS, Perforce, SVN, CVS, Visual Source Safe).
• A strong understanding of how the SQL Server database engine works, including but not limited to: Physical storage, indexing, physical database design best practices, and a good understanding of the Query Optimizer.
• A solid understanding of the software development lifecycle and, specifically, what activities and artifacts a database developer has in each part of that lifecycle.
• Experience with tools offered by Red Gate, Quest software, Embarcadero and/or Erwin etc.
• Detail-oriented personality with a strong desire to develop and document processes and tools.
• Demonstrated ability to multi-task, prioritize and ensure tasks are completed on schedule.

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