IT IS_AMS_Mainframe_DB2 Administration

Job Description

• Role Mainframe Db2 Admin 
• Required Technical Skill Set Install, upgrade, maintain and customize DB2 and its associated IBM and 3rd party software,
• Desired Competencies (Technical/Behavioral Competency)
• Must-Have Install, upgrade, maintain and customize DB2 and its associated IBM and 3rd party software

• Monitor DB2 on z/OS environment

• Create, modify and maintain the DB2 databases on z/OS environment

• Technical system support for DB2 sub systems, database tools and utilities

• Support DB2 business, end user and application requirements.  

• Monitors DB2 Regions across life cycles, take necessary remedial action as required.  

• Reorganize and update statistics in the DB2 System Catalog tables.  

• Perform regular housekeeping activities like administer the data server on which DB2 resides like monitoring disk space and the DB2 logs, Backups and protect the integrity of the data. 

• Review all data models for technical accuracy. This includes the enforcement of all modeling and naming standards

• Perform all structural changes to DB2 databases

• Work with Buyer's Security Administration to insure that proper security is in place for DB2 data 

• Regularly review Automation and Dependency of systems tasks

• Manage and maintain data definitions for all prod and non-prod databases

• DB2 SQL performance tuning

• Perform Database backups, reorg and recovery

• DB2 Plan and Package management

• DB2 Database maintenance using utilities

• Assisting the developer teams in debugging DB2 related issues

• Good-to-Have Perform Database backups, reorg and recovery

• DB2 Plan and Package management

• DB2 Database maintenance using utilities

• Assisting the developer teams in debugging DB2 related issues