Mainframe Database Administrator (DB2/zOS Consultant)

Atlanta, GA
Contracted
Experienced
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.
Share

Apply for this position

Required*
Apply with Indeed
We've received your resume. Click here to update it.
Attach resume or Paste resume
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

Human Check*