Senior Mainframe Database Administrator

Unum Group-posted 1 day ago
Full-time • Senior
Columbia, SC
5,001-10,000 employees
Resume
Match Score
Upload and Match ResumeTrack Jobs with Teal

Our Fortune 500 company is driving a digital transformation and looking for forward-thinking innovators to disrupt how our industry thinks about and uses technology. As one of the world's leading employee benefits providers, we help millions of people gain affordable access to benefits that help them protect their families, their finances and their futures. Are you an asker of questions, a solver of problems, and a challenger of the status quo? Our mission is to provide a differentiated customer experience and exceed the expectations people have of technology at any company — not just insurers. We are seeking individuals to join our team of talented IT professionals who share never-ending passion and an unwavering focus on our customer experience. Team members comfortable working in an agile, fast-paced, and delivery-focused environment thrive in our environment where we value an entrepreneurial spirit and those who challenge the status-quo. Unum is changing, and we’re excited about what’s next. Join us. General Summary: Unum is seeking a senior level IMS Database Administrator position in a challenging IMS and DB2 hosted environment. A team-oriented spirit is necessary to function in a highly collaborative environment. The platform environment is an IMS z/OS based benefits platform that has an ever-growing dynamic workload. Unum is seeking a senior level IMS Database Administrator position in a challenging IMS and DB2 hosted environment. A team-oriented spirit is necessary to function in a highly collaborative environment. The platform environment is an IMS z/OS based benefits platform that has an ever-growing dynamic workload.

  • 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.
  • 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. FORMAT coding is a plus, but not required. 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 and experience with DB2 Administration tool or similar tool is a plus.
  • 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.
  • Familiarity with RACF, rules protecting datasets, and how RACF interacts with both IMS and DB2 instances is a plus.
  • 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.
  • Experience with System Display and Search Facility [SDSF] or other z/OS JES output control facility is a plus.
  • Candidate resource is on-call on a rotational basis (Typically one week out of five weeks).
  • FORMAT coding is a plus, but not required.
  • 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
  • Understanding of DB2 Data Definition Language [DDL] constructs is required and 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.
  • onsite fitness facilities
  • generous paid time off
  • employee professional development programs
  • healthcare benefits (health, vision, dental)
  • insurance benefits (short & long-term disability)
  • performance-based incentive plans
  • paid time off
  • a 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
Track Jobs with Teal

Job Search Resources

•
Resume Builder
•
Resume Examples
•
Cover Letter Examples

Tools

Career Hubs

Guides

Company

© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service