Mainframe DB2 System Administrator
3 days ago
About The Role
- Install, upgrade, and maintain DB2 on z/OS and related ISV tools.
- Configure and manage DB2 subsystems in both data sharing and non-data sharing environments.
- Perform DB2 disaster recovery, backups, restores, and performance tuning.
- Build and relocate DB2 subsystem environments as needed.
- Apply maintenance updates and patches using SMP/E.
- Develop and maintain REXX scripts for automation and DB2 interaction.
- Monitor DB2 performance using traces, utilities, and performance monitors.
- Collaborate with operations and automation teams to define and implement procedures.
- Provide technical recommendations and support for DB2 environments.
- Ensure security compliance in RACF/Top Secret/ACF2 environments.
Primary Skills
- Strong knowledge ofDB2 on z/OSand relational database concepts.
- Experience withDB2 utilities(COPY, REORG, LOAD, UNLOAD).
- Proficiency inDB2 toolsSPUFI, QMF, IBM DB2 Admin Tool, Object Comparison Tool, Infosphere Optim, High Performance Unload.
- Expertise inDB2 performance tuning, query optimization, and CPU utilization analysis.
- Experience withDB2 stored procedures, recovery to PIT, and DBADM/SYSADM authority.
- Familiarity withSMP/E,REXX,Assembler, andJCL.
Location - Bengaluru,Chennai,Gurugram,Hyderabad,Kolkata,Mumbai,Noida,Pune
-
Mainframe DB2 System Programmer
6 days ago
Chennai, Tamil Nadu, India Infosys Full time ₹ 12,00,000 - ₹ 36,00,000 per yearKey Responsibilities:Skills involves and not limited too Evaluate and implement new features functions of DB2 and associated third party productso Extensive use of utilities and Performance Monitoring tools using BMC CA and IBM productso Consultant on DB2 database applications architectureo Knowledge of SMP E and can prepare for and apply maintenance to a...
-
Bengaluru, India Tata Consultancy Services Full timeExp Range- 2-10 yrsSummary of key responsibilities Define and provide guidance for database creation, configuration, upgrade, patches and refresh requirements Recommend operating system and database performance monitoring, tuning and configuration changes Experience with database physical and logical design, query analysis and optimization Provide technical...
-
Bengaluru, India Tata Consultancy Services Full timeExp Range- 2-10 yrs Summary of key responsibilities - Define and provide guidance for database creation, configuration, upgrade, patches and refresh requirements - Recommend operating system and database performance monitoring, tuning and configuration changes - Experience with database physical and logical design, query analysis and optimization - Provide...
-
Bengaluru, India Tata Consultancy Services Full timeExp Range- 2-10 yrsSummary of key responsibilities Define and provide guidance for database creation, configuration, upgrade, patches and refresh requirements Recommend operating system and database performance monitoring, tuning and configuration changes Experience with database physical and logical design, query analysis and optimization Provide technical...
-
Bengaluru, India Tata Consultancy Services Full timeExp Range - 2-10 yrs Summary of key responsibilities Define and provide guidance for database creation, configuration, upgrade, patches and refresh requirements Recommend operating system and database performance monitoring, tuning and configuration changes Experience with database physical and logical design, query analysis and optimization Provide...
-
Tcs is hiring for mainframe db2 system administrator
23 hours ago
Bengaluru, India Tata Consultancy Services Full timeExp Range - 2-10 yrs Summary of key responsibilities Define and provide guidance for database creation, configuration, upgrade, patches and refresh requirements Recommend operating system and database performance monitoring, tuning and configuration changes Experience with database physical and logical design, query analysis and optimization Provide...
-
Bengaluru, India Tata Consultancy Services Full timeExp Range- 2-10 yrsSummary of key responsibilities Define and provide guidance for database creation, configuration, upgrade, patches and refresh requirements Recommend operating system and database performance monitoring, tuning and configuration changes Experience with database physical and logical design, query analysis and optimization Provide technical...
-
Bengaluru, India Tata Consultancy Services Full timeExp Range - 2-10 yrsSummary of key responsibilitiesDefine and provide guidance for database creation, configuration, upgrade, patches and refresh requirementsRecommend operating system and database performance monitoring, tuning and configuration changesExperience with database physical and logical design, query analysis and optimizationProvide technical...
-
Bengaluru, India Tata Consultancy Services Full timeExp Range - 2-10 yrsSummary of key responsibilitiesDefine and provide guidance for database creation, configuration, upgrade, patches and refresh requirementsRecommend operating system and database performance monitoring, tuning and configuration changesExperience with database physical and logical design, query analysis and optimizationProvide technical...
-
Bengaluru, India Tata Consultancy Services Full timeExp Range- 2-10 yrsSummary of key responsibilities- Define and provide guidance for database creation, configuration, upgrade, patches and refresh requirements- Recommend operating system and database performance monitoring, tuning and configuration changes- Experience with database physical and logical design, query analysis and optimization- Provide...
