Remote Mainframe DB2 Systems Programmer

Ensono; Trenton (NJ); Remote; USD 65,000 - 123,000; Full time

Benefits offered by this job

Unlimited Paid Days Off

Health plan options

401k with company match

Fertility coverage

Job summary

Ensono seeks a Mainframe Systems Programmer to provide premium DB2 sysprog support for our mainframe clients in the United States. The role covers DB2 upgrades, administration, tuning, DR procedures, and 24x7 support across time zones, with on-call responsibilities.

You will collaborate with vendor personnel, perform backups/restores, monitor and optimize DB2 environments, and participate in customer migrations and DR planning.

Qualifications

• Bachelor’s degree or equivalent work experience.
• 5+ years of professional experience in DB2 administration and systems programming.
• Knowledgeable in software management, maintenance and documentation.
• SMP/e experience.
• Experience configuring and managing DB2 in a parallel sysplex environment.
• Ability to develop innovations, strategies and best practices in software management.
• Experience establishing policies for database management, DR, security and maintenance.
• Experience reviewing new DB2 versions for functionality and client benefits.
• Ability to evaluate change requests and troubleshoot production DB2 issues.
• Experience supporting DB2 security requests.
• Ability to review DB2 security for risks.
• Experience with reorganization of application data.
• Experience tuning internal DB2 buffer pools and SQL code.
• Demonstrated ability to respond quickly to multiple clients.

Responsibilities

• Provide premium DB2 sysprog support for Ensono mainframe clients.
• Perform mainframe DB2 upgrades, administration and tuning.
• Coordinate with vendor personnel for timely DB2 solutions.
• Handle day-to-day database maintenance (backups, restores, monitoring).
• Monitor file extent growth and schedule reorganizations.
• Create and maintain DR procedures and 24x7x365 support.
• Optimize database configurations and perform performance reviews.
• Support customer migrations for DB2 and OEM software.
• Assist project managers during customer transitions.
• Support disaster recovery plans with DR services.
• Adhere to ITSM change control procedures.

Skills

DB2 admin

SMP/e

DB2 z/OS

On-call

SQL tuning

System programming

Education

Bachelor’s degree

Equivalent work experience

Tools

IDAA

CA tools

IBM DB2 tools

Job description

Ensono seeks a Mainframe Systems Programmer to provide premium DB2 sysprog support for our mainframe clients in the United States. The role covers DB2 upgrades, administration, tuning, DR procedures, and 24x7 support across time zones, with on-call responsibilities.

You will collaborate with vendor personnel, perform backups/restores, monitor and optimize DB2 environments, and participate in customer migrations and DR planning.