Mainframe System DBA (Fulltime - Cleveland, OH)
K&K Global Talent Solutions
- Job
- 28121
- Posted
- Location
- Cleveland, OH
- Work type
- Full Time
- Tax terms
- C2C
- Experience
- Experience open
- Rate
- $90,000 to $110,000 (Annum)
- Openings
- 1 opening
Opens your email app with a message to the employer, its subject naming this job. Attach your resume and send it from your own email.
Skills
- SQL
- JCL
- DB2
- Mainframe
About the job
Job Title - Mainframe System DBA
Experience Required - 8+ years
Location - Cleveland, OH
Hire Type - Fulltime (Onsite)
Must Have Technical/Functional Skills
• 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
Roles & Responsibilities
• 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