"Alerted.org

How you'll help us Keep Climbing (overview & key responsibilities)

At Delta Air Lines, connection is at the heart of everything we do and guides our every action. We strive to welcome and care for all of our customers during their travels with us and aim to deliver an elevated experience.

Delta is focused on sustaining a strong IT operation, growing our capabilities, and maximizing optimization across each of our tech hubs to elevate the travel experience for our customers and empower our 90,000 Delta people.

We’re committed to fostering innovation, and we’re excited to invite you to be part of our journey as we shape the future of technology at the world’s best airline!

We

are seeking an experienced Database Analyst or Database Systems Programmer with

a minimum of 8 years of experience working with zDb2. The ideal candidate will

have strong expertise in mainframe database technologies, including z/Db2, IMS

DB/DC, and/or ADABAS. This role involves overseeing database systems,

optimizing performance, managing upgrades, and supporting application teams to

implement new technologies that align with business goals.

Key

Responsibilities:

+ DatabaseAdministration & Maintenance:

+ Manage and maintain IBM DB2 databases on thez/OS mainframe platform.

+ Create and manage database objects, such astables, indexes, and table spaces.

+ Perform data manipulation operations likeloading, unloading, and reorganizing data using DB2 utilities.

+ Implement database backup and recoverystrategies to ensure data availability and disaster recovery

+ PerformanceMonitoring & Optimization:

+ Monitor database performance metrics toidentify and resolve bottlenecks.

+ Perform database tuning to enhance queryperformance and maintain optimal system functioning.

+ Utilize tools like RUNSTATS to maintainaccurate database statistics for query optimization.

+ Collaboration &Consultation:

+ Develop and maintain effective communicationwith application teams regarding infrastructure technology projects androadmaps.

+ Serve as a consultant to application teamsand business users on new technologies and system enhancements.

+ Collaborate with application developers todesign and implement database schema changes.

+ Software & SystemManagement:

+ Oversee external DBA teams and systemsprogrammers during the installation and support of mainframe database software.

+ Facilitate service level management,including change management, incident, and problem management.

+ Stay current with software upgrades, ensuringtimely implementation of new features that enhance Delta applications

+ Work with external vendor teams to ensuresmooth conversions during software updates and releases.

+ Proactively monitor database platforms forhigh availability, identifying root causes and correcting issues.

+ Risk Management &Compliance:

+ Keep management informed of risks and developmitigation strategies to reduce potential risks.

+ Participate in audit reviews, includingcompleting quarterly SOX audits and ensuring compliance with regulations.

+ Disaster Recovery& Business Continuity:

+ Participate in disaster recovery planning andtesting, ensuring database resilience in case of system failures.

+ Technology Strategy& Lifecycle Management:

+ Stay up-to-date on advancements in databasetechnologies and lifecycle management, particularly focusing on deprecatedfeatures and mitigation planning.

+ Work Environment:

+ Full-time, with on-call support and responsibilities for managing database platforms and applications.

+ Collaboration with various internal and external teams to ensure high performance and availability of database systems.

What you need to succeed (minimum qualifications)

+ Minimum of 8 years of experience with zDb2, IMS DB/DC, and/or ADABAS.

+ Proficiency with replication software such as IIDR – IBM Infosphere Data Replication Suite

+ Strong understanding of zConnect Enterprise Edition (zCEE) API framework.

+ Expertise in IBM DB2 database administration on z/OS mainframe platforms.

+ In-depth knowledge of SQL, DB2 partitioning, indexing, data sharing, and performance tuning techniques.

+ Experience with mainframe operating system concepts and Job Control Language (JCL).

+ Familiarity with data security best practices and compliance regulations.

+ Ability to troubleshoot and resolve complex database-related issues.

+ Strong experience in managing database backups, recovery procedures, and disaster recovery planning.

+ Consistently prioritizes safety and security of self, others, and personal data.

+ Embraces diverse people, thinking, and styles.

+ Possesses a high school diploma, GED, or high school equivalency.

+ Is at least 18 years of age and has authorization to work in the United States.

What will give you a competitive edge (preferred qualifications)

+ Knowledge of IBM DB2,IMS DB/DC, and ADABAS database products.

+ Familiarity withservice level management, change management, and incident resolution.

+ Experience workingwith external vendors and managing software upgrades.

+ Bachelor’s degree inComputer Science, Information Technology, or related field (or equivalentexperience).

+ Relevantcertifications in DB2 or related database technologies are a plus.

Benefits and Perks to Help You Keep Climbing

Our culture is rooted in a shared dedication to living our values – Care, Integrity, Resilience and Servant Leadership – every day, in everything we do. At Delta, our people are our success. At the heart of what we offer is our focus on Sharing Success with Delta employees. Exploring a career at Delta gives you a chance to see the world while earning great compensation and benefits to help you keep climbing along the way:

+ Competitive salary, industry-leading profit sharing program, and performance incentives

+ 401(k) with generous company contributions up to 9%

+ New hires are eligible for up to 2-weeks of vacation. This is earned for use in the following vacation year (April 1 – March 31)

+ In addition to vacation, new hires are eligible for up to 56 hours of paid personal time within a 12-month period

+ 10 paid holidays per calendar year

+ Birthing parents are eligible for 12-weeks of paid maternity/parental leave

+ Non-birthing parents are eligible for 2-weeks of paid parental leave

+ Comprehensive health benefits including medical, dental, vision, short/long term disability and life insurance benefits

+ Family care assistance through fertility support, surrogacy and adoption assistance, lactation support, subsidized back-up care, and programs that help with loved ones in all stages

+ Holistic Wellbeing programs to support physical, emotional, social, and financial health, including access to an employee assistance program offering support for you and anyone in your household, free financial coaching, and extensive resources supporting mental health

+ Domestic and International space-available flight privileges for employees and eligible family members

+ Career development programs to achieve your long-term career goals

+ World-wide partnerships to engage in community service and innovative goals created to focus on sustainability and reducing our carbon footprint

+ Business Resource Groups created to connect employees with common interests to promote inclusion, provide perspective and help implement strategies

+ Recognition rewards and awards through the platform Unstoppable Together

+ Access to over 500 discounts, specialty savings and voluntary benefits through Deltaperks such as car and hotel rentals and auto, home, and pet insurance, legal services, and childcare

Delta Air Lines, Inc. is an Equal Employment Opportunity / Affirmative Action employer and provides reasonable accommodation in its application process for qualified individuals with disabilities and disabled veterans. If you are a qualified individual, you may request a reasonable accommodation if you are unable or limited in your ability to access job openings through this site, apply for jobs through Delta’s online system, or at any point in the selection process. To request a reasonable accommodation, please click here