Senior Mainframe DB2 Database Administrator SME

Posted 13 Days Ago
Be an Early Applicant
3 Locations
Senior level
Cloud • Information Technology • Consulting
The Role
As a Senior Mainframe DB2 Database Administrator, you'll manage DB2 databases, ensure performance, implement security measures, and oversee backup and recovery processes, requiring extensive experience in administration and monitoring tasks.
Summary Generated by Built In

Who We Are

At Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl? We are always moving forward – always pushing ourselves to go further in our efforts to build a more equitable, inclusive world for our employees, our customers and our communities.


The Role

Within our Mainframe DB2 Database Administration team at Kyndryl, you'll be a master of managing and administering the backbone of our technological infrastructure. You'll be the architect of the system, shaping the base definition, structure, and documentation to ensure the long-term success of our business operations. 

Creation and maintenance of DB2 objects and privileges Creation and execution of database maintenance utilities for refreshing test environments, copying test / production databases, recovering test / production databases, re-organizing and statistics collection for test / production databases. Performing major data refresh from production to test environments. Responsible for all DBA activities including backup, load, reorg and performance enhancement Implement the DB2 Objects in various environments starting from TEST through PROD. Delivery of all DB2 related Housekeeping jobs and scheduling them in production. Around 3 years’ hands on database administration experience with IBM DB2. In-depth knowledge of DB2 utilities such as LOAD, UNLOAD, RUNSTAT, REORG, COPY, experience working with IBM Admin tool suite, Query Monitor, etc. Add or modify user permissions to databases. Schedule regular DB maintenance operations according to workload pattern and usage of the DB. Play a critical role in design, build, implementation, upgrade and optimization of DB2 databases. Perform requested changes, updates, and modifications to database structure and data. Implementing solutions for DB2 database backup and recovery infrastructure. Monitor/maintain/upgrade DB2 database and assist application team with performance tuning initiatives and builds. Experience with IBM Utilities and JCL. Ability to independently research problems and provide solutions. Perform DBA support functions for high volume Production DB2 subsystems Handle backup, recovery & disaster recovery responsibilities for primary & secondary Production environments Participate in on-call & off-hours support coverage Assist application teams with technical advice, diagnosis of SQL errors Assist with data refresh requirements in testing environments Perform application DBA functions (maintain & implement DDL, handle image copy & maintenance activities) for all testing environments Support migration of DDL across environments to Production Experience with IBM DB2 utilities, BMC database tools.

Tools and Technology used: MF Storage, JCL, VSAM, CLIST, REXX, SAS, DFSMS Suite, IDCAMS, CA1, ICF Catalog, ISMF, TDMF, Flash copy, Global mirror, Copy service manager, OAM, FDR/ABR.EOSPROD, JSF

Your expertise will be crucial in configuring, installing and maintaining database management systems, ensuring that our systems are always running at peak performance. You'll also be responsible for managing user access, implementing the highest standards of security to protect our valuable data from unauthorized access.
In addition, you'll be a disaster recovery guru, developing strong backup and recovery plans to ensure that our system is always protected in the event of a failure. Your technical acumen will be put to use, as you support end users and application developers in solving complex problems related to our database systems.
As a key player on the team, you'll implement policies and procedures to safeguard our data from external threats. You will also conduct capacity planning and growth projections based on usage, ensuring that our system is always scalable to meet our business needs.
You'll be a strategic partner, working closely with various teams to coordinate systematic database project plans that align with our organizational goals. Your contributions will not go unnoticed - you'll have the opportunity to propose and implement enhancements that will improve the performance and reliability of the system, enabling us to deliver world-class services to our customers.
Your Future at Kyndryl
Every position at Kyndryl offers a way forward to grow your career, from Junior Administrator to Architect. We have training and upskilling programs that you won’t find anywhere else, including hands-on experience, learning opportunities, and the chance to certify in all four major platforms. One of the benefits of Kyndryl is that we work with customers in a variety of industries, from banking to retail. Whether you want to broaden your knowledge base or narrow your scope and specialize in a specific sector, you can find your 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.
 

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 Experience

· 11 to 15 Years of Experience in Mainframe DB2 Database administration.

· Responsibilities for this job role include, but are not limited to, installation and maintenance of the databases, DB2 upgrades and patches checkouts, performance and capacity monitoring & management, and security compliance.

