Job
Description
Job Summary: "Duties and Responsibilities of Mainframe DB2 Systems DBA" (i) Create and Manage IBM DB2 databases. (ii) Experience in DB2 Upgrades, Installation, and RSU maintenance using SMP/E of DB2 Z/OS products. (iii) Experience in Performance Tuning and troubleshooting. (iv) Good knowledge of Disaster recovery practices planning and execution. (v) Thorough knowledge of buffer pool tuning, backup and recovery procedures, data migration, and archival. (vi) Knowledge of Function level upgrades of DB2. (vii) Experience in upgrades and maintenance of BMC DB2 products, QMF, HPU, etc. (viii) Thorough understanding of replication and its related upgrades. (ix) Must be able to provide design and administration support to application developers. (x) Good team player with better behavioral and administration skills (xi) Provide training to junior members of the team. (xii) Self-motivated ability to work un-supervised as well as being able to work as part of a team in a pressured environment (xiii) Excellent communication and presentation skills. (xiv) Excellent critical thinking and problem-solving skills; patient and professional demeanor, with a can-do attitude. Roles and Responsibilities: (i) Installing DB2 Z/OS upgrades, applying RSU maintenance and PTFs. (ii) Strong knowledge and experience with SMP/E, ISPF dialog management, JCL and REXX. (iii) Strong understanding of the DB2 Z/OS System administration concepts. (iv) Should have worked with WLM. (v) Experience with BMC DB2, QMF, HPU, CA-Platinum, and upgradation of the same. (vi) Strong knowledge of Function level upgrades to DB2, Mainview, and Apptune. (vii) Sound understanding of performance tuning, buffer pool tuning, and troubleshooting for performance-related issues and problem diagnosis. (viii) Sound knowledge of disaster recovery procedures, backup, restore, and archival practices of DB2. (ix) Thorough understanding of DB2 data sharing environments, migration of data, and security of DB2. (x) Strong experience with stored procedures (xi) Thorough knowledge of DB2 utilities such as (UNLOAD, LOAD, REORG, IMAGECOPY, DSN1COPY), etc #LI-LK1
