Hello,
Very Urgent and Critical Role
Job title: Mainframe DB2
Current Location: Frisco, TX
Responsibilities:-
- Upgrade/Migrate DB2 Versions to newer versions
- Regularly applying PTFS/APARS if required.
- Manage DB2 IVS Products and upgrade to supported versions if required.
- Managing system catalogs
- Manage application data and database environments, performing reorganizations when required to optimize performance
- Offline utilities - DSNJLOGF, DSNJU004, DSNJU003 etc.
- Database and related object security – manage user ids, rights and privileges
- DB2 administration on z/OS, SQL creation, DB2 command line creation and execution, DB2 performance tuning,
- Physical database definition (DDL) and understanding of logical database design
- Implement DBDC (CICS, DB2, or IMS) base software installs and upgrades
- Implement DBDC (CICS, DB2, or IMS) related product installs and upgrades
- Implement DBDC (CICS, DB2, or IMS) security compliance corrections
- Monitoring – threads, table space and index spaces.
- Monitoring instances for events and resolution/escalations
- Performance tuning – Database and SQL tuning
- DB2 recycle
- DB2 Image copy (full/incremental)
- Database creation
- Grant/revoke of authorities
- DB2 archive logs
- Having experience of DR setup through various synch methods
- Build and maintenance of database and related objects like table space, tables, indexes, views, triggers
- Online utilities -CHECKDATA, COPY, QUIESCE, REPAIR, REORG, LOAD, UNLOAD etc.
Years of Experience
Total : Above 8+ Years of experience
Relevant : Minimum of 8 yrs in DB2 UDB on z/OS
Thanks & Regards,
Mohd Imaan
Lead Technical Recruiter
ASK Staffing, Inc.
Email: mohdi@askstaffing.com
Phone: 678-345-1745
 | |