Mainframe DB2 Database Administrator (DBA)

Shree Narayani Networking Solutions•Jersey City, NJ

1d•Hybrid

About The Position

The Mainframe DB2 Database Administrator (DBA) focuses on DB2 on z/OS and is responsible for database performance tuning, backup and recovery, and production support. The role collaborates with multiple teams to maintain database stability, security, and recoverability. Locations are Jersey City, New Jersey; Charlotte, North Carolina; and Plano, Texas, all listed as hybrid.

Requirements

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, such as Change Manager and Catalog Manager.
Solid understanding of DB2 backup and recovery strategies and log management.
Experience with database security using ACF2 and RACF.
Working knowledge of mainframe technologies, including JCL, COBOL, SQL, and DB2 utilities.
Experience with DB2 replication product upgrades and DBA remediation.
Proficiency in monitoring and reporting with SMF data and Splunk dashboards.
Familiarity with change and incident management tools and processes, including Endevor, BMC Remedy, and ITSM processes.
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.

Nice To Haves

Experience at a large financial institution is strongly preferred.

Responsibilities

Develop log-scraping strategies to optimize CPU, memory, and staging-space usage.
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.
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 and database calls.
Monitor exception reports, investigate issues, and maintain production stability.
Participate in a 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.