Overview
Skills
Job Details
Job Description:
- We are seeking an experienced DB2 z/OS DBA to manage the full lifecycle of mainframe DB2 databases, including design, implementation, maintenance, and decommissioning.
- The role involves supporting DB2 replication using IIDR/CDC, performing database upgrades, and ensuring high availability, performance, and security of production systems.
Key Responsibilities:
Manage DB2 databases on z/OS, including replication, backup, and recovery.
Plan subscriptions and log retention policies; monitor databases using Splunk dashboards.
Implement database security using ACF2 and RACF; collaborate with application teams.
Perform performance tuning and SQL optimization in coordination with development teams.
Support DB2 product upgrades, audits (SOX/Database/Control), and compliance reviews.
Participate in 24x7 on-call rotation and handle SEV1 production issues.
Build and maintain documentation and reports for database operations and health.
Required Skills & Experience:
5+ years of DB2 DBA experience on z/OS; 1+ year with data replication (IIDR/CDC).
Strong knowledge of InfoSphere CDC, DB2 Utilities (BMC), VSAM, IDCAMS, and Endevor.
Experience with BMC tools: Change Manager, Catalog Manager, Mainview, SQL Performance.
Broad understanding of ACF2/RACF security, backup/recovery strategies, and database performance tuning.
Familiarity with ITSM processes and tools like BMC Remedy.
Excellent communication and collaboration skills; job stability preferred.
Benefits:
- The Company offers the following benefits for this position, subject to applicable eligibility requirements: medical insurance, dental insurance, vision insurance, 401(k) retirement plan, life insurance, long-term disability insurance, short-term disability insurance, paid parking/public transportation, (paid time, paid sick and safe time, hours of paid vacation time, weeks of paid parental leave, paid holidays annually - AS Applicable).