Senior Mainframe DB2 DBA – Tune and Secure z/OS
Tata Consultancy Services Limited
Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Job summary
Tata Consultancy Services Limited in Cleveland, OH is seeking a seasoned Mainframe System DBA with DB2 expertise to manage databases, execute utilities, and optimize performance in a primarily z/OS environment.
The role requires strong SQL skills, JCL proficiency, and hands-on experience with DB2 utilities, SMP/E, and ITIL-aligned processes. This on-site position includes DR planning responsibilities and collaboration with technology teams.
Qualifications
- 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.
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
Skills
Education
Tools
Job description
Tata Consultancy Services Limited in Cleveland, OH is seeking a seasoned Mainframe System DBA with DB2 expertise to manage databases, execute utilities, and optimize performance in a primarily z/OS environment.
The role requires strong SQL skills, JCL proficiency, and hands-on experience with DB2 utilities, SMP/E, and ITIL-aligned processes. This on-site position includes DR planning responsibilities and collaboration with technology teams.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
