Get new jobs for this search by email

Mainframe Database Analyst Contract/Contract to Hire Atlanta, GA

Job Summary: We are seeking an experienced

Mainframe Database Analyst

or

Database Systems Programmer

with at least

8 years of experience working with z/DB2 . The ideal candidate will bring in-depth expertise in mainframe database technologies including

z/DB2, IMS DB/DC , and/or

ADABAS . This role is critical in overseeing and optimizing database systems, managing software upgrades, supporting application development, and ensuring performance and compliance with business and technical standards.

Key Responsibilities: Database Administration & Maintenance

Manage IBM DB2 databases on the z/OS mainframe platform. Create and maintain database objects (tables, indexes, tablespaces). Perform data loading, unloading, and reorganization using DB2 utilities. Develop and implement database backup, recovery, and disaster recovery strategies. Performance Monitoring & Optimization:

Monitor and analyze database performance to identify and resolve bottlenecks. Tune databases and optimize queries for maximum system efficiency. Use tools like RUNSTATS to maintain accurate statistics for query optimization. Collaboration & Consultation:

Work closely with application development teams to support technology projects and system enhancements. Provide expert consultation on database architecture and performance. Collaborate on schema design and implementation. Software & System Management:

Oversee external DBA and systems programming teams during software installation and support. Manage change, incident, and service level processes. Coordinate with vendors for software upgrades and ensure smooth transitions. Monitor system health to ensure high availability and proactively resolve issues. Risk Management & Compliance:

Communicate potential risks to management and develop mitigation strategies. Support compliance efforts including SOX audit participation and reporting. Ensure adherence to data security and regulatory standards. Disaster Recovery & Business Continuity:

Lead or participate in disaster recovery planning and testing. Ensure database systems can recover effectively from system failures. Technology Strategy & Lifecycle Management:

Keep up to date with advancements in database and mainframe technologies. Evaluate and plan for deprecated feature retirement and lifecycle upgrades.

Required Qualifications:

Minimum 8 years of experience

with

z/DB2 ,

IMS DB/DC , and/or

ADABAS . Proficient in

IBM Infosphere Data Replication (IIDR)

or similar replication tools. Strong knowledge of

zConnect Enterprise Edition (zCEE)

API framework. Deep expertise in

DB2 administration

on z/OS. Strong SQL skills; expertise in partitioning, indexing, performance tuning, and data sharing. Experience with

mainframe operating systems

and

Job Control Language (JCL) . Understanding of

data security best practices

and compliance frameworks. Proven ability to

troubleshoot and resolve

complex database issues. Experience in

backup/recovery

procedures and

disaster recovery planning . Bachelor's degree

in

Computer Science ,

Information Technology , or a related field, or equivalent professional experience.

Preferred Qualifications:

Familiarity with

service level ,

incident , and

change management

processes. Experience working with

external vendors

and managing software lifecycle upgrades. Relevant certifications in

DB2

or related technologies.

Work Environment:

Full-time

role with

on-call support

responsibilities. Requires collaboration with internal application teams and external vendors. Focused on ensuring

high availability ,

performance , and

reliability

of mainframe database environments.

"All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran."