Mainframe DBA

Irving, TX - USA

Monthly Salary: Not Disclosed

Posted on: 10 hours ago

Vacancies: 1 Vacancy

Job Summary

Position: Mainframe DBA

Location: Irving TX(Onsite)

Duration: Fulltime

Job Description

Must Have Technical/Functional Skills

Mainframe DB2 DBA manages tunes and secures DB2 databases on IBM z/OS systems handling backup
recovery and performance optimization. Key responsibilities include DDL/DML management utility scheduling
(REORG RUNSTATS) capacity planning and troubleshooting. Required additional skills include COBOL
CICS knowledge SQL JCL and monitoring tools like OPCE.

Roles & Responsibilities

DB2 on Mainframe (Primary Responsibility)
Administer and maintain DB2 for z/OS environments including installation configuration and upgrades.
Perform database tuning performance optimization and SQL query analysis.
Manage backup and recovery strategies including disaster recovery planning and execution.
Perform DB2 utilities management (REORG RUNSTATS COPY LOAD UNLOAD etc.).
Support DB2 subsystem performance buffer pools logging storage and catalog/directory maintenance.
Ensure database availability integrity and security across all mainframe DB2 environments.
Provide production support including incident resolution root-cause analysis and performance troubleshooting.
Work closely with application development teams on schema changes data modeling and SQL guidance.
Implement and maintain automation database monitoring and proactive health checks.

Required

Strong knowledge of DB2 for z/OS internals utilities performance tuning and database administration
best practices.
Experience working with mainframe tools such as ISPF JCL RACF TSO.
Solid understanding of backup/recovery strategies disaster recovery and high availability architecture.
Proficiency in SQL database diagnostics and query tuning.

Preferred

Experience with CICS IMS or mainframe transaction processing environments.
Exposure to data replication technologies.
Knowledge of Db2 Data Sharing sysplex environments or large enterprise deployments.

Position: Mainframe DBA Location: Irving TX(Onsite) Duration: Fulltime Job Description Must Have Technical/Functional Skills Mainframe DB2 DBA manages tunes and secures DB2 databases on IBM z/OS systems handling backup recovery and performance optimization. Key responsibilities include DDL/DML ...