Mainframe Systems Programmer - DB2 Physical

Role overview Own the systems programming and ongoing support of DB2 environments on z/OS for multiple customer organizations. The work combines database upgrades, administration, performance tuning, production troubleshooting, and disaster recovery support, with participation in round-the-clock coverage and customer transitions.

Responsibilities - Install and upgrade DB2 software, and handle routine maintenance such as backups, restores, extent monitoring, and reorganization planning. - Respond to DB2 service requests and production issues, including problems involving table spaces, security, and customer change requests. - Review database configuration and performance, tune buffer pools and SQL, and report findings and optimization opportunities. - Support customer migrations and coordinate with project teams to resolve technical issues and meet transition schedules. - Maintain and execute database disaster recovery procedures with recovery services teams. - Follow IT service management change controls and provide on-call support across time zones.

Requirements - Bachelor’s degree or equivalent work experience, with at least five years supporting DB2 administration and systems programming. - Experience with SMP/E and managing DB2 in a parallel sysplex environment. - Knowledge of software maintenance, documentation, database security, disaster recovery, and operational procedures. - Ability to assess DB2 version changes, evaluate change requests, and troubleshoot production database issues. - Experience reviewing security, reorganizing application data, and tuning buffer pools and SQL. - Strong written and verbal communication, teamwork, and ability to manage competing requests under pressure.

Nice to have - Systems programming experience with more than one database management system.

Benefits and work setup Remote work is generally supported when a customer site is not required; office work is also available. Listed benefits include flexible scheduling, paid leave, health coverage, retirement matching, family support, education assistance, and wellness programs.