Sr. Mainframe Database Administrator (IMS) jobs in United States
cer-icon
Apply on Employer Site
company-logo

Unum · 1 day ago

Sr. Mainframe Database Administrator (IMS)

Unum is a Fortune 500 company driving a digital transformation in the employee benefits sector. They are seeking a senior level IMS Database Administrator to manage and support a complex IMS and DB2 hosted environment, focusing on production data maintenance and problem-solving.

FinanceFinancial ServicesInsurance
check
H1B Sponsor Likelynote

Responsibilities

Managing procedures and tools required to support development and testing activities
Assisting in all operational environments in the maintenance of production data and data archiving
Functioning as a Subject Matter Expert (SME) for solving complex problems and supporting IMS and stored procedure calls
Possess the ability to connect the dots from infrastructure back to application
Works with the Project Manager, and the Release Coordinators to control changes made to supported databases
Work as a member of a team in support of day-to-day production, conversions, application and enterprise IT projects, disaster recovery, logical/physical database design and performance tuning
Ability to troubleshoot IMS service calls from a host and distributed environment and provide timely responses to client requests and queries and resolves client issues in a timely fashion
Provide on-call support on a rotational basis outside normal business hours as needed
DB2 Experience is a plus
Experience with High Available Lage Database (HALDB) software
Candidate resource is on-call on a rotational basis (Typically one week out of five weeks)

Qualification

IMS Database AdministrationDB2 AdministrationZ/OS EnvironmentHALDB PartitioningSQL KnowledgeJCL KnowledgeSoft Skills

Required

6+ years of DBA experience in a z/OS / MVS environment
6+ years database administration for IMS in an IBM mainframe environment
4-year college degree or equivalent
IMS for z/OS
Knowledge of IMS Database Manager, DBD source and generation, understanding of Database Recovery Control [DBRC] information and commands, BMP and basic DL/I coding imbedded in COBOL source
Familiarity with IMS Transaction Manager, including basic control region and message region processing, PSB coding and generation, and ACB, MODBLKS, and FORMAT generation
A basic knowledge of Control Region commands for monitoring Sub-systems, Regions, Databases, and Transaction Queues is required
Strong working knowledge of HALDB partitioning schemes and underlying structures
Ability to backup and restore and maintain partitions
Familiarity with IMS Utility JCL, execution, restart, commands for Database allocation changes, and IMS Database backup and recovery techniques
DB2 for z/OS
DB2 Catalog knowledge [Basic catalog table familiarity, ability to perform querying of dependencies, understanding of DB2 security administration including Grants, Revokes, and a basic knowledge of required authorities for application development including Bind, Plans, Packages, Stored Procedures, and Database level authorities permitting utilities, tablespace and table creation]
Familiarity with DB2 Utility JCL, execution, restart, an understanding of utility impact on DB2 object availability, and Database backup and recovery techniques
Understanding of DB2 Data Definition Language [DDL] constructs is required
Knowledge of SQL and basic DB2 development techniques used in application coding
Ability to understand COBOL and SQL/PL for analysis and partnering with application area personnel
z/OS, TSO, ISPF, JCL, and SDSF
Coding and debugging z/OS mainframe batch jobs, the applicant's work and for application development team members needing assistance is required
JCL knowledge is a must as is basic ISPF menu and TSO development experience
Knowledge of source code editor commands, library maintenance, ISPF menus, listing of cataloged dataset information, TSO job scheduling, and the ability to read JES output from jobs to diagnose issues is required

Preferred

FORMAT coding is a plus, but not required
Experience with DB2 Administration tool or similar tool is a plus
Familiarity with RACF, rules protecting datasets, and how RACF interacts with both IMS and DB2 instances is a plus
Experience with System Display and Search Facility [SDSF] or other z/OS JES output control facility is a plus
DB2 Experience is a plus
Experience with High Available Lage Database (HALDB) software

Benefits

Healthcare benefits (health, vision, dental)
Insurance benefits (short & long-term disability)
Performance-based incentive plans
Paid time off
401(k) retirement plan with an employer match up to 5% and an additional 4.5% contribution whether you contribute to the plan or not

Company

Since our founding in 1848, Unum has been a leader in the employee benefits business through innovation, integrity and an unwavering commitment to our customers.

H1B Sponsorship

Unum 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 (27)
2024 (23)
2023 (26)
2022 (19)
2021 (18)
2020 (7)

Funding

Current Stage
Public Company
Total Funding
$700M
2025-11-11Post Ipo Debt· $300M
2024-06-05Post Ipo Debt· $400M
1986-11-14IPO

Leadership Team

leader-logo
Curt Burghardt
Vice President People Delivery
linkedin
leader-logo
Mike Schubert
Vice President Of Technology
linkedin
Company data provided by crunchbase