Database Administrator - Mainframes DB2 (Z / OS)

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. .