• Job Description

  Req#: 331791

  TCS has always been in the spotlight for being adept in "the next big technologies". What we can offer you is a space to explore varied technologies and quench your techie soul.

  We are Hiring for IT IS_AMS_Mainframe_DB2 Administration
  at Hyderabad.

  
  

  Professional experience:

  
  

  1 Role MAINFRAME IMS and DB2 Administrator

  2 Required Technical Skill Set IMS & DB2,JCL, TSO/ISPF,VSAM

  3 Desired Experience Range 8+

  4 Location of Requirement Hyderabad

  
  

  Desired Competencies (Technical/Behavioral Competency)

  Must-Have

  1. Bachelor degree in Computer Science or Computer Information Systems or equivalent work experience.

  
  

  2. Excellent verbal and written communication skills.

  
  

  3. Ability to independently research problems and provide solutions

  
  

  4. Expertise experience in both DB2/IMS databases management systems and file systems. (DB2,IMS,VSAM,JCL)

  
  

  5. you will provide technical leadership and guidance to the mainframe IMS application and support teams and will collaborate with the Mainframe Operation teams to ensure the applications are highly available. In this position, you will also be providing DB2 DBA maintenance and development support of mainframe DB2 application databases in all environments (development, acceptance, and production).

  
  

  6. In- depth knowledge on DB2 Utilities and JCL.

  
  

  7. Experience with BMC/IBM/CA DB2 tools.

  
  

  8. Willing to work a 24/7 on-call rotation.

  
  

  9. Availability to provide weekend/off-hours support as needed.

  
  

  Good-to-Have 1. Experience with TMON for DB2/IMS.

  2. Maintain database security and disaster recovery procedures.

  3. Perform troubleshooting and maintenance of multiple databases.

  4. Resolve any database issues in accurate and timely fashion.

  5. Monitor databases regularly to check for any errors such as existing locks and failed updates.

  6. Oversee utilization of data and log files.

  7. Manage database logins and permissions for users.

  
  

  
  

  Responsibility of / Expectations from the Role

  - Based on applications' requirements perform all changes to DB2/IMS databases in Test and Production environments.

  
  

  - Implement and maintain Database backup and recovery strategy.

  
  

  - Provide Production support - on-call 7x24.

  
  

  - Provide troubleshooting and problem determination during outage or daily issues.

  
  

  - Provide Performance tuning.

  
  

  - Monitor space utilization.

  
  

  - Support DR exercises.

  
  

  - Maintain and Enforce Database standard and best practices

  
  

  - Assist with testing and validation of database software upgrades

  
  

  - Administration of databases throughout the development and production lifecycles.

  
  

  - Creation and execution of DDL/DCL for managing DB2 databases.

  
  

  - Maintenance procedures using DB2 Utilities (UNLOAD,LOAD,Copy, Reorg, Modify, Recover)

  
  

  - Conduct performance monitoring and tuning activities on DB2 databases.

  
  

  - Reviewing and maintaining security procedures across the DB2 databases.

  
  

  - Work with DB2 z/OS System support staff on installation/upgrade efforts.

  
  

  - Provide advice and support to development resources.

  
  

  - 24x7 on-call support rotation.

  
  

  - Application of database changes during non-peak hours as required by applications.

  
  

  - Other duties as directed by management

• About the company

  Tata Consultancy Services is an Indian multinational information technology services and consulting company headquartered in Mumbai, Maharashtra, India with its largest campus located in Chennai, Tamil Nadu, India.

Notice