Mainframe Database Administrator (DB2/zOS Consultant)
Job Description
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
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.
- 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 .
- 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
Recommended Jobs
Analyst, Business Systems III
Mission Summary: Senior-level system analyst position focusing on business analysis, system and project engineering for existing and new systems for the Information Technology Department. Thi…
Cloud Developer
Role: Cloud Developer Location: Alpharetta, GA or Berkeley Heights, NJ Duration: 12+ Months Experience Needed: 10+ Years Position Summary: As a Cloud Developer with a focus …
IT/OT Sr. Engineer
Mission Summary: GPI is hiring an experienced Operations Technology (OT) Engineer. The OT Engineer will be responsible for supporting and implementing Industrial Control Systems in accordance…
HVAC Jr. Mechanic
Lane Valente Industries is a Leading International construction and facility maintenance company with offices throughout the U.S. and Canada. We have a strong in-house group of field technician…
Calypso Developer
Req ID: 335734 NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organi…
Senior Backend Data Engineer
About Us Join us on our mission to build the leading onchain trading super-app. By tightly linking alpha discovery with 1-click trading, we seek to empower crypto traders to better filter through …
Admin / marketing assistance needed for a bunch of financial nerds
Job Description Job Description Benefits: ~401(k) ~401(k) matching ~ Health insurance ~ Opportunity for advancement ~ Training & development Sozo Private Wealth is a holistic financ…
Registered Respiratory Therapist - NICU - 3731
Job Description: Job Title: Registered Respiratory Therapist – NICU Location: Plano, TX, 75093 Shift Schedule: 7:00 AM – 7:00 PM & 7:00 PM – 7:00 AM (Includes rotating weekends and holidays…
Advisor Development Consultant
Job Description Job Description Position Title: Advisor Development Consultant Reports to: Partner Department: Annuity Sales Location: Fully remote position Classification: Full-…
Interior designer / drafter
Apollo Technical has an immediate need for a Interior designer / drafter in the Lawrenceville GA area Join our client's dynamic team as a meticulous Interior drafter/designer, where your technical…