Senior Mainframe Systems Programmer - Datacom

Ensono

5h•$85,000 - $148,000•Hybrid

About The Position

The successful candidate will perform mainframe database software upgrades coupled with administration and tuning to support our customers’ CA Datacom environments. They will be called upon to perform a variety of tasks including database optimization, database performance reviews and tuning, and new client onboarding. The individual will need to work with vendor personnel to achieve timely solutions of database problems. They will also be responsible for day-to-day database maintenance such as database definition changes, backups and restores, monitoring space growth, database reorganizations, creating and maintaining disaster recovery procedures and overall support of customer needs and requests. 24x7 on call support will be required as part of a scheduled rotation with other team members. The individual will maintain documentation for all the tasks completed on a regular basis and adhere the change management policy.

Requirements

Bachelor’s degree or equivalent work experience.
10+ years of professional experience in CA Datacom and related products for administration and systems programming support.
Experience in a large, 24x7 environment.
Ability to manage competing priorities.
Demonstrated ability to respond quickly and effectively to support requests from multiple clients.
After hours on-call support.
Ability to write, debug and tune SQL.
Previous experience in a CA Datacom environment required.

Nice To Haves

Self-motivated and able to work independently.
Excellent communication skills (written, verbal and presentations).
Ability to work as part of a team and assist teammates when needed.
System programming knowledge of multiple DBMS’s is a bonus.

Responsibilities

Perform mainframe database software upgrades, administration, and tuning for CA Datacom environments.
Optimize database performance and conduct performance reviews.
Onboard new clients.
Work with vendor personnel to resolve database problems.
Perform day-to-day database maintenance including definition changes, backups, restores, space monitoring, and reorganizations.
Create and maintain disaster recovery procedures.
Provide overall support for customer needs and requests.
Provide 24x7 on-call support on a scheduled rotation.
Maintain documentation for all completed tasks.
Adhere to the change management policy.
Configure and manage CA Datacom, CA Datacom CICS Services, CA Datacom Server, CA Ideal, and related products (CA Dataquery, VSAM Transparency, CA IPC).
Develop strategies, processes, and best practices in CA Datacom systems programming.
Establish policies and procedures for database management, disaster recovery, product and database security, maintenance, and utilization.
Review new versions of CA Datacom and related products for functionality and advise on client benefits.
Interact with vendors for problems and questions.
Manage disaster recovery of system and application databases.
Troubleshoot and solve production database issues.
Identify and resolve performance issues.
Administer and customize CA Datacom, CA Dataquery, CA Datacom CICS Services, CA Ideal, and CA IPC.
Perform database design and work with batch and online CA Datadictionary.
Monitor databases, including space and performance monitoring using CA Sysview.
Utilize CA Datacom and related products utilities.
Support planned (disaster recovery) and unplanned (emergency) database recovery activities.

Benefits

Unlimited Paid Days Off
Three health plan options
401k with company match
Eligibility for dental, vision, short and long-term disability, life and AD&D coverage, and flexible spending accounts
Paid Maternity Leave
Paternity Leave
Sabbatical Leave
Education Reimbursement
Student Loan Assistance
529 College Funding
Enhanced fertility coverage
Wellness program
Flexible work schedule
Fitness centers (depending on location)