> Markdown version of [/jobs/ext/4020462-mainframe-db2-database-administrator-dba](https://www.wearedevelopers.com/jobs/ext/4020462-mainframe-db2-database-administrator-dba). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Mainframe DB2 Database Administrator (DBA)

- **Company:** Shree Narayani Networking Solutions Llc
- **Location:** Jersey City, NJ, United States
- **Contract:** Contract
- **Skills:** COBOL (Programming Language), Databases, IBM DB2, Database Security, Endevor, Job Control Language (JCL), Mainframes, Performance Tuning, Query Optimization, IBM Resource Access Control Facility, Software Engineering, SQL Databases, Backup and Restore, Z/OS, Database Optimization, Splunk, Sql Tuning
- **Published:** October 30, 2026
- **Apply:** https://www.dice.com/job-detail/c61267d7-f62e-48c2-8098-73ecaf838b03

## About the Role

Expert knowledge of DB2 on z/OS and mainframe database administration.

 - Advanced skills in DB2 performance tuning, SQL tuning, and query optimization.
 - Hands-on experience with IBM DB2 utilities and BMC utilities (e.g., Change Manager, Catalog Manager).
 - Solid understanding of DB2 backup/recovery strategies and log management.
 - Experience with database security using ACF2 and RACF.
 - Working knowledge of mainframe technologies (JCL, COBOL, SQL, DB2 utilities).
 - Experience with DB2 replication product upgrades and DBA remediation.
 - Proficiency in monitoring/reporting with SMF data and Splunk dashboards.
 - Familiarity with change and incident management tools (Endevor, BMC Remedy, ITSM processes).

Required Experience:

 - Strongly preferred: Experience at a large financial institution.
 - Demonstrated experience in DB2 performance tuning, production support, and operational stability.
 - Proven ability to collaborate with application development, infrastructure, and database teams.
 - History of job stability and consistent employment.

## Description

Serve as a Mainframe DB2 Database Administrator (DBA) with a focus on DB2 on z/OS.

 - Responsible for database performance tuning, backup, recovery, and production support.
 - Collaborate with multiple teams to ensure database stability, security, and recoverability., Develop log-scraping strategies to optimize resource usage (CPU, memory, staging-space).
 - Build and maintain Splunk dashboards for DB2 environment monitoring.
 - Establish and maintain log-retention policies for outage and recovery scenarios.
 - Translate business requirements into efficient physical database models.
 - Implement DB2 database access controls using ACF2 and RACF security.
 - Define and execute application-specific backup and recovery strategies.
 - Support DB2 replication upgrades and validate new features.
 - Provide DB2 performance-tuning recommendations and optimize SQL/database calls.
 - Monitor exception reports, investigate issues, and maintain production stability.
 - Participate in 24×7 on-call DBA rotation, including SEV1 testing and support.
 - Conduct knowledge-sharing sessions with application teams.
 - Support audits, control assessments, and SOX reviews to ensure compliance.