Mainframe DB2 Database Administrator – SME
Kyndryl
full-time
Posted on:
Location Type: Office
Location: Bangalore • India
Visit company websiteExplore more
About the role
- Contributing to current projects where you analyze problems and tech issues, offer solutions, and test, modify, automate, and integrate systems.
- Long-range strategic planning of IT infrastructure and operational execution.
- Involved early to offer solutions, help decide whether something can be done, and identify the technical and timeline risks up front.
- Dealing with both client expectations and internal challenges.
- Enjoy deep involvement throughout the lifespan of a project, as well as the chance to work closely with Architects, Technicians, and PMs.
Requirements
- 10 to 16 years of experience in Mainframe DB2 Database Administration.
- Responsible for installation, maintenance, and administration of DB2 databases, including upgrades, patch implementation, performance tuning, capacity planning, and ensuring security compliance.
- Monitor health check activities such as image copy jobs, RUNSTATS, and DDL/DML reports.
- Perform rebalancing of partitions to maintain optimal data distribution and performance.
- Manage and monitor database space utilization to ensure efficient storage allocation.
- Execute end-to-end release activities, including deployment, validation, and support.
- Create and schedule DB2 utilities such as COPY, REORG, RUNSTATS, and QUIESCE.
- Perform ad-hoc REORGs, RUNSTATS, and REBINDS in production environments to improve performance.
- Implement and schedule production DB2 jobs, ensuring timely and accurate execution.
- Monitor and support daily, weekly, and monthly batch cycles for smooth operations.
- Responsible for housekeeping and maintenance of DB2 database files to ensure integrity and optimal storage usage.
- Performed database tuning and optimization of DB2 parameters to achieve peak system performance.
- Executed tablespace migrations to support database restructuring and performance improvements.
- Provided 24/7 production support on a rotational basis, ensuring high availability, rapid issue resolution, and minimal downtime for critical systems.
Benefits
- 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.
- Many of our Infrastructure Specialists are on a path toward becoming either an Architect or Distinguished Engineer.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
Mainframe DB2 Database Administrationinstallationmaintenanceperformance tuningcapacity planningsecurity complianceDB2 utilitiesdatabase tuningtablespace migrationsproduction support
Soft skills
problem analysissolution offeringstrategic planningclient managementinternal communicationproject involvementrisk identification