Mainframe DB2 Database Administrator

Overview

On Site
Depends on Experience
Full Time
No Travel Required
Unable to Provide Sponsorship

Skills

DB2 DBA
Z/OS

Job Details

Role : Mainframe DB2 Database Administrator
Location : Salisbury, NC/Boston, MA/Frisco, TX


The DB2 DBA on z/OS is responsible for the administration, performance tuning, and maintenance of IBM DB2 databases running on the z/OS mainframe platform. This role ensures data integrity, availability, and security across mission-critical systems and collaborates with cross-functional teams to support business applications.

Technical Expertise:
Strong experience with DB2 for z/OS (versions 10 through 12).
Proficiency in JCL, TSO/ISPF, VSAM, and DB2 utilities.
Familiarity with SMP/E, RACF, and IBM mainframe tools.
Knowledge of IBM MQ for z/OS, IMS, or CICS connectivity with DB2. 
Experience with DB2 DDF (Distributed Data Facility) and remote connectivity. 
 

Experience:
5+ years of hands-on experience in DB2 database administration on z/OS.
Experience with performance tuning, disaster recovery, and automation.

Educaion & Certifications:
IBM Certified Database Administrator – DB2 for z/OS is a plus
 

Key Responsibilities:

Database Installation & Configuration:
Set up and manage DB2 subsystems, buffer pools, and storage groups.
Performance Tuning & Optimization:
Monitor database performance and implement tuning measures 
Optimize SQL queries and indexing strategies.
Analyze workload and adjust system parameters for efficiency.
Backup, Recovery & Disaster Planning:
Implement and manage backup and recovery procedures.
Develop and test disaster recovery strategies 

Security & Compliance:
Manage user access controls and database security policies.
Ensure compliance with data governance and audit requirements 

Automation & Monitoring:
Automate routine DBA tasks using scripting (e.g., REXX, Shell, Python).
Use monitoring tools to proactively detect and resolve issues 

Collaboration & Support:
Work closely with application developers, system programmers, and infrastructure teams.
Provide support during deployments, upgrades, and troubleshooting 

Documentation & Standards:
Maintain documentation for configurations, procedures, and standards.
Define and enforce database standards and best practices.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Laiba Technologies LLC