Database Administrator - Mainframes DB2 (Z / OS)

We are seeking a skilled Mainframe DB2 DBA (z/OS) with 3+ years of experience in managing and supporting DB2 databases on IBM z/OS environments. The ideal candidate should have strong expertise in DB2 database administration, performance tuning, backup and recovery, database object management, capacity planning, and production support. The role requires hands-on experience in maintaining high availability, ensuring database security, troubleshooting performance issues, and supporting mission-critical mainframe applications in a 24x7 enterprise environment.

The core responsibilities for the job include the following:

DB2 Database Administration:

• Administer and maintain DB2 databases on IBM z/OS platforms.
• Create and manage database objects, including tablespaces, databases, tables, indexes, views, and aliases.
• Perform database installations, upgrades, migrations, and maintenance activities.
• Support application development teams with database design and implementation.

Performance Monitoring and Tuning:

• Monitor database performance and system utilization.
• Analyze and optimize SQL queries and access paths.
• Identify performance bottlenecks and implement tuning recommendations.
• Utilize DB2 performance monitoring tools to ensure optimal system performance.

Backup, Recovery, and Disaster Recovery:

• Perform backup, recovery, and restoration activities.
• Implement and maintain DB2 recovery strategies.
• Support disaster recovery (DR) testing and execution.
• Ensure database availability and business continuity requirements are met.

Database Maintenance:

• Execute REORG, RUNSTATS, COPY, LOAD, UNLOAD, and related DB2 utilities.
• Manage database growth, storage allocation, and capacity planning.
• Implement database maintenance schedules and housekeeping activities.
• Monitor database health and proactively resolve issues.

Security and Compliance:

• Manage DB2 security and user access controls.
• Implement database auditing and compliance policies.
• Ensure adherence to organizational security standards and regulatory requirements.

Production Support:

• Provide L2/L3 support for production database incidents.
• Perform root cause analysis and issue resolution.
• Coordinate with application, infrastructure, and mainframe teams.
• Support change management, release activities, and deployments.