IMS Database Administrator

enGen; United States; On-site; USD 94,000 - 151,000; Full time

Job summary

enGen is seeking an IMS DBA to design, install, configure, and maintain IMS Full Function, HALDB and IMS Fastpath databases within a z/OS Parallel Sysplex environment.

The role requires expertise in performance tuning, high availability, backup and recovery strategies, and expert IMS issue resolution. Collaboration with application teams and system programmers is essential; on-call rotation included.

Strong knowledge of DBRC, PSB/DBD/ACB generation and IBM/BMC utilities preferred.

Qualifications

• 3-5 years of experience in Information Technology.
• Experience with IMS databases on z/OS.
• Familiarity with HALDB and FastPath.
• Knowledge of DBRC and IBM/BMC utilities.
• On-call rotation and data governance compliance.

Responsibilities

• Lead design, installation, and maintenance of IMS databases in a z/OS environment.
• Tune and monitor database performance for high availability.
• Administer HALDB databases and manage partition definitions.
• Develop backup and recovery strategies and perform root cause analysis.
• Provide expert IMS support with cross-team collaboration.
• Participate in on-call rotation.

Skills

IMS Full Function

HALDB

IMS Fastpath

z/OS Parallel Sysplex

Performance tuning

Education

High school diploma GED

Tools

IBM Utilities

BMC Utilities

DBRC

PSB/DBD/ACB generation

Job description

• CANDIDATE MUST BE US Citizen (due to contractual/access requirements) ***

Company

enGen

Job Description

JOB SUMMARY

This role encompasses the design, installation, configuration, and maintenance of IMS Full Function, HALDB and IMS Fastpath databases within a z/OS Parallel Sysplex environment. Key responsibilities also include performing database performance tuning, monitoring, and optimization to guarantee high availability and responsiveness. The individual will manage and administer Hierarchical Access Method (HALDB) databases, including their partition definition and management, and develop, implement, and maintain comprehensive database backup and recovery strategies. The position requires knowledge of IBM and BMC Utilities and knowledge of PSB/DBD/ACB generation and implementation along with working knowledge of DBRC. Furthermore, this position requires providing expert-level support for IMS-related issues, encompassing problem diagnosis, resolution, and root cause analysis. Collaboration is crucial, involving work with application development teams, system programmers, and other infrastructure teams to ensure the seamless integration and support of IMS applications. Adherence to Highmark's data governance policies is essential. The role also involves participation in an on-call rotation to provide 24/7 support for critical IMS systems.

ESSENTIAL RESPONSIBILITIES

• Take a lead role to create, develop, and review the physical model created from the logical model, ensuring that the detailed physical design of data structures and databases complies with standards, guidelines and procedures recommended for all aspects of more complex data modeling, database design, and maintenance.
• Take a lead role to provide support for application staff and business areas regarding more complex database implementations, which could include a customized in-house database and/or a third party application package.
• Establish automated monitor mechanism for space and database availability conditions. Establish best practices for database and application high availability through the use of third party technologies and through the exploitation of various database features.
• Take a lead role in providing applications support for staff, as well as, outside division to answer questions and resolve problems related to the DBMS technology and computing platform such as Z/OS, UNIX, Linux, and Windows
• Take a lead role in conducting root cause analysis to identify and resolve problems impacting more complex application and/or database availability and service levels.
• Contact vendor support when necessary to facilitate application development and client problem resolution with optimum speed and efficiency.
• Provide after hours and weekend support as required for on call responsibilities, database refreshes, testing, technology upgrades, and other off hour assignments.
• Take a lead role and participates in establishing and maintaining technical standards, departmental procedures, and other technical documentation as required. Assure compliance to required Corporate standards, procedures, guidelines and processes, including audits.
• Take a lead role in identifying, developing, and providing technology training to the application developers of the organization (formal and informal).
• Participate in staff training opportunities (formal and informal) relative to rules, procedures, and standards for the access and maintenance of shared data resources.
• Take a lead role and participates as assigned to intra and inter-departmental project initiatives.
• Participate as assigned in the testing and recommendation of more complex tools and utilities to improve the effectiveness of managing and supporting the database environments.
• Maintain contacts with other DBA professionals externally in other Health Insurance/Health Care industries and/or other industries to maintain a perspective of current trends and best practices.
• Other duties as assigned or requested.

EDUCATION

Minimum

• High school diploma GED

Substitutions

• None

Preferred

• None

EXPERIENCE

Required

• 3-5 years of experience in Information Technology

Preferred

• Health insurance business knowledge.

LICENSES/CERTIFICATIONS

Required

• None

Preferred

• Vendor DBA Certifications for the relevant DBMS

Language (Other Than English)

None

Travel Requirement

0% - 25%

PHYSICAL, MENTAL DEMANDS and WORKING CONDITIONS

Position Type

• Office-based
• Teaches / trains others regularly
• Occasionally
• Travel regularly from the office to various work sites or from site-to-site
• Rarely
• Works primarily out-of-the office selling products/services (sales employees)
• Never
• Physical work site required
• Yes
• Lifting up to 10 pounds
• Constantly
• Lifting 10 to 25 pounds
• Occasionally
• Lifting 25 to 50 pounds
• Rarely

Compliance Requirement

The job description has been designed to indicate the general nature and essential duties and responsibilities of work performed by employees within this job title. It may not contain a comprehensive inventory of all duties, responsibilities, and qualifications required of employees to do this job.

This job adheres to the ethical and legal standards and behavioral expectations as set forth in the code of business conduct and company policies.

As a component of job responsibilities, employees may have access to covered information, cardholder data, or other confidential customer information that must be protected at all times. In connection with this, all employees must comply with both the Health Insurance Portability Accountability Act of 1996 (HIPAA) as described in the Notice of Privacy Practices and Privacy Policies and Procedures as well as all data security guidelines established within the Company’s Handbook of Privacy Policies and Practices and Information Security Policy.

Highmark Health and its affiliates prohibit discrimination against qualified individuals based on their status as protected veterans or individuals with disabilities and prohibit discrimination against all individuals based on any category protected by applicable federal, state, or local law.

We endeavor to make this site accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact the email below.

For accommodation requests, please contact HR Services Online at [e-mail]

California Consumer Privacy Act Employees, Contractors, and Applicants Notice

Pay Range Minimum

$94,200.00

Pay Range Maximum

$151,000.00

Base pay is determined by a variety of factors including a candidate’s qualifications, experience, and expected contributions, as well as internal peer equity, market, and business considerations. The displayed salary range does not reflect any geographic differential Highmark may apply for certain locations based upon comparative markets.