DB2 Database Administrator
3B Staffing LLC, New York, NY, United States
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.
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.