Senior Remote DB2 Mainframe Systems Programmer

Ensono; Olympia (WA); Hybrid; USD 65,000 - 123,000; Full time

Benefits offered by this job

Unlimited Paid Days Off

401k with company match

Dental, vision, disability, life andAD

Job summary

Ensono seeks a Mainframe Systems Programmer – DB2 for premium support on DB2 for z/OS environments. The role focuses on administration, upgrades, tuning, backups, restores, and DR procedures to ensure high availability for customer DB2 systems.

You will work 24x7 across time zones, participate in on-call rotations, and collaborate with vendor personnel to resolve complex database issues, while aligning with ITSM change control processes in a fast-paced managed service context.

Qualifications

• Bachelor's degree or equivalent work experience.
• 5+ years of professional experience in DB2 for administration and systems programming support.
• Knowledgeable in best practices of software management, maintenance and documentation
• SMP/e experience
• Experience with configuring and managing DB2 in a parallel sysplex environment
• Ability to develop innovation, strategies, processes and best practices in software management
• Experience with establishing policies and procedures pertaining to database management, DR, security, maintenance, and utilization
• Experience with reviewing new versions of DB2 for functionality, advising how they benefit the client
• Ability to evaluate change requests and determine impact to assigned clients and troubleshooting and solving production database issues.
• Experience with supporting DB2 security requests
• Ability to review DB2 security to find potential risks
• Experience with reorganization of application data
• Experience with reviewing, tuning of internal DB2 buffer pools and SQL code
• Demonstrated ability to respond quickly and effectively to support requests from multiple clients
• Supporting multiple customer for after hours on-call

Responsibilities

• Provide premium DB2 sysprog support and services to Ensono mainframe clients as they relate to Mainframe DB2 systems.
• Perform mainframe database software upgrades coupled with administration and tuning to support our customers’ DB2 environments.
• Work with vendor personnel to achieve timely solutions of database problems.
• Responsible for day-to-day database maintenance such as backups, restores, monitor file extent growth, scheduling reorganizations, and DR procedures.
• Support of customer needs and requests and database performance reviews.
• Perform database optimizations including reporting and analysis of DB2 configuration efficiency.

Skills

DB2 administration

System programming

On-call experience

DB2 security expertise

DB2 performance tuning

Multi-client support

Education

Bachelor's degree or equivalent

Tools

IDAA

CA tools

IBM tools for DB2

Job description

Ensono seeks a Mainframe Systems Programmer – DB2 for premium support on DB2 for z/OS environments. The role focuses on administration, upgrades, tuning, backups, restores, and DR procedures to ensure high availability for customer DB2 systems.

You will work 24x7 across time zones, participate in on-call rotations, and collaborate with vendor personnel to resolve complex database issues, while aligning with ITSM change control processes in a fast-paced managed service context.