Logo of Huzzle

Home

Matches

Explore

Manage

Database Administrator - DB2

image

Kyndryl

12d ago

  • Job
    Full-time
    Expert Level
  • Software Engineering
    IT & Cybersecurity
  • Bangalore
  • Quick Apply

AI generated summary

  • You need 10+ years of DB2 admin experience on UNIX, Linux, Windows, HADR setup, cloud knowledge, SQL shell scripting, and effective communication skills.
  • You will configure HADR, tune DB2 performance, troubleshoot issues, drive incident resolution, review incidents with L3, suggest improvements, and monitor L1 engineers' performance.

Requirements

  • Required Technical and Professional Expertise
  • Administrating db2 database on UNIX, LINUX, WINDOWS as per the requirement and Configuring and maintaining HADR (Primary ,Standby database) for production database for Take over, Fail over activating the standby to primary for zero data loss
  • Ability to communicate effectively, both verbal and written
  • Hands-on experience in at least one of the following: software development, DevOps engineering, systems administration, or systems architecture in public cloud AWS domain
  • In case the incident is repeated, log the incident as a problem ticket and the resolution of an incident requires change, initiate the change management process
  • Review of the patch management details with respect to System and database. To check on the latest update patch and same need to implement of test database and then production database after getting approval of CRF form as per the SOW
  • Ensure that the database(s) created and change requests on databases as per latest OSG guidelines and Week end Extended / On call support during any emergency / Scheduled Activity / Business requirements
  • UNIX, Linux and Windows Operating systems SQL Shell scripting Knowledge
  • Preferred Technical and Professional Experience
  • Any Graduation or B.E or any Equivalent Degree
  • Experience: 10+ Years of Technical Hands-On

Responsibilities

  • Responsibilities
  • Configuring and maintaining HADR (Primary, Standby database) for production database for Take over, fail over activating the standby to primary for zero data loss.
  • Performance tuning using db2advis and db2expln tools and Troubleshooting db performance related issues using MONREPORT module reports taking Snapshot, db2diag, db2pd, db2top and Troubleshooting db2 errors and contacting IBM PMR support for bug fixes.
  • Drive the L1 engineers to incident closure.
  • Ensure defined resolution SLAs are.
  • Review the incidents in the shift with the L3 engineer at end of shift.
  • Suggest remedial measures to bring down the number of incidents recorded and ensure the shift handover report is handed over to the L2 engineer of the next shift and monitor and audit the performance of the L1 engineers periodically.

FAQs

What is the main focus of the Database Administrator - DB2 role at Kyndryl?

The main focus of the role is to configure, maintain, and troubleshoot DB2 databases, specifically managing High Availability Disaster Recovery (HADR) configurations, performance tuning, and providing hands-on support to ensure the integrity and performance of production databases.

What type of experience is required for this position?

A minimum of 10+ years of technical hands-on experience in DB2 database administration on UNIX, LINUX, and WINDOWS operating systems is required, along with SQL shell scripting knowledge.

What kind of tools will I be using in this role?

You will be using tools such as db2advis, db2expln, MONREPORT, db2diag, db2pd, and db2top for performance tuning and troubleshooting DB2 performance-related issues.

Are there opportunities for professional growth at Kyndryl?

Yes, Kyndryl offers various training and upskilling programs, providing opportunities for employees to grow from Junior Administrator to Architect and gain certifications in all major platforms.

How does Kyndryl approach diversity and inclusion?

Kyndryl values diversity in thinking and experiences, creating an inclusive workplace through various initiatives, including Kyndryl Inclusion Networks, allowing employees to bring their whole selves to work.

What is the work environment like for this position?

The work environment is project-based and collaborative, involving close interaction with Architects, Technicians, and Project Managers, ensuring a dynamic and engaging experience without boredom.

Is there support for on-call or extended weekend activities?

Yes, the role includes on-call support for emergencies and scheduled activities as per business requirements.

What is the significance of client interaction in this role?

The role involves significant client interaction, providing opportunities to influence client expectations and build long-term relationships, enhancing the chances of being requested again for future projects.

Do I need a specific degree to apply for this position?

Any graduation degree, B.E., or an equivalent degree is preferred for this position.

What kind of benefits does Kyndryl offer to its employees?

Kyndryl offers a range of benefits designed to reflect the diversity of its employees, support well-being, and provide resources for personal and professional growth, including access to learning programs and volunteering opportunities.

Kyndryl

We design, build, manage and modernize the mission-critical technology systems that the world depends on every day.

Consulting
Industry
10,001+
Employees
2021
Founded Year

Mission & Purpose

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. Together, we are the heart of progress.