DB2 z/OS DBA and Systems Programmer

Job Description
At the Constellation Insurance family of companies, we are committed to fostering a workplace where diversity, inclusivity and equity are celebrated.
If you're passionate about our mission but don't perfectly fit every requirement, we encourage you to apply -- your unique skills and experiences could make you the perfect fit for this role or others within our organization.
What you will be doing
The Systems Programmer Engineer is responsible for providing comprehensive production support, project assistance, and handling service requests, incidents, and problem management for mainframe Systems Software and hardware. This role involves utilizing a wide range of technologies, systems, and tools essential for supporting the business while adhering to change management protocols and delivering exceptional customer service.
Key Focus: This position will primarily concentrate on DB2 for z/OS DBA tasks.

• Deliver expert support for SQL development and optimization on DB2 V12.1 -- V13.1.
• Manage and support DB2 V12.1 -- V13.1 across test, QA, and production environments.
• Facilitate seamless CICS and IMS attachment to DB2 V12.1 -- V13.1.
• Oversee the administration and use of the DB2 V12.1 -- V13.1 Administration Tool and Object Comparison Tool.
• Customize and support File-Aid for DB2 to enhance database management.
• Ensure a well-managed change environment for DB2 V12.1 -- V13.1 using Changeman ZMF.
• Responsible for the architecture, life-cycle management, configuration, maintenance, and support of assigned mainframe System Software and Hardware.
• Provides excellent customer service by monitoring and responding to Technical Services related incidents, service requests, and project tasks.
• Interacts with cross-discipline support teams to resolve issues, develop, and deliver solutions.
• Provides training to IT and business units on the use of mainframe System Software.
• Monitors system logs for anomalies and resolves complex issues.
• Acts as a subject matter expert and support for one or more primary technologies or processes, including other IBM and ISV mainframe System Software products.
• Works closely with Audit and Security teams to address outstanding items and prioritize remediation tasks, notifying IT Security of possible exposures.
• Completes required PMO documentation, time entry, status reports, and contributes to the annual budget process.

What Benefits Await You
At Constellation, we believe in rewarding our associates for their hard work. Here's what you can expect:

• Competitive Compensation: Your hard work deserves fair and competitive pay.
• Comprehensive Healthcare : Enjoy peace of mind with medical, dental, and vision coverage from your first day.
• Secure Your Future : Take advantage of our generous 401(k) matching program to build your nest egg.
• Support for Growing Families : Receive support during one of life's most significant moments which include paid parental leave and financial reimbursement for adoption and surrogacy related expenses.
• Invest in Yourself: We're committed to your growth. Get support for your education with tuition reimbursement.
• Work-Life Balance : Enjoy flexibility with our accommodating time-off policy, so you can recharge and pursue your passions outside of work.

Requirements
What Sets You Up for Success

• Minimum of 4+ years of satisfactory full-time experience in a Systems Programming or related position
• Customer service experience
• Bachelor's Degree or equivalent in Information Systems or a related field from an accredited college, preferred
• ITIL Foundations Certification, preferred
• IMS DataBase and Transaction Manager, preferred

Why You'll Love Working With Us
We're not just another company -- here's what sets us apart:

• Respect and Value: Join a team where every individual is respected and valued for their unique contributions.
• Flexible work: Enjoy the flexibility to choose from remote, traditional, or hybrid work arrangements that suit your lifestyle.
• Your Well-being Matters: Take advantage of our tailored associate well-being programs crafted to support your journey towards a healthy work-life balance.
• Stay Connected: Engage with your colleagues both in-person and virtually through various associate resources groups to support your professional and personal growth.
• Express Your Style : Embrace our 'Dress for your day' policy, allowing you to dress comfortably and confidently while at work.

Compensation Statement
Individual compensation packages are based on various factors unique to each candidate, including skill set, experience, qualifications, and other job-related reasons. Roles may also be eligible for additional compensation, including annual incentive programs.