Mainframe Database Administrator (DB2/zOS Consultant)

Job Description

Job DescriptionJob Title: Sr. Database Administrator (Consultant)
Location: Atlanta, GA (Hybrid)
Duration: 12+ Months
Visa: USC/GC/GC-EAD only
Mode of Interview: Virtual

About the Role
Delta Airlines is looking for a Sr. Database Administrator (DBA) to join their IT team. The role focuses on managing, optimizing, and supporting mainframe database systems to ensure high performance, reliability, and compliance. This is a long-term consulting role with opportunities to work on transformation projects.

Key Responsibilities

• Manage and maintain IBM DB2 databases on z/OS mainframe.
• Create and manage database objects (tables, indexes, table spaces).
• Perform data operations (loading, unloading, reorganizing) using DB2 utilities.
• Implement backup, recovery, and disaster recovery strategies.
• Monitor and tune database performance to resolve bottlenecks.
• Use tools like RUNSTATS for database statistics and query optimization.
• Collaborate with application teams to design schema changes and new features.
• Provide guidance on database technologies and enhancements.
• Oversee external DBA/system programming teams during installations and upgrades.
• Ensure compliance with audits (SOX) and data security best practices.
• Participate in disaster recovery planning and testing.
• Stay updated on new database features and lifecycle changes.

Required Qualifications

• Bachelor’s degree in Computer Science, IT, or equivalent experience.
• 8+ years’ experience with z/Db2, IMS DB/DC, and/or ADABAS.
• Strong expertise in IBM DB2 administration on z/OS mainframe.
• Experience with replication tools (e.g., IBM IIDR).
• Knowledge of zConnect Enterprise Edition (zCEE) API framework.
• Proficiency in SQL, indexing, partitioning, data sharing, and tuning.
• Hands-on with JCL (Job Control Language) and mainframe OS concepts.
• Strong troubleshooting and problem-solving skills.
• Experience in database security, backups, recovery, and DR planning.

Preferred Skills (Nice to Have)

• Certifications in DB2 or mainframe database technologies.
• Familiarity with service level management and vendor coordination.
• Experience managing software upgrades and conversions.
• Strong collaboration skills with internal and external teams.
• Flexibility to provide on-call production support.

Powered by JazzHR

wEskhGjaZC