Mainframe DB2 z/OS DBA | Performance & Production Support

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