Senior Database Analyst / Database Systems Programmer (zDb2)

Every year, nearly 200 million travelers trust our client to get them where they're going. Take your career to new heights by working for this longstanding leader in air travel that services more worldwide destinations than any other airline.

We are looking for a Senior Database Analyst / Database Systems Programmer to join our team for a long-term contract in Hapeville, GA (hybrid).

Contract Duration : 12 months

Required Skills & Experience

• 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.

Bachelor’s degree in Computer Science, Information Technology, or related field (or equivalent experience).

Desired Skills & Experience

Relevant certifications in DB2 or related database technologies are a plus.

What You will Be Doing

Database Administration & Maintenance :

Implement database backup and recovery strategies to ensure data availability and disaster recovery.

Performance Monitoring & Optimization :

Utilize tools like RUNSTATS to maintain accurate database statistics for query optimization.

Collaboration & Consultation :

Collaborate with application developers to design and implement database schema changes.

Software & System Management :

Proactively monitor database platforms for high availability, identifying root causes and correcting issues.

Risk Management & Compliance :

Participate in audit reviews, including completing quarterly SOX audits and ensuring compliance with regulations.

Disaster Recovery & Business Continuity :

Participate in disaster recovery planning and testing, ensuring database resilience in case of system failures.

Technology Strategy & Lifecycle Management :

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