Delta Air Lines, Inc. Senior Database Administrator in Atlanta, Georgia

* This position can be located in Atlanta, GA or Minneapolis, MN*

Join Delta IT on our journey to becoming the best IT organization in the airline industry.

Delta IT is on a journey of transformation. We are changing the way we do business from top to bottom. As thought-leaders within Delta, we strive to create meaningful and innovative solutions and are looking for team members to help us realize our vision.

Delta IT employees are thinkers, doers, innovators.

We are proactive.

We are collaborative.

We deliver impact to our customers.

Join us on our transformation journey in becoming a world-class IT organization at the world's best airline!

YOUR RESPONSIBILITIES IN THIS ROLE

Your primary function is to work with the database service provider and Delta's application teams to ensure a stable and highly available/performant mainframe database environment

You'll work with the service provider to maximize database availability and performance to meet or exceed defined SLA's. Responsible for working with Delta's database service provider and application teams to ensure a stable and highly available/performant mainframe database environment.

  • Minimum 5 Years' experience administering DB2/z databases in an enterprise environment

  • Strong experience with leading major database projects, including setting direction and identifying & implementing project tasks

  • Proven track record of administering databases in DB2/z versions 10, 11. Version 12 helpful

  • Minimum 5 years' experience administering IMS/z databases in an enterprise environment

  • Strong experience with logical relationships, HDAM performance and tuning, sparse indexes, DBRC (especially block-level sharing) and IMS-Plex

  • BN Interface knowledge helpful

  • Proven track record of administering databases in IMS/z version 14

  • Strong experience with DB2/z and IMS/z support tools and processes including BMC, Insight, FileAid, Vision Inquiry, DAT, IBM DB2 Tools, Query Monitor

  • Strong experience with evaluating DB2 and IMS performance issues (including SQL Performance) and recommending improvements

  • Strong experience with troubleshooting, resolving and documenting database issues

  • Strong understanding of logical database design (i.e., third normal form) and ability to translate logical design to physical design

  • Experience in writing and updating REXX routines

  • Knowledge of COBOL, QuickJob, SAS, Assembler and ISPF Dialog Components

  • Familiarity with DB2/z database replication tools

  • SYSPROG experience very helpful

  • Proven track record of administering databases in a challenging enterprise environment

  • Experience and ability to provide tier 2 / 3 database support/coverage environment

  • Ability to work with, and provide direction to, the database service provider

  • Ability to provide technical direction to others, including application developers

  • Ability to set strategic direction and identify tasks to implement the solution

  • Ability and willingness to follow established IT / DBA policies and procedures

  • Ability to provide database education to groups of people helpful

WHAT ARE WE LOOKING FOR? / WHAT EXPERIENCE DO YOU NEED?

  • Minimum 5 Years' experience administering DB2/z databases in an enterprise environment

  • Strong experience with leading major database projects, including setting direction and identifying & implementing project tasks

  • Proven track record of administering databases in DB2/z versions 10, 11. Version 12 helpful

  • Minimum 5 years' experience administering IMS/z databases in an enterprise environment

  • Strong experience with logical relationships, HDAM performance and tuning, sparse indexes, DBRC (especially block-level sharing) and IMS-Plex

  • BN Interface knowledge helpful

  • Proven track record of administering databases in IMS/z version 14

  • Strong experience with DB2/z and IMS/z support tools and processes including BMC, Insight, FileAid, Vision Inquiry, DAT, IBM DB2 Tools, Query Monitor

  • Strong experience with evaluating DB2 and IMS performance issues (including SQL Performance) and recommending improvements

  • Strong experience with troubleshooting, resolving and documenting database issues

  • Strong understanding of logical database design (i.e., third normal form) and ability to translate logical design to physical design

  • Experience in writing and updating REXX routines

  • Knowledge of COBOL, QuickJob, SAS, Assembler and ISPF Dialog Components

  • Familiarity with DB2/z database replication tools

  • SYSPROG experience very helpful

  • Proven track record of administering databases in a challenging enterprise environment

  • Experience and ability to provide tier 2 / 3 database support/coverage environment

  • Ability to work with, and provide direction to, the database service provider

  • Ability to provide technical direction to others, including application developers

  • Ability to set strategic direction and identify tasks to implement the solution

  • Ability and willingness to follow established IT / DBA policies and procedures

  • Ability to provide database education to groups of people helpful

WHAT ELSE?

The ability to provide database education to large groups of application developers or other resources

Delta Air Lines develops both strategic and tactical plans that create a safety-conscious environment resulting in employee safety and well-being.