Job Description
Mainframe System DBA – Job Description
Role Overview
The Mainframe System DBA is responsible for administering, maintaining, and optimizing DB2 databases and mainframe subsystems on z/OS, ensuring availability, performance, security, and compliance.
Key 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
Required Skills
Strong Mainframe & DB2 architecture knowledge
Proficiency in JCL and z/...
Role Overview
The Mainframe System DBA is responsible for administering, maintaining, and optimizing DB2 databases and mainframe subsystems on z/OS, ensuring availability, performance, security, and compliance.
Key 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
Required Skills
Strong Mainframe & DB2 architecture knowledge
Proficiency in JCL and z/...
Apply for this Position
Ready to join Tata Consultancy Services? Click the button below to submit your application.
Submit Application