Source description
About the role
DB2 z/OS DBA (Database Administrator) Job Summary Responsible for administration, performance, and availability of DB2 databases on z/OS mainframe systems. The role ensures data integrity, security, and optimal performance in mission-critical enterprise environments. Key Responsibilities Install, configure, and maintain DB2 for z/OS environments Manage database objects (tablespaces, tables, indexes, views) Perform database creation, migration, and upgrades Monitor and tune database performance (CPU, I/O, SQL tuning) Manage storage allocation and space planning Handle backup, recovery, and disaster recovery operations Perform DB2 utilities (REORG, RUNSTATS, LOAD, COPY, RECOVER) Troubleshoot database issues and resolve incidents Implement DB security (roles, privileges, RACF integration) Support application teams in query optimization Ensure compliance with enterprise standards and audit requirements Maintain documentation and operational procedures Required Skills Technical Skills Strong expertise in DB2 for z/OS Mainframe knowledge (z/OS, TSO/ISPF, JCL) DB2 utilities (REORG, RUNSTATS, LOAD, COPY) SQL tuning and query optimization Understanding of buffer pools, locking, and concurrency Backup & recovery concepts Platform Knowledge z/OS system environment RACF security VSAM datasets DB2 z/OS DBA (Database Administrator) Job Summary Responsible for administration, performance, and availability of DB2 databases on z/OS mainframe systems. The role ensures data integrity, security, and optimal performance in mission-critical enterprise environments. Key Responsibilities Install, configure, and maintain DB2 for z/OS environments Manage database objects (tablespaces, tables, indexes, views) Perform database creation, migration, and upgrades Monitor and tune database performance (CPU, I/O, SQL tuning) Manage storage allocation and space planning Handle backup, recovery, and disaster recovery operations Perform DB2 utilities (REORG, RUNSTATS, LOAD, COPY, RECOVER) Troubleshoot database issues and resolve incidents Implement DB security (roles, privileges, RACF integration) Support application teams in query optimization Ensure compliance with enterprise standards and audit requirements Maintain documentation and operational procedures Required Skills Technical Skills Strong expertise in DB2 for z/OS Mainframe knowledge (z/OS, TSO/ISPF, JCL) DB2 utilities (REORG, RUNSTATS, LOAD, COPY) SQL tuning and query optimization Understanding of buffer pools, locking, and concurrency Backup & recovery concepts Platform Knowledge z/OS system environment RACF security VSAM datasets
More at Infosys