Job Description :
DB2-DBA
Houston, TX
Contract

Job description

Experience in DB2 database administration activities on z/Os-Mainframes.
Experience in DB2 Utilities such as LOAD, UNLOAD, REORG, RUNSTATS, etc.,
Support multiple DB2 subsystems simultaneously on Mainframe-z/os.
Troubleshooting and solving production database issues in z/os-Mainframes.
Knowledge of CA-Platinum for DB2 and IBM DB2 tools for DB2 database administration.
Good knowledge on platinum db2 utilities and troubleshooting.
In-depth knowledge in JCL, IDCAMS, SORT and Data handling utilities on Mainframes.
Experience in database backups and maintain the backup procedures as per backup strategy.
Analyzing new versions of DB2 for functionality to improve the application database.
Support of customer and internal requests for building all types of DB2 objects in z/os-Mainframes.
Support COBOL Application development team continuously improve the design and processes.
Supporting application infrastructure environment for DB on Z/os and related technologies.
Work on Incident, Change and Problem tickets, analyze and perform performance tuning.
Work with COBOL application teams to continuously improve the design and processes.
Assist developers with complex query tuning and refinement, maintain database availability.
Knowledge on ticketing tools like SONIC and Servicenow.
Work with extended teams like System Admin Team, Space Management Team and RACF Team.
On-call support to respond and resolve application issues, to ensure production applications availability.