IT Infrastructure Engineer DB2 Database Administrator IBM zOS

Stratford Solutions Inc.

New York (NY)

On-site

USD 75,000 - 160,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Stratford Solutions Inc. in New York, NY seeks an experienced IBM DB2 Database Administrator (DBA) for an IBM z/OS mainframe environment. You will manage DB2 v12+ databases, support payroll and financial systems, and drive performance, backups, and migrations.

The role requires strong DB2 expertise, production support experience, and collaboration with development and operations teams to ensure high availability and data integrity.

Qualifications

Bachelor's degree with 4+ years in DB2 admin, data center, cloud, or complex IT infra.
OR 8+ years of IT infra or database admin experience with relevant skills.
Equivalent combinations of education and experience accepted.

Responsibilities

Install, configure, administer, and maintain DB2 v12 on z/OS.
Tune performance using RUNSTATS, REORG, COPY, RECOVER, and related tools.
Design and validate backup/recovery strategies.
Monitor health, availability, logging, and performance.
Support development teams with installations, migrations, and deployments.
Open/track IBM support tickets through resolution.
Participate in disaster recovery planning and testing.
Collaborate across teams to ensure reliability and performance.

Skills

DB2 v12 on z/OS

DBA experience

Production support

Performance tuning

Disaster recovery

Data replication

Release management

Troubleshooting

Education

Bachelor's degree in CS/IT/Engineering

4+ years relevant DB2/infrastructure experience

Tools

RUNSTATS

REORG

COPY

RECOVER

LOAD

UNLOAD

IBM InfoSphere Data Replication

DB2 Utilities

Job description

Job Title: IT Infrastructure Engineer (DB2 Database Administrator – IBM z/OS)

Labor Category: Database Administrator (DB2)
Location: New York, NY
Job Type: Full-Time
Salary: $75K - $160K (Depending on the experience)

Position Overview

We are seeking an experienced DB2 Database Administrator (DBA) with strong expertise supporting IBM DB2 Version 12 (or higher) in an IBM z/OS mainframe environment. The selected candidate will be responsible for the administration, maintenance, performance tuning, recovery, and migration of mission-critical databases supporting the City's Payroll Management System (PMS), Pension Payroll Management System (PPMS), and Financial Management System (FMS).

The ideal candidate will have extensive experience in DB2 database administration, production support, disaster recovery, performance optimization, software migrations, and IBM InfoSphere Data Replication.

Key Responsibilities

Install, configure, administer, and maintain IBM DB2 v12 (or higher) databases on IBM z/OS.
Perform database performance tuning using standard DB2 utilities, including:
- RUNSTATS
- REORG
- REBUILD
- COPY
- RECOVER
Design, execute, and validate database backup and recovery strategies.
Monitor database health, availability, logging, backup/recovery processes, and system performance.
Support application development teams with:
- Software installations
- Release migrations
- Data fixes
- Production deployments
Prepare migration packages and provide detailed implementation instructions to Technical Support teams.
Troubleshoot DB2-related issues across Development, Testing, UAT, Performance Testing, and Production environments.
Perform database recovery activities during planned and unplanned outages.
Develop, document, and maintain database administration procedures and standards.
Open, track, and manage IBM support tickets through resolution.
Participate in Disaster Recovery (DR) planning, testing, and execution.
Support IBM InfoSphere Data Replication administration and ensure high availability of replication services.
Collaborate with infrastructure, development, and application support teams to ensure database reliability and performance.
Validate vendor software releases and conduct technical testing to ensure compliance with FISA quality standards.
Assist with DB2 tools installation, upgrades, patching, and maintenance.

Required Qualifications

Candidates must meet one of the following:

Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field and at least 4 years of relevant experience in database administration, data center engineering, cloud engineering, or complex IT infrastructure.

Bachelor's degree in any discipline and at least 8 years of relevant IT infrastructure or database administration experience.

An equivalent combination of education and professional experience.

Mandatory Skills & Experience

Extensive hands-on experience administering IBM DB2 Version 12 (or higher) on IBM z/OS.
Strong experience with:
- DB2 installation and configuration
- Database migration
- Performance tuning
- Backup and recovery
- Database monitoring
Experience executing DB2 utilities including:
- RUNSTATS
- REORG
- COPY
- RECOVER
- LOAD
- UNLOAD
Experience supporting mission-critical production environments.
Experience with software release management and production migrations.
Strong troubleshooting skills for DB2 online and batch processing issues.
Experience working with application development teams during SDLC.
Experience administering IBM InfoSphere Data Replication.
Experience participating in Disaster Recovery planning and execution.
Ability to monitor database health and proactively resolve performance issues.
Experience managing IBM support cases through resolution.
Excellent analytical, documentation, communication, and problem-solving skills.

Preferred Qualifications

Experience supporting large government or public-sector enterprise applications.
Experience supporting Financial Management, Payroll, or Pension systems.
Knowledge of IBM z/OS architecture and mainframe environments.
Experience with enterprise monitoring and database automation tools.
Familiarity with change management and ITIL processes.

Technical Environment