Z/Os Mainframe Ims Db2 Database Administrator

**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 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.

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.

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.

**Position Summary**:
The Database Administrator creates, maintains, designs, monitors and troubleshoots client IMS databases and DB2 objects. Proficient with IBM IMS and DB2 database management utilities, develop and implement database recovery mechanisms and procedures for both IMS and DB2 components, and coordinate security measures to safeguard IMS and DB2 database integrity.

To lead DB2 z/OS projects and initiatives, working together with experienced DB2 z/OS and IMS DBAs.
- To work closely with IMS and DB2 z/OS System Programmers on IMS and DB2 z/OS systems and tools upgrades.

**Key Areas**:

- The individual will need to work with vendor personnel to achieve timely solutions of database problems.
- The individual will be responsible for day-to-day database maintenance such as creating backups, performing restores, monitoring file extent growth, scheduling reorganizations, creating and maintaining DR procedures and overall support of customer needs and requests.
- Expertise and work efforts will focus on the development and support and/or the customization of new services and support efforts.
- To ensure that all databases and environmental changes are appropriately tested and implemented in such a manner that there is no impact to the systems and clients.
- System programming knowledge of multiple DBMS's is a bonus.The individual will need to participate in on-call responsibilities.

**Who You Are**

**Required Qualifications**
- Bachelor's degree required and/or equivalent work experience.
- 10+ years of professional experience in IMS and DB2 database administration.
- BMC COPE and IBM tools for IMS and DB2.
- IMS and DB2 systems programming support is a plus
- Extensive experience with the following:

- Knowledge of the best practices of software management, maintenance and documentation
- Establishing policies and procedures pertaining to database management, DR, maintenance and utilization
- Evaluating change requests and determine impact to assigned clients
- Vendor consultations for problems and questions
- Troubleshooting and solving production database issues
- Demonstrated ability to respond quickly and effectively to support requests from client
- Supporting customer for after hours on-call

**Database Administration**
- Deep knowledge of IMS database organization using access methods of VSAM and OSAM
- Full function database organization types
- HSAM, HISAM, SHISAM, HDAM, HIDAM, INDEX, GSAM
- Definition and use of LOGICAL databases
- HALDB (partitioned): PHDAM, PHIDAM, ILDS, PSINDEX, etc.
- Fast Path databases (DEDBs)
- Broad knowledge of DB2 for Z/OS database components and concepts
- DB2 Program Preparation, Bind and Locking
- DB2 Storage Concepts

**Database Design and related utilities**
- DBD