Database Administrator

Tata Consultancy Services; Cleveland (OH); On-site; USD 90,000 - 110,000; Full time

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

Mainframe DB2 DBA

JCL

z/OS

SQL

Performance tuning

Education

Bachelor's in Computer Science

Tools

BMC tools

CA tools

IBM utilities

Job description

Role: Mainframe System DBA

Must Have Technical/Functional Skills

• 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.

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

Salary Range - $90,000-$110,000 a year

Location: Cleveland, OH

Function: TECHNOLOGY

Role: Database Administrator

ID: 437255

Skills: Mainframe

Salary Range: $90,000 - $110,000

Desired Candidate Profile

• Qualifications
• BACHELOR OF COMPUTER SCIENCE