DB2 System programmer Admin

Hello

We are from Mavinsys Talent Acquisition team based on One World Trade centre New York. We are specializing in IT services and staffing majorly in lateral hiring/contract. Below is one of our requirement to fill immediately if youre interested please share your candidature to

Job Title : DB2 System programmer admin

Location : Mississauga OH

Duration : 12months

Job 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

• Online utilities CHECKDATA COPY QUIESCE REPAIR REORG LOAD UNLOAD etc

DB2 administration on z/OS, SQL creation, DB2 command line creation and execution, DB2 performance tuning,