Db2 Mainframe DBA

Compunnel, Inc.; Merrimack (NH); On-site; USD 110,000 - 140,000; Full time

Job summary

A leading tech company is seeking an experienced Db2 Mainframe Database Administrator in Merrimack, NH. This role involves providing end-to-end support for large-scale Db2 z/OS environments, including database design, maintenance, and performance tuning. The ideal candidate will have over 10 years of experience in Db2 administration, strong SQL skills, and expertise in replication tools. This position requires continuous on-call support and collaboration with various teams.

Qualifications

• Minimum 10+ years of experience in Db2 z/OS Database Administration within large, complex environments.
• Strong proficiency in SQL, REXX, JCL, and COBOL.
• Experience in performance tuning, database security, and access management.

Responsibilities

• Provide application database and replication support for a large Db2 z/OS sysplex environment.
• Perform database maintenance, including utilities management.
• Review SQL and programs for compliance with standards and optimize performance.
• Support replication between Db2 and Oracle using IBM IIDR tools.
• Deliver 24x7 on-call support for critical database operations.
• Collaborate with teams to ensure secure and efficient database architecture.
• Contribute to performance tuning and access management strategies.

Skills

Db2 z/OS Database Administration

SQL

REXX

JCL

COBOL

IBM IIDR replication tools (Q Replication and/or CDC Replication)

Performance tuning

Database security

Access management

Education

Bachelor’s degree in Computer Science or equivalent

Tools

CA Database Tools

Job description

We are seeking an experienced Db2 Mainframe Database Administrator to provide end-to-end support for large-scale Db2 z/OS environments.

This role involves physical database design, deployment, replication, performance tuning, and security management, ensuring optimal database operations and reliability.

Key Responsibilities

• Provide application database and replication support for a large Db2 z/OS sysplex environment.
• Perform database maintenance, including utilities management.
• Review SQL and programs for compliance with standards and optimize performance.
• Support replication between Db2 and Oracle using IBM IIDR tools (Q Replication and/or CDC Replication).
• Deliver 24x7 on-call support for critical database operations.
• Collaborate with teams to ensure secure and efficient database architecture.
• Contribute to performance tuning and access management strategies.

Required Qualifications

• Bachelor’s degree in Computer Science or equivalent.
• Minimum 10+ years of experience in Db2 z/OS Database Administration within large, complex environments.
• Expertise in IBM IIDR replication tools (Q Replication and/or CDC Replication).
• Strong proficiency in SQL, REXX, JCL, and COBOL.
• Working knowledge of CA Database Tools.
• Experience in performance tuning, database security, and access management.
• Exposure to distributed database technologies and cloud environments.
• Brokerage back-office knowledge is a plus.