Mainframe DB2 Database Administrator (DBA)

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.