K&K Global Talent Solutions INC. · 1 day ago
DB2/IMS Lead Database Administrator
United States
Contract
Remote
Senior Level, Lead/Staff
10+ years expK&K Global Talent Solutions INC. is seeking a highly experienced DB2/IMS Lead Database Administrator to join their production support team. The role involves maintaining the stability, availability, and performance of DB2 and IMS databases, providing 24/7 support, troubleshooting issues, and optimizing database performance.
Hiring Manager
Sachin Chaudhary
Responsibilities
Provide 24x7 support for DB2 and IMS database environments, including on-call rotation
Monitor database performance, availability, and integrity using mainframe tools and utilities
Respond to incidents, troubleshoot issues, and resolve problems related to DB2/IMS systems
Perform database backup and recovery procedures for DB2 and IMS databases
Conduct regular reorgs, image copies, and utilities execution (RUNSTATS, REORG, CHECK)
Support DB2 and IMS subsystem maintenance, upgrades, and patching
Analyze and tune SQL queries, buffer pools, and access paths in DB2
Optimize IMS database segments, DBDs, PSBs, and access methods
Work with developers to design efficient data access strategies
Review and implement database schema changes via Change Control processes
Participate in software releases, ensuring database readiness and minimal impact on production
Manage user access, RACF integration, and permissions in DB2/IMS environments
Ensure compliance with enterprise security standards and data privacy regulations
Maintain accurate and up-to-date documentation, including runbooks, architecture diagrams, and operational procedures
Collaborate with application teams, infrastructure, and middleware teams to support business applications
Qualification
Required
10+ years of administrator experienced and detail-oriented DB2 and IMS Database Administrator (DBA)
Proven experience as a DB2/IMS Databases Administrator or similar role in production support environments
10+ years of hands-on experience supporting DB2 for z/OS and IMS (Information Management System) in a production environment
Strong knowledge of mainframe tools such as SPUFI, QMF, BMC, CA-DB2/IMS tools, and IBM utilities
Deep understanding of DB2 database internals, logs, buffer pools, catalog/directory, and utilities
Proficient in IMS Full-Function and Fast Path databases, DL/I calls, PSB/DBD maintenance
Solid experience with JCL, TSO/ISPF, SDSF, and mainframe batch job troubleshooting
Experience with modern mainframe automation tools and schedulers (e.g., Control-M, CA-7)
Understanding of DB2 Data Sharing and IMS Sysplex environments
Experience with backup and recovery solutions
Solid knowledge of Linux/Unix systems and scripting (Shell, Python, or similar)
Proficiency in troubleshooting performance tuning, and capacity planning
In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
Strong troubleshooting and problem-solving skills
Excellent communication and collaboration abilities
Ability to work in a 24/7 support rotation and handle urgent production issues
Familiarity with data security is the best practice and backup procedures
Preferred
Experience working in regulated environments (e.g., insurance, banking, healthcare) with audit and compliance exposure
IBM Certified Database Administrator – DB2 for z/OS certification
Knowledge of COBOL, CICS, and batch job data flows
Understanding of DB2 Data Sharing and IMS Sysplex environments
Education qualification: Any degree from a reputed college
Company
K&K Global Talent Solutions INC.
K&K Global Talents Solutions Inc: A New Era in the US Recruitment Industry With their partnership with a highly reputable German recruitment firm boasting over 30 years of experience, K&K Global Talents Solutions Inc.
11-50 employees
Funding
Current Stage
Early StageCompany data provided by crunchbase