Mainframe Db2 Dba

4 days ago

Chennai Tamil Nadu, India UST Global Full time

3 - 5 Years
- 1 Opening
- Chennai

**Role description**:

- Install, configure, and upgrade DB2 databases (LUW and/or z/OS as applicable).
- Perform regular database maintenance, patching, and health checks.
- Monitor database performance and conduct tuning as needed.
- Implement backup and recovery strategies using native DB2 tools or third-party solutions.
- Manage database security, user access, and roles.
- Support disaster recovery planning and testing.
- Perform root cause analysis and resolve DB2 incidents and performance issues.
- Document procedures, processes, and system configurations.
- Participate in on-call support rotations if required.

**Key Skills Required**:

- Strong hands-on experience with **IBM DB2 (LUW and/or Mainframe/z/OS environments)**:

- Proficiency in **DB2 installation, configuration, and version upgrades**:

- Experience with **DB2 performance tuning and optimization**:

- Knowledge of **database backup, recovery, and disaster recovery planning**:

- Familiarity with **high availability setups** (e.g., HADR, TSA, or clustering)
- Experience in **database security management and compliance**:

- Proficient in **SQL scripting, stored procedures, and query optimization**:

- Exposure to **Linux, UNIX, or Windows environments** for DB2 administration
- Experience with **monitoring tools** (e.g., IBM Data Server Manager, Tivoli, or equivalent)
- Good understanding of **ITIL processes** and change management procedures
- Performance tuning and **Capacity planning**:

- Tools - SYSVIEW, OMEGAMON, RMF for performance monitoring

**Preferred Skills**:

- Knowledge of **cloud-based DB2 environments** (IBM Cloud Pak, AWS RDS for DB2, etc.)
- Scripting skills in **Shell, Python, or PowerShell**:

- Exposure to **DevOps/Automation tools** (Ansible, Jenkins, etc.)
- Understanding of **other database systems** (Oracle, SQL Server) is a plus
- Relevant certifications such as **IBM Certified Database Administrator - DB2** are preferred

**Skills**:
Mainframe, DB2, DBA, performance tuning and optimization

**About UST**:
UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world’s best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients’ organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact—touching billions of lives in the process.

  • Mainframe DB2 DBA

    1 week ago

    Chennai, Tamil Nadu, India Futurz Staffing Solutions Full time ₹ 4,00,000 - ₹ 8,00,000 per year

    Work Location: Chennai, TNSkill Required: Mainframe DB2 - Application DevelopmentExperience Range: 2-4 yearsJob Description:Mainframe DB2 DBA 1. Hands on experience in database administration troubleshooting for Mainframe DB DB2v10 or higher1.Excellent Communication Skills to work with Matrix teams2.Experience in SQL ReplicationResponsibility of Expectations...

  • Ims System Administration with IBM Db2 Dba

    1 week ago

    Chennai, Tamil Nadu, India Cognizant Full time

    Experience Level - 5+ Years **Responsibilities**: primarily IMS DBA and Secondary Mainframe DB2 DBA

  • IMS DB2 DBA

    2 days ago

    Bengaluru, Chennai, Hyderabad, India Golden Opportunities Pvt Ltd Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Job Title : IMS DB2 Database Administrator (DBA)Location : Chennai, Bangalore, Pune, HyderabadExperience : 8+ YearsJob SummaryWe are seeking an experienced IMS DB2 DBA to manage, support, and optimize IMS (Information Management System) and DB2 databases in a mainframe environment.The ideal candidate must have strong mainframe skills, hands-on IMS database...

  • Mainframe DB2 Admin

    2 weeks ago

    Chennai, Tamil Nadu, India Tata Consultancy Services (TCS) Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    TCS has been a great pioneer in feeding the fire of young techies like you. We are a global leader in the technology arena and there's nothing that can stop us from growing together.What we are looking forRole: Mainframe DB2 SupportExperience Range: 4 – 8 YearsLocation: ChennaiMust Have:Hands-on experience in COBOL, JCL, DB2 and VSAM based...

  • Mainframe DB2 System Administrator Hiring for Chennai/Bangalore/Hyderabad

    3 weeks ago

    Chennai, India Tata Consultancy Services Full time

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

  • Mainframe DB2 System Administrator Hiring for Chennai/Bangalore/Hyderabad

    3 weeks ago

    Chennai, India Tata Consultancy Services Full time

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

  • Mainframe DB2 System Administrator Hiring for Chennai/Bangalore/Hyderabad

    3 weeks ago

    Chennai, India Tata Consultancy Services Full time

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

  • Mainframe DB2

    4 weeks ago

    Chennai, India Teamware Solutions Full time

    Job Description Key Responsibilities: - Develop and maintain COBOL / PL/I programs interacting with DB2 databases on mainframe systems. - Write efficient SQL queries, stored procedures, and optimize DB2 database access. - Analyze requirements, design solutions, and implement application enhancements. - Perform unit testing and support system integration...

  • ▷ (15h Left) Mainframe Db2 System Administrator Hiring For Chennai/Bangalore/Hyderabad

    4 weeks ago

    Chennai, India Tata Consultancy Services Full time

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

  • Db2 Systems Dba or Zos System Programmer

    10 hours ago

    Chennai, Tamil Nadu, India Cognizant Full time

    **Job Summary**: "Duties and Responsibilities of Mainframe DB2 Systems DBA" (i) Create and Manage IBM DB2 databases. (ii) Experience in DB2 Upgrades, Installation, and RSU maintenance using SMP/E of DB2 Z/OS products. (iii) Experience in Performance Tuning and troubleshooting. (iv) Good knowledge of Disaster recovery practices planning and execution. (v)...