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 & Tools
Mainframe DB2 Database Administrationinstallationmaintenanceperformance tuningcapacity planningsecurity complianceDB2 utilitiesdatabase tuningtablespace migrationsproduction support
Soft Skills
problem analysissolution offeringstrategic planningclient managementinternal communicationproject involvementrisk identification