Principal Mainframe DB2 Database Administrator

Technologix IT Inc; United States; On-site; USD 120,000 - 180,000; Full time

Job summary

Technologix IT Inc. in the United States is seeking a seasoned Mainframe DB2 DBA to support installation, modification, maintenance, testing and performance tuning across z/OS and LUW platforms.

You will lead complex DB2 environments, provide senior-level guidance, design data sharing and connectivity, and optimize SQL with EXPLAIN. You will implement replication and ensure high availability, disaster recovery, and adherence to ITIL/ITSM processes.

Qualifications

• 4+ years of progressive experience as a mainframe DB2 DBA.
• Extensive experience in DB2 LUW environments alongside z/OS knowledge.
• Proven expertise with DB2 performance monitoring and tuning tools.
• Strong knowledge of DB2 Connect for remote access and connectivity.

Responsibilities

• Act as Principal/Lead DBA for complex DB2 environments on z/OS and LUW.
• DB2 database design, configuration, review, and administration.
• Maintain and operate DB2 software and tools.
• Diagnose and resolve DB2 SQL errors and reason codes.
• Implement DB2 Data Sharing.
• Design and manage DB2 Connect configurations for distributed applications.

Skills

DB2 for z/OS

DB2 LUW

Performance tuning

SQL & EXPLAIN

DB2 Connect

Data Sharing

Q-Replication

CDC Replication

CICS

MQ

ITIL/ITSM

SDLC – Waterfall/Agile

Communication

Independent work

Tools

DB2 Tools

EXPLAIN tooling

IBM DB2 Platform

CICS tooling

MQ tooling

Job description

The Mainframe DB2 DBA provides support with installation, modification, maintenance, testing, analysis, and performance of applications using mainframe DB2 databases.

Scope of Responsibilities:

• Act as a Principal/Lead DBA for complexDB2 environments on both z/OS and Distributed (LUW - Linux, Unix, Windows) platforms, providing senior-level guidance and mentorship.
• DB2 database design, configuration, review, and administration.
• Maintain and operateDB2 software, and tools.
• Diagnose and resolveDB2 reason codes and SQL errors.
• Implementing DB2 Data-Sharing.
• Design, implement, and manage DB2 Connect configurations to enable seamless communication between distributed applications and the mainframe DB2 subsystem.
• Perform advanced, end-to-end performance tuning across application, database, and system levels, including detailed SQL query optimization and access path analysis (using tools like EXPLAIN).
• Troubleshoot software defect or usage issues.
• Work in a software development environment following SDLC of waterfall and agile/scrum methodologies.
• Provide on-call break/fix database support and respond within the agreed SLA.
• Support off-shift implementations of mainframe releases.
• Support Disaster Recovery exercises.
• Manage changes within standard control processes and mechanisms using ITIL/ITSM practices.
• Produce clear technical documentation and conform to any audit requirements.
• DB2 v13 on Z/OS Experience a must
• Experience supporting and troubleshooting large DB2 tables/environments

Requirements:

• Must have 4 years of progressive experience as a mainframe DB2 DBA.
• Extensive, demonstrable experience in the administration and architecture of DB2 for LUW (Linux, Unix, Windows) environments, complementing the z/OS experience..
• Proven expertise in using DB2 performance monitoring and tuning tools (both IBM and third-party) to manage buffer pools, I/O operations, locking mechanisms, and run time statistics.
• Solid knowledge of cross-platform database connectivity, specifically DB2 Connect and its configuration for remote client access.
• Deep understanding of DB2 Data Sharing principles, setup, and maintenance for high availability and scalability.
• Functional knowledge of DB2 internals, tools, and their usage.
• Understanding of replication services(Q-Replication, CDC Replication).
• Functional knowledge of database interfaces (connection/batch/CICS/DB2/MQ/distributed).
• Functional knowledge of z/OS systems.
• Operating system general knowledge for Windows/Unix/Linux.
• Excellent communications and interpersonal skills.
• Ability to work unsupervised and independently seek out and interact with colleagues and outside vendors.
• Excellent problem-solving skills.
• Capability to shuffle priorities in response to a changing workload.
• Flexibility to keep up with changing technology.