Mainframe DB2 System Programmer

Kyndryl Solutions Private Limited; Chennai; Hybrid; INR 900,000 - 1,700,000; Full time

Job summary

Kyndryl Solutions Private Limited is seeking a Senior Mainframe DB2 Database Administrator in Chennai. You will manage DB2 for z/OS, ensure high availability, perform upgrades, and lead performance tuning across the DB2 lifecycle.

This role requires deep expertise in z/OS, JCL/TSO, and DR planning, with collaboration across application and infrastructure teams. You will drive automation and operational improvements to support mission-critical workloads in a hybrid work environment.

Qualifications

• 9+ years of experience managing IBM DB2 for z/OS in enterprise production environments.
• Hands-on with DB2 utilities: REORG, RUNSTATS, COPY, RECOVER, LOAD, UNLOAD, REBUILD INDEX, CHECK DATA.
• Experience with DB2 subsystem installation, upgrades, migrations and version upgrades (DB2 v11/v12/v13).
• Strong knowledge of z/OS, JCL, TSO/ISPF, REXX, SMP/E, RACF, and Mainframe infra.
• Experience with performance tuning, SQL optimization, access path analysis, buffer pool tuning and capacity planning.
• Expertise in backup, recovery, disaster recovery planning, and business continuity for DB2 environments.
• Proficiency in monitoring/troubleshooting using OMEGAMON, SPUFI, QMF, BMC MainView, DB2 Admin Tool.
• Experience supporting 24x7 production environments, incident resolution and root cause analysis.

Responsibilities

• Administer and maintain DB2 for z/OS environments with high availability and performance.
• Perform installation, configuration, upgrades, migrations and maintenance of DB2 subsystems.
• Execute and manage backup, recovery and disaster recovery processes.
• Troubleshoot incidents, perform root cause analysis and implement preventive measures.
• Monitor and optimise performance including SQL tuning and buffer pool management.
• Collaborate with application teams on design reviews, performance tuning and issue resolution.
• Drive continuous improvements in reliability, automation and operational excellence.

Skills

DB2 for z/OS

DB2 performance tuning

JCL/TSO/ISPF

Problem solving

Disaster recovery

Automation

Tools

OMEGAMON

SPUFI

QMF

BMC MainView

DB2 Admin Tool

Job description

Mainframe DB2 Database Administrator

Who We Are

At Kyndryl, we run and reimagine the mission-critical technology systems that drive advantage for the world’s leading businesses. We are at the heart of progress; with proven expertise and a continuous flow of AI-powered insight, enabling smarter decisions, faster innovation, and a lasting competitive edge. For our people—Kyndryls—that means doing purposeful work that powers human progress. Join us and experience a flexible, supportive environment where your well-being is prioritized and your potential can thrive.

The Role

Your Role As a Mainframe DB2 Database Administrator, you’ll help keep critical DB2 for z/OS database environments secure, resilient and performing at their best. You’ll combine hands‑on database administration with problem‑solving and continuous improvement, supporting the systems that customers rely on while helping them evolve within increasingly integrated, hybrid IT environments. You’ll be working across the DB2 lifecycle, from installation, configuration and upgrades to performance optimisation, recovery and ongoing operational health. When complex issues arise, you’ll investigate what is happening, identify the underlying cause and work with application and infrastructure teams to restore service and prevent repeat incidents. This is also an opportunity to look beyond day‑to‑day support. You’ll use your knowledge of DB2 and the wider z/OS environment to identify opportunities to improve reliability, capacity and operational efficiency. You’ll work with application teams on database design and SQL performance, automate repeatable administration activities and help ensure database environments are ready for both current workloads and future change.

What Yo will Do

• Administer and maintain DB2 for z/OS environments, ensuring high availability, performance, and capacity management.
• Perform installation, configuration, upgrades, migrations, and maintenance of DB2 subsystems and database objects.
• Execute and manage backup, recovery, and disaster recovery processes to safeguard critical business data.
• Troubleshoot database incidents, conduct root cause analysis, and implement preventive measures.
• Monitor and optimize database performance, including SQL tuning, access path analysis, and buffer pool management.
• Collaborate with application teams on database design reviews, performance tuning, and issue resolution.
• Drive continuous improvements in database reliability, automation, and operational excellence to support mission‑critical workloads.

