Lead Database Administrator jobs in United States
cer-icon
Apply on Employer Site
company-logo

Galent · 12 hours ago

Lead Database Administrator

Galent is seeking a Lead Database Administrator with expertise in DB2 and IMS to join their production support team. The role involves maintaining the stability and performance of databases, providing 24/7 support, troubleshooting issues, and ensuring compliance with security standards.

Computer Software
Hiring Manager
Prashanth Rajendran
linkedin

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

DB2 Database AdministrationIMS Database AdministrationMainframe Tools ProficiencyBackupRecovery SolutionsIBM Certified DBAPerformance TuningJCLTSO/ISPFCOBOLCICS KnowledgeProblem-Solving SkillsCommunication SkillsCollaboration Abilities

Required

Strong experience in IMS Admin for at least 1-2 years
4+ years of administrator experienced and detail-oriented 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 (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
4+ years overall IT experience

Company

Galent

twitter
company-logo
Galent is an AI-native digital engineering firm at the forefront of the AI revolution, dedicated to delivering unified, enterprise-ready AI solutions that transform businesses and industries.

Funding

Current Stage
Late Stage
Company data provided by crunchbase