KK Software Associates · 1 week ago
DB2/IMS Lead Database Administrator || Houston, TX (Hybrid)/
Houston, TX
Contract
Hybrid
Mid, Senior Level
4+ years expKK Software Associates is seeking a 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 on IBM mainframe environments, while providing 24/7 production support and troubleshooting issues.
Human ResourcesProject ManagementRecruitingStaffing Agency
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
Strong experience in IMS Admin for at least 1-2 years
4+ years of administrator experience as an IMS and DB2 Database Administrator (DBA)
Proven experience as a DB2/IMS Databases Administrator or similar role in production support environments
6+ years of hands-on experience supporting DB2 for z/OS and IMS 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)
Knowledge of COBOL, CICS, and batch job data flows
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 best practices and backup procedures
Experience working in regulated environments (e.g., insurance, banking, healthcare) with audit and compliance exposure
Education qualification: Any degree from a reputed college
4+ years overall IT experience
Preferred
IBM Certified Database Administrator – DB2 for z/OS certification
Company
KK Software Associates
At KK Software Associates, we specialize in talent management solutions, connecting businesses with top-tier professionals to drive success.
51-200 employees
H1B Sponsorship
KK Software Associates has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2024 (5)
2023 (10)
2022 (11)
2021 (22)
2020 (18)
Funding
Current Stage
Growth StageLeadership Team
Maheswara Kasa
President & CEO
Company data provided by crunchbase