DB2 DBA

Heitmeyer Consulting; United States; On-site; USD 120,000 - 180,000; Full time

Job summary

Heitmeyer Consulting seeks an experienced DB2 z/OS Database Administrator to maintain and support a longstanding IBM mainframe DB2 environment. The role combines Systems DBA and Application DBA duties across multiple mainframe environments.

The ideal candidate will manage DB2 on z/OS, review SQL, implement performance improvements, and assist with upgrades. Exposure to ISPW and MainView is preferred; distributed DB2/Linux experience is a plus as modernization progresses.

Qualifications

• Significant hands-on experience administering IBM DB2 on z/OS in a production mainframe environment.
• Strong understanding of z/OS mainframe architecture and DB2 systems administration.
• Experience managing DB2 databases, tables, indexes, utilities, and database environments.
• Experience with JCL and mainframe batch processing.
• Strong SQL skills, including SQL review, troubleshooting, performance tuning, and query optimization.
• Strong knowledge of DB2 performance tuning, indexing strategies, access paths, and explain analysis.
• Experience supporting application development teams from a database perspective.
• Experience with DB2 upgrades, maintenance, monitoring, and related database administration tools.
• Strong analytical and troubleshooting skills.
• Ability to work independently and take ownership of a mature production database environment.
• Dependable and comfortable supporting business-critical production systems.

Responsibilities

• Administer, maintain, and support DB2 databases within an IBM z/OS mainframe environment across production, development, testing, and other environments.
• Perform DB2 systems and database administration, including database and table creation, maintenance, monitoring, troubleshooting, and performance optimization.
• Support DB2 upgrades, related database tooling upgrades, and ISPW upgrades.
• Create, maintain, and execute JCL and other mainframe database-related jobs.
• Utilize IBM and BMC database administration and monitoring tools to manage and monitor the DB2 environment.
• Review SQL developed by application teams for standards, performance, and best practices.
• Analyze SQL access paths and EXPLAIN results and provide recommendations related to query performance.
• Evaluate and recommend appropriate indexing strategies, table structures, and database design changes.
• Partner with application developers to troubleshoot database and SQL-related performance issues.
• Support deployment of application changes by reviewing database impacts, SQL, tables, indexing, and overall performance considerations.
• Perform problem analysis and resolution related to DB2 databases and the mainframe environment.
• Participate in an after-hours/on-call production support rotation as needed.
• Support ongoing modernization efforts as applications gradually transition from the mainframe to distributed environments.

Skills

DB2 on z/OS expert

SQL proficiency

Production database ownership

Analytical troubleshooting

Tools

JCL

MainView

ISPW

DB2 utilities

BMC tools

Job description

Heitmeyer Consulting currently has an opportunity for a DB2 / z/OS DBA. This position is primarily focused on maintaining and supporting the organization's existing mainframe DB2 environment. The role is approximately 50% systems DBA and 50% application DBA support.

Position Overview

Seeking an experienced DB2 z/OS Database Administrator to support and maintain a longstanding IBM mainframe environment. This role will serve as both a Systems DBA and Application DBA, with responsibility for the ongoing administration, maintenance, performance, and support of DB2 databases and related tools across multiple mainframe environments.

The ideal candidate will bring deep, hands-on experience working with DB2 on z/OS and will be comfortable supporting both the underlying database environment and application development teams. This is not an application development role.

While the immediate focus is on DB2 within the mainframe environment, experience with Microsoft SQL Server, distributed DB2, Linux, or other distributed database technologies is beneficial as the organization continues to modernize its technology environment.

Responsibilities:

• Administer, maintain, and support DB2 databases within an IBM z/OS mainframe environment across production, development, testing, and other environments.
• Perform DB2 systems and database administration, including database and table creation, maintenance, monitoring, troubleshooting, and performance optimization.
• Support DB2 upgrades, related database tooling upgrades, and ISPW upgrades.
• Create, maintain, and execute JCL and other mainframe database-related jobs.
• Utilize IBM and BMC database administration and monitoring tools to manage and monitor the DB2 environment.
• Review SQL developed by application teams for standards, performance, and best practices.
• Analyze SQL access paths and EXPLAIN results and provide recommendations related to query performance.
• Evaluate and recommend appropriate indexing strategies, table structures, and database design changes.
• Partner with application developers to troubleshoot database and SQL-related performance issues.
• Support deployment of application changes by reviewing database impacts, SQL, tables, indexing, and overall performance considerations.
• Perform problem analysis and resolution related to DB2 databases and the mainframe environment.
• Participate in an after-hours/on-call production support rotation as needed.
• Support ongoing modernization efforts as applications gradually transition from the mainframe to distributed environments.

Required Qualifications:

• Significant hands-on experience administering IBM DB2 on z/OS in a production mainframe environment.
• Strong understanding of z/OS mainframe architecture and DB2 systems administration.
• Experience managing DB2 databases, tables, indexes, utilities, and database environments.
• Experience with JCL and mainframe batch processing.
• Strong SQL skills, including SQL review, troubleshooting, performance tuning, and query optimization.
• Strong knowledge of DB2 performance tuning, indexing strategies, access paths, and explain analysis.
• Experience supporting application development teams from a database perspective.
• Experience with DB2 upgrades, maintenance, monitoring, and related database administration tools.
• Strong analytical and troubleshooting skills.
• Ability to work independently and take ownership of a mature production database environment.
• Dependable and comfortable supporting business-critical production systems.

Preferred Qualifications

• 10+ years of IBM mainframe / DB2 z/OS experience preferred.
• Experience with BMC DB2 administration and monitoring tools, including MainView or similar tools.
• Experience with ISPW.
• Experience with distributed DB2 and/or Linux-based database environments.
• Banking or financial services experience.
• Experience supporting organizations transitioning applications from mainframe to distributed platforms.

Heitmeyer Consulting is an equal opportunity employer, and we encourage all qualified candidates to apply. Qualified applicants will be considered without regard to minority status, gender, disability, veteran status, or any other characteristic protected by law.