SME - Mainframe DB2 DBA Administrator

8 - 13 years

30 - 35 Lacs

Posted:2 months ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

The Role As a System Administrator at Kyndryl, youll solve complex problems and identify potential future issues across the spectrum of platforms and services. Youll be at the forefront of new technology and modernization, working with some of our biggest clients which means some of the biggest in the world. Theres never a typical day as a System Administrator at Kyndryl, because no two projects are alike. Youll be managing systems data for clients and providing day-to-day solutions and security compliance. Youll oversee a queue of assignments and work directly with technicians, prioritizing tickets to deliver the best solutions to our clients. One of the benefits of Kyndryl is that we work with clients 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. Youll also get the chance to share your expertise by recommending modernization options, identifying new business opportunities, and cultivating relationships with other teams and stakeholders. Does the work get challenging at times? Yes! But youll collaborate with a diverse group of talented people and gain invaluable management and organizational skills, which will come in handy as you move forward in your career. Key Responsibilities: Performed by technical professionals responsible for the physical and technical aspects of a database systems. Manage and maintain DB2 database files to ensure optimal performance and storage efficiency. Set up and maintain DB2 subsystems, data sharing groups, and buffer pools. Monitor and manage tablespaces, indexes, partitions, and storage allocation. Tune DB2 memory structures, buffer pools, and access paths for efficiency. Diagnose and resolve DB2 performance issues, locking conflicts, and deadlocks. Work closely with application development teams to provide database support. Who You Are Youre 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, youre open and borderless naturally inclusive in how you work with others. Required Technical and Professional Expertise 8+ years of experience as a DB2 DBA on mainframe (z/OS) environments. Experience in database recovery, backup strategies, and housekeeping activities. Perform regular cleanup, archival, and reorganization of database objects. Create tablespaces (both system-managed and database-managed) based on business requirements Perform database recovery operations to restore data in case of failures. Bind packages to DB2 databases to optimize SQL execution plans. Create new DB2 objects (tables, views, indexes, stored procedures, etc.) based on project needs. Run RUNSTATS on tablespaces and indexes to maintain accurate statistics for query optimization. Preferred Technical and Professional Experience Strong analytical and problem-solving skills Effective communication and collaboration with development and infrastructure teams.

Mock Interview

Practice Video Interview with JobPe AI

Start Mainframe Db2 Interview Now

My Connections Kyndryl

Download Chrome Extension (See your connection in the Kyndryl )

chrome image
Download Now
Kyndryl
Kyndryl

Information Technology Services

New York

90,000+ Employees

531 Jobs

    Key People

  • Martin Schreiber

    Chairman and CEO
  • David H. McNarry

    Chief Financial Officer

RecommendedJobs for You

Andhra Pradesh, India

Gurgaon, Haryana, India

Delhi, Delhi, India

Noida Sector 62, Noida, Uttar Pradesh

Gurugram, Haryana, India

Nizamabad, Warangal, Hyderabad