Mainframe DB2 Database administrator
4 days ago
Role & responsibilities
- Install, configure, upgrade, and maintain DB2 subsystems on z/OS.
- Perform database performance monitoring and tuning (buffer pool tuning, SQL optimization, etc.).
- Administer DB2 utilities (REORG, RUNSTATS, LOAD, UNLOAD, COPY, etc.).
- Manage schema changes, object creation, and DDL/DML execution.
- Collaborate with application developers to design and optimize efficient database structures.
- Implement and maintain disaster recovery procedures, backups, and restore processes.
- Conduct capacity planning and database growth analysis.
- Maintain database security, user access controls, and compliance with data policies.
- Troubleshoot and resolve DB2-related performance and availability issues.
- Work with storage and system administrators to ensure optimal infrastructure support.
- Participate in on-call rotation and provide support during off-hours when needed.
- Document processes, configurations, and best practices.
-
15h Left: Mainframe DB2 Administrator
1 week ago
Chennai, India Teamware Solutions Full timeJob Description We are looking for a skilled Mainframe DB2 Administrator with 4 to 5 years of hands-on experience in managing and supporting DB2 databases in a z/OS environment. The ideal candidate will have a strong understanding of DB2 internals, backup and recovery, performance tuning, and security, along with experience working in enterprise-level...
-
Chennai, India Tata Consultancy Services Full timeTechnical requirements Experience in Mainframe Db2 v12/ v13 Database System-Administration on z/OS DB2 installation, upgrade, patching, configuration and operations Proficiency in DB2, VSAM Systems Performance Tuning and Capacity Planning Experience in Data Sharing setup in Parallel Sysplex environment Knowledge in ACF2/RACF, CICS v5.5, Mainframe MQ v9...
-
Chennai, India Tata Consultancy Services Full timeTechnical requirements Experience in Mainframe Db2 v12/ v13 Database System-Administration on z/OS DB2 installation, upgrade, patching, configuration and operations Proficiency in DB2, VSAM Systems Performance Tuning and Capacity Planning Experience in Data Sharing setup in Parallel Sysplex environment Knowledge in ACF2/RACF, CICS v5.5, Mainframe MQ v9...
-
Chennai, India Tata Consultancy Services Full timeTechnical requirements Experience in Mainframe Db2 v12/ v13 Database System-Administration on z/OS DB2 installation, upgrade, patching, configuration and operations Proficiency in DB2, VSAM Systems Performance Tuning and Capacity Planning Experience in Data Sharing setup in Parallel Sysplex environment Knowledge in ACF2/RACF, CICS v5.5, Mainframe MQ v9...
-
chennai, India Tata Consultancy Services Full timeTechnical requirements Experience in Mainframe Db2 v12/ v13 Database System-Administration on z/OS DB2 installation, upgrade, patching, configuration and operations Proficiency in DB2, VSAM Systems Performance Tuning and Capacity Planning Experience in Data Sharing setup in Parallel Sysplex environment Knowledge in ACF2/RACF, CICS v5.5, Mainframe MQ v9...
-
Chennai, India Tata Consultancy Services Full timeTechnical requirementsExperience in Mainframe Db2 v12/ v13 Database System-Administration on z/OSDB2 installation, upgrade, patching, configuration and operationsProficiency in DB2, VSAM Systems Performance Tuning and Capacity PlanningExperience in Data Sharing setup in Parallel Sysplex environmentKnowledge in ACF2/RACF, CICS v5.5, Mainframe MQ v9Experience...
-
Chennai, India Tata Consultancy Services Full timeTechnical requirementsExperience in Mainframe Db2 v12/ v13 Database System-Administration on z/OSDB2 installation, upgrade, patching, configuration and operationsProficiency in DB2, VSAM Systems Performance Tuning and Capacity PlanningExperience in Data Sharing setup in Parallel Sysplex environmentKnowledge in ACF2/RACF, CICS v5.5, Mainframe MQ v9Experience...
-
Chennai, India Tata Consultancy Services Full timeTechnical requirementsExperience in Mainframe Db2 v12/ v13 Database System-Administration on z/OSDB2 installation, upgrade, patching, configuration and operationsProficiency in DB2, VSAM Systems Performance Tuning and Capacity PlanningExperience in Data Sharing setup in Parallel Sysplex environmentKnowledge in ACF2/RACF, CICS v5.5, Mainframe MQ v9Experience...
-
Chennai, India Tata Consultancy Services Full timeTechnical requirementsExperience in Mainframe Db2 v12/ v13 Database System-Administration on z/OSDB2 installation, upgrade, patching, configuration and operationsProficiency in DB2, VSAM Systems Performance Tuning and Capacity PlanningExperience in Data Sharing setup in Parallel Sysplex environmentKnowledge in ACF2/RACF, CICS v5.5, Mainframe MQ v9Experience...
-
chennai, India Tata Consultancy Services Full timeTechnical requirementsExperience in Mainframe Db2 v12/ v13 Database System-Administration on z/OSDB2 installation, upgrade, patching, configuration and operationsProficiency in DB2, VSAM Systems Performance Tuning and Capacity PlanningExperience in Data Sharing setup in Parallel Sysplex environmentKnowledge in ACF2/RACF, CICS v5.5, Mainframe MQ v9Experience...
