Senior DB2 z/OS DBA — Performance & Reliability Leader

Ethereum Technologies; Salt Lake City (UT); On-site; USD 110,000 - 140,000; Full time

Job summary

Ethereum Technologies is seeking an experienced Mainframe DB2 DBA to join our enterprise database team in Salt Lake City. You will ensure the performance, availability, security, and reliability of IBM DB2 for z/OS environments, collaborating with application teams, QA, DevOps, offshore resources, and business stakeholders.

Your responsibilities include designing and administering DB2 databases, tuning performance, executing utilities, managing security and DR, and mentoring junior team members

Qualifications

• Bachelor’s degree in computer science or related field, or equivalent experience.
• 6+ years of hands-on Mainframe Database Administration.
• Strong expertise in IBM DB2 for z/OS administration and support.
• Experience with DB2 utilities including RUNSTATS, REORG, COPY, RECOVER, LOAD, and UNLOAD.
• Experience tuning SQL and resolving access path and performance issues.
• Working knowledge of COBOL, JCL, CICS, and VSAM.
• Experience supporting multiple enterprise applications in large production environments.
• Experience coordinating with offshore teams and providing technical guidance.

Responsibilities

• Design, create, and maintain DB2 databases, tablespaces, indexes, views, storage groups, and related objects.
• Translate logical data models into efficient physical database designs.
• Execute DDL implementations and manage schema changes through complex ALTER activities.
• Implement and maintain Universal Table Spaces (PBG/PBR).
• Design indexing strategies to optimize access paths and overall database performance.
• Analyze, troubleshoot, and resolve DB2 performance issues.
• Monitor SQL performance, locking conflicts, buffer pools, and access path efficiencies.
• Review EXPLAIN output and recommend performance improvements.
• Optimize complex SQL queries to reduce CPU consumption and improve application response times.
• Leverage Real Time Statistics (RTS) to proactively manage database health.
• Execute and monitor DB2 utilities including RUNSTATS, REORG, COPY, RECOVER, LOAD, and UNLOAD.
• Manage VSAM datasets, storage allocation, PRIQTY, and SECQTY settings.
• Develop and maintain JCL and REXX automation scripts.
• Support production incidents, perform root cause analysis, and drive issue resolution.
• Manage DB2 command-level operations and database statuses.
• Administer DB2 security through GRANT and REVOKE processes.
• Support audit, compliance, and enterprise security standards.
• Develop and execute backup, recovery, and disaster recovery strategies.
• Manage image copies, logs, and restoration procedures.
• Participate in production readiness reviews and recovery testing exercises.
• Serve as the primary onsite DB2 DBA point of contact.
• Collaborate with developers, architects, SMEs, QA teams, and offshore resources.
• Provide technical mentorship and knowledge transfer to team members.
• Support releases, deployments, upgrades, and modernization initiatives.
• Document operational procedures, recovery plans, and database standards.

Skills

DB2 for z/OS

SQL tuning

Mainframe administration

COBOL

JCL

CICS

VSAM

Education

Bachelor's degree in Computer Science or related field

Equivalent experience considered

Tools

RUNSTATS

REORG

COPY

RECOVER

LOAD

UNLOAD

Endevor

Job description

Ethereum Technologies is seeking an experienced Mainframe DB2 DBA to join our enterprise database team in Salt Lake City. You will ensure the performance, availability, security, and reliability of IBM DB2 for z/OS environments, collaborating with application teams, QA, DevOps, offshore resources, and business stakeholders.

Your responsibilities include designing and administering DB2 databases, tuning performance, executing utilities, managing security and DR, and mentoring junior team members