DB2 DBA (System & Apps DBA) Mainframe Database

DB2 DBA (System & Apps DBA) Mainframe Database

Job Code: TJ_7137
Job Location: Chicago, Illinois
Zip Code: 60290
Job Category/Title:
Employment Category: Contract - Corp-to-Corp, Contract - Independent, Contract - W2
Position Type: Mid Level
Travel Required: No
Interview Type: In-person
Education: Associate Degree
Experience: 3-5 year(s)
Job Description: Description:

• 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 etc.
• Online utilities -CHECKDATA, COPY, QUIESCE, REPAIR, REORG, LOAD, UNLOAD etc.
Duration: 6 Month(s)
No. of Posts: 1
Job Expiry Date: October 13, 2016
Telecommute: No
Contact Information Login To View