Job Title: DB2 Database Administrator Location: New York, NY (HYB) Experience with DB2 v10+, IBM z/OS, IMS V12, COBOL, CICS, REXX, AIX, and legacy payroll systems required Job Overview: Our client is seeking an experienced DB2 Database Administrator (DBA) to support mission-critical legacy applications for the City's payroll and pension systems (PMS and PPMS). This role involves working with DB2 on IBM z/OS platforms and will play a key role in performance tuning, system upgrades, data migrations, and supporting modernization initiatives. Key Responsibilities:
- Perform installation, configuration, tuning, and support for DB2 databases (v10 or higher) on IBM z/OS.
- Collaborate with development teams to manage release installations and data fixes.
- Design and execute database recovery plans.
- Author, validate, and maintain documentation for database operations.
- Implement standard DB2 tuning procedures such as runstats and reorgs.
- Troubleshoot and resolve issues within DB2 and its integrations with COBOL and assembler programs.
- Support legacy applications (PMS, PPMS) and participate in disaster recovery drills.
- Provide detailed instructions for migrations and production deployments.
- Assist in tool upgrades and monitoring solutions.
- Build and maintain data propagation solutions using IBM InfoSphere Replication Server.
- Support integration with other platforms including AIX and Oracle via Transparent Gateway.
Required Skills:
- 8+ years of hands-on experience with DB2 v10+ on IBM z/OS.
- Proficient in performing DBA tasks including backup/recovery, reorgs, and troubleshooting.
- Experience with IBM IMS V12 or higher.
- Experience with CICS transaction server and COBOL-based applications.
- Strong scripting skills using REXX.
- Experience troubleshooting assembler code.
- Experience with Oracle Transparent Gateway integration.
- Familiarity with BMC BPPM monitoring tools.
- Experience installing and managing IBM Tivoli LDAP server on AIX.
- Ability to manage DB2 installations on AIX.
- Strong background in supporting enterprise-scale financial and payroll systems.
Preferred Skills:
- Experience with IBM InfoSphere Replication Server.
- Background in large-scale legacy modernization efforts.
Education:
- Bachelor's or Master's Degree in Computer Science or a related technical/business discipline.