Description

You will manage and optimize DB2 environments on z/OS at an L3 support level.

Responsibilities

• Execute DB2 version upgrades and migrations, including the application of PTFS and APARS.
• Manage database environments by performing reorganizations, monitoring thread/tablespace/index spaces, and executing offline utilities like DSNJU003 and DSNJU004.
• Maintain database security by managing user IDs, rights, privileges, and implementing security compliance corrections.
• Handle database lifecycle tasks including creation, image copies, archive logs, and DB2 recycling.
• Perform performance tuning for both databases and SQL, and manage disaster recovery setups through various sync methods.

Required Skills

• 12+ years of experience in DB2 administration on z/OS.
• Proficiency in SQL creation, SQL tuning, and DB2 command line execution.
• Experience with physical database definition (DDL) and logical database design.
• Expertise in online utilities including CHECKDATA, COPY, QUIESCE, and REPAIR.
• Ability to implement DBDC (CICS, DB2, or IMS) base software and related product installs/upgrades.
• Hands-on experience managing system catalogs and DB2 IVS products.
• Knowledge of offline utilities such as DSNJLOGF, DSNJU004, and DSNJU003.
• Competency in managing tablespaces, tables, indexes, views, and triggers.
• Any Graduate degree.

Key Skills

Education

Any Graduate