Mainframe DB2 Programmer

Company: Applab Systems Inc
Location: Myrtle Point
Posted on: May 25, 2023

Job Description:

Hi, Hope you are doing good...! I am Ravi represented to Applab Systems and I have an excellent job opportunity for you. Please find the below job description and if you are comfortable, please reply or contact me for further discussion. Job Title: Mainframe DB2 Programmer Location: Remote, USA/Canada Job Type: 6-12+ month Contract Mandatory Skills: We need someone from System Side / System Programming side and NOT from Application side / development. 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. Years of Experience : Relevant : Minimum of 8 yrs in DB2 UDB on z/OS -- Thanks Ravi Kant +1 732-847-2072 Ext. 587 AppLab Systems, Inc. 4365 Route 1 South, Suite 105, Princeton, NJ 08540

Keywords: Applab Systems Inc, Medford , Mainframe DB2 Programmer, IT / Software / Systems , Myrtle Point, Oregon