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

Galent · 5 hours ago

Database Administrator

Galent is seeking an experienced IMS and DB2 Database Administrator to join their production support team. The role involves maintaining the stability and performance of DB2 and IMS databases on IBM mainframe environments, providing 24/7 support, and ensuring compliance with security standards.

Computer Software
Hiring Manager
Naveen Kumar Mugunthan
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/ISPFLinux/Unix ScriptingProblem-Solving SkillsCommunication SkillsCollaboration Abilities

Required

4+ years of administrator experience as a DB2/IMS Database Administrator (DBA)
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
IBM Certified Database Administrator – DB2 for z/OS certification
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