Mainframe Systems Programmer
Role details
Job location
Tech stack
Job description
We are seeking an experienced Mainframe Systems Programmer (DB2) to support a New York City agency located in Manhattan, NY. The ideal candidate is a hands-on professional with extensive expertise in IBM DB2 and z/OS environments, capable of maintaining high levels of system performance, reliability, and availability. In this role, you will be responsible for managing and optimizing the DB2 subsystem, providing advanced technical support for installation, upgrades, and performance tuning, and ensuring seamless operation across critical mainframe systems. The successful candidate will bring deep technical knowledge, strong problem-solving skills, and a proactive approach to system administration and optimization., * Support and maintain DB2 subsystems within a z/OS mainframe environment.
- Perform DB2 software installations, upgrades, and maintenance using SMP/E.
- Diagnose, troubleshoot, and resolve complex DB2 and related product issues.
- Tune DB2 for optimal system performance and resource utilization.
- Provide technical leadership and documentation for DB2 best practices.
- Administer mainframe components, including JES2, SMP/E, TSO, and Unix System Services.
- Conduct maintenance on z/OS operating systems, storage systems, and system software products (DB2, CICS, IMS, security management, scheduling tools, etc.).
- Collaborate with cross-functional technical teams to support production stability and system enhancements.
- Provide off-hours production support and participate in scheduled weekend implementations.
Requirements
Must: A minimum of 10 years of experience working with z/OS, * Bachelor's degree in Computer Science, Information Systems, or a related field (or equivalent experience).
- Minimum 10 years of experience working in z/OS mainframe environments as a Systems Programmer.
- Strong expertise in IBM DB2 installation, upgrade, tuning, and maintenance.
- Proficiency with SMP/E, VTAM, TCP/IP, IOCP/HCD, IDCAMS, IEFBR14, and other IBM utilities.
- Experience supporting enterprise-wide, large-scale mainframe implementations.
- Excellent communication, documentation, and interpersonal skills.
- Ability to work independently and provide high-quality deliverables under tight deadlines., * Experience with DB2 database system recovery and performance optimization.
- Knowledge of CICS, IMS, and AFP printing.
- Familiarity with OMEGAMON or similar mainframe monitoring tools.
- Experience with IBM virtual tape systems.
- Prior involvement in mainframe CPU installations as a systems programmer consultant.
