Job Summary – Mainframe DB2 Database Administrator
Locations: Jersey City, NJ (Hybrid); Charlotte, NC (Hybrid); Plano, TX (Hybrid)
Summary:
- 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.
Key Responsibilities:
- 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.
Required Technical Skills:
- 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: 91173025
- Position Id: 740-46503-1793307760
- Posted 6 hours ago
