Mainframe DB2 DBA

PROLIM Global Corporation
Russell Island, MI, United States
7 days ago
Apply on www.careerbuilder.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
4 years minimum
Working hours
Regular working hours

Tech stack

Databases IBM DB2 Job Control Language (JCL) Mainframes Multiprocessing Performance Tuning Standard Sql Z/OS

Job description

  • Manage DB2 objects (databases, tablespaces, tables, indexes)
  • Execute DB2 commands (STOP/START, DISPLAY, thread cancel/termination)
  • Run DB2 utilities (REORG, RUNSTATS, COPY/RECOVER, LOAD/UNLOAD, REPAIR)
  • Perform BSDS updates using DSNJU003/DSNJU004
  • Support DB2 upgrades, migrations, SMP/E maintenance
  • Use ISV tools (BMC, CA, IBM utilities)
  • Monitor and tune performance using DB2 catalog and tools
  • Troubleshoot DB2 and application issues
  • Manage grants, privileges, and security
  • Follow ITIL processes (Incident, Problem, Change, Configuration)
  • Support DR planning and execution

Requirements

Mainframe Computer, IBM DB2, Database Administration, Database Administration, IBM DB2, Loading/Unloading, Symmetric MultiProcessing (SMP) Computing, IBM Product Family, Independent Software Vendor (ISV), Performance Tuning/Optimization, * 4-6 years of Mainframe DB2 DBA or System Programmer experience

  • Strong Mainframe & DB2 architecture knowledge
  • Proficiency in JCL and z/OS operations
  • Hands-on experience with DB2 utilities and SMP/E
  • Experience with BMC/CA tools
  • Strong SQL and catalog analysis skills

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerbuilder.com
Prepare application

Good distractions

Loading talks and stories from around this role…