Overview
Skills
Job Details
Role: Mainframe DB2 DBA
Job Description:
We are seeking an experienced Mainframe DB2 DBA to manage and support DB2 databases on IBM z/OS mainframe systems. The role involves performance tuning, backup and recovery, database design, and ensuring high availability and data integrity across critical applications.
Key Responsibilities:
Administer and support DB2 databases on z/OS.
Perform database installations, upgrades, patches, and migrations.
Monitor database performance and implement tuning as needed.
Create and manage database objects (tables, indexes, views, etc.).
Implement and test backup and recovery procedures using tools like IBM DB2 utilities and HPU.
Collaborate with application developers and system teams for database design and optimization.
Ensure compliance with security and data governance policies.
Qualifications:
Bachelor's degree in Computer Science or related field.
5+ years of experience as a DB2 DBA on mainframe (z/OS).
Strong knowledge of DB2 utilities (RUNSTATS, REORG, LOAD, UNLOAD, etc.).
Proficiency in JCL, TSO/ISPF, and SQL.
Experience with performance monitoring tools (e.g., OMEGAMON, BMC, CA tools).
Strong analytical and problem-solving skills.