· Monitoring health check jobs like Image copy, Runstats, DDL$DML reports.

·Rebalancing of Partitions.

·Space Management and Monitoring.

·Performed End-to-End Release activities

·Creating and scheduling utilities like COPY, Reorg, RUNSTATS and QUIESCE.

·Running Adhoc Reorgs, Runstats and Rebinds in Productions Environment.

· Implementing and scheduling production DB2 jobs.

· Monitoring on daily, weekly and monthly batch cycles.

Preferred Skills and Experience

•Housekeeping and Maintenance of files owned by DB2 Database.

•Tuning of Databases and DB parameters

•Tablespace Migration.

•Provided 24*7 production support on rotation basis


Being You

Diversity is a whole lot more than what we look like or where we come from, it’s how we think and who we are. We welcome people of all cultures, backgrounds, and experiences. But we’re not doing it single-handily: Our Kyndryl Inclusion Networks are only one of many ways we create a workplace where all Kyndryls can find and provide support and advice. This dedication to welcoming everyone into our company means that Kyndryl gives you – and everyone next to you – the ability to bring your whole self to work, individually and collectively, and support the activation of our equitable culture. That’s the Kyndryl Way.


What You Can Expect

With state-of-the-art resources and Fortune 100 clients, every day is an opportunity to innovate, build new capabilities, new relationships, new processes, and new value. Kyndryl cares about your well-being and prides itself on offering benefits that give you choice, reflect the diversity of our employees and support you and your family through the moments that matter – wherever you are in your life journey. Our employee learning programs give you access to the best learning in the industry to receive certifications, including Microsoft, Google, Amazon, Skillsoft, and many more. Through our company-wide volunteering and giving platform, you can donate, start fundraisers, volunteer, and search over 2 million non-profit organizations.  At Kyndryl, we invest heavily in you, we want you to succeed so that together, we will all succeed.

Get Referred!

If you know someone that works at Kyndryl, when asked ‘How Did You Hear About Us’ during the application process, select ‘Employee Referral’ and enter your contact's Kyndryl email address.

Top Skills

Db2
Jcl
Rexx
SAS
Vsam
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: New York City, NY
46,070 Employees
On-site Workplace
Year Founded: 2021

What We Do

We have the world’s best talent that design, run, and manage the most advanced and reliable technology infrastructure each day. Together, we think holistically about the health of these vital technology ecosystems.

We are a focused, independent company that builds on our foundation of excellence by creating systems in new ways. Bringing in the right partners, investing in our business, and working side-by-side with our customers to unlock potential. We're raising the bar.

Our experience speaks for itself: We have 90,000 highly skilled employees around the world serving 75 of the Fortune 100. But our purpose is what drives us: Advancing the vital systems that power human progress. Because when a digital ecosystem is healthy, it can more readily adapt and support continuous growth and that opens up a world of possibility for everyone.

Similar Jobs

Toast Logo Toast

Senior Software Engineer -IOS

Cloud • Fintech • Food • Information Technology • Software • Hospitality
Chennai, Tamil Nadu, IND
5000 Employees

Veeva Logo Veeva

Migration Consultant

Big Data • Cloud • Healthtech • Software • Big Data Analytics
Remote
Chennai, Tamil Nadu, IND
6000 Employees

Bounteous Logo Bounteous

Senior Braze Developer

Agency • Digital Media • eCommerce • Professional Services • Software • Analytics • Consulting
Hybrid
Chennai, Tamil Nadu, IND
4000 Employees

Bounteous Logo Bounteous

Senior Technical Architect, E-Commerce

Agency • Digital Media • eCommerce • Professional Services • Software • Analytics • Consulting
Chennai, Tamil Nadu, IND
4000 Employees
100K-160K

Similar Companies Hiring

Quantum Rise Thumbnail
Software • Professional Services • Natural Language Processing • Machine Learning • Consulting • Automation • Artificial Intelligence
Chicago, Illinois
17 Employees
RunPod Thumbnail
Software • Infrastructure as a Service (IaaS) • Cloud • Artificial Intelligence
Charlotte, North Carolina
62 Employees
HERE Technologies Thumbnail
Software • Logistics • Internet of Things • Information Technology • Computer Vision • Automotive • Artificial Intelligence
Amsterdam, NL
6000 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account