Mainframe Database Administrator (DB2/zOS Consultant)

Job Description

Job 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

Hybrid remote