Your future at Kyndryl

This role opens the door to many career paths, both vertical and horizontal, and there may be opportunity to travel. It’s a great chance for database administrators or other techs to break into the cloud. It’s also a solid path to become enterprise or chief architect or a distinguished engineer! Whatever you see for yourself, you’ll find the opportunity here.

Who You Are

You’re good at what you do and possess the required experience to prove it. However, equally as important – you have a growth mindset; keen to drive your own personal and professional development. You are customer‑focused – someone who prioritizes customer success in their work. And finally, you’re open and borderless – naturally inclusive in how you work with others.

Required Technical and Professional Expertise

• 9+ years of experience managing IBM DB2 for z/OS in enterprise production environments, with expertise in database maintenance, monitoring, performance tuning, and troubleshooting.
• Hands‑on expertise with DB2 utilities including REORG, RUNSTATS, COPY, RECOVER, LOAD, UNLOAD, REBUILD INDEX, and CHECK DATA.
• Experience supporting DB2 subsystem installation, upgrades, migrations, maintenance, and version upgrades (DB2 v11/v12/v13).
• Strong knowledge of z/OS, JCL, TSO/ISPF, REXX, SMP/E, RACF, and Mainframe infrastructure.
• Experience with database performance tuning, SQL optimization, access path analysis, buffer pool tuning, and capacity planning.
• Expertise in backup, recovery, disaster recovery planning, and business continuity support for DB2 environments.
• Proficiency in monitoring and troubleshooting DB2 issues using tools such as OMEGAMON, SPUFI, QMF, BMC MainView, and DB2 Admin Tool.
• Experience supporting 24x7 production environments, incident resolution, problem management, and root cause analysis.

Preferred Technical and Professional Experience

• Experience supporting complex enterprise mainframe environments and 24x7 production services.
• Understanding of ITIL‑aligned change, release and service management practices.
• Experience working across system programming, application, storage and infrastructure teams to resolve technical issues.
• Experience supporting disaster recovery exercises, audits, compliance reviews or operational governance.
• IBM DB2 for z/OS certification or comparable demonstrated DB2 expertise.

Being You

The “Kyn” in Kyndryl means kinship, which represents the strong bonds we have with each other, our customers and our communities. We focus on ensuring all Kyndryls feel included and we welcome people of all cultures, backgrounds, and experiences. Even if you don’t meet every requirement, we encourage you to apply. We believe in growth, and we’re excited to see what you can bring. At Kyndryl, employee feedback has told us that our number one driver of employee engagement is belonging. That sense of belonging — being a valued, respected, trusted member of the team — is fundamental to our culture and fueling great experiences for our customers. This dedication to welcoming everyone into our company means that Kyndryl gives you the ability to thrive and contribute to our culture of empathy and shared success. That’s The Kyndryl Way.

What You Can Expect

• We offer a dynamic, hybrid‑friendly culture that supports your well‑being and empowers you to grow.
• Our Be Well programs are thoughtfully designed to support your financial, mental, physical, and social health—because we know that when you feel your best, you do your best.
• From your very first day, you’ll dive into impactful work that powers the systems our customers rely on every day.
• You won’t just contribute—you’ll make a difference, tackling meaningful projects that sharpen your skills and fuel your growth.
• We’re here to champion your journey.
• With powerful tools to chart your career path, personalized development goals aligned with your ambitions, and continuous feedback to keep you inspired and on track, you’ll have everything you need to thrive and evolve.
• You’ll develop in‑demand skills to grow your career and achieve your ambitions with access to cutting‑edge learning opportunities—from certifications with Microsoft, Google, and Amazon to coaching and hands‑on experiences.
• And through it all, you’ll be part of a culture that values empathy, restless learning, and a devotion to shared success.
• We want you to thrive here—and we’re committed to helping you do just that.

Experience Level Senior Level