Mainframe DB2 DBA

Mainframe Db2 DBAWe are seeking an experienced Mainframe Db2 Database Administrator (DBA) with strong hands-on expertise in IBM Db2 for z/OS to support large-scale, business-critical mainframe environments. The successful candidate will be responsible for the administration, performance, availability, integrity, maintenance, and recovery of Db2 databases. The role requires close collaboration with application development, systems programming, operations, security, and infrastructure teams.Responsibilities:Administer and support IBM Db2 for z/OS databases across development, test, and production environments.Create, maintain, and manage Db2 objects including databases, tablespaces, tables, indexes, views, and storage-related definitions.Perform database maintenance using Db2 utilities such as REORG, RUNSTATS, COPY, RECOVER, LOAD, UNLOAD, CHECK DATA, and REBUILD INDEX.Perform SQL and database performance analysis and tuning, including review of access paths and indexing strategies.Monitor database health, performance, capacity, and space utilization.Support backup, recovery, and disaster recovery activities for Db2 databases.Troubleshoot Db2 database problems, SQL issues, performance degradation, locking/contention, failed utilities, and production incidents.Support database schema changes and application implementations through controlled development, testing, and production deployment processes.Analyze and optimize Db2 objects to maintain database performance and availability.Work with application developers to review SQL and recommend improvements to SQL statements, indexes, and database design.Support Db2 version upgrades, maintenance, migrations, and modernization initiatives as required.Develop and maintain JCL required to execute Db2 utilities and database maintenance processes.Participate in production incident resolution, root cause analysis, and implementation of preventive actions.Maintain technical documentation, operational procedures, standards, and recovery procedures.Required Qualifications:Strong hands-on experience with IBM Db2 for z/OSStrong knowledge of:Db2 database administrationTablespaces, tables, indexes, partitions, views, and Db2 catalogSQL and SQL performance tuningDb2 utilitiesBackup and recoveryDatabase reorganization and statisticsDatabase performance monitoring and troubleshootingDb2 locking and concurrency conceptsDb2 storage and space managementStrong experience with JCLGood working knowledge of z/OSExperience supporting large, highly available production mainframe environments.Experience with production incident and problem management.Understanding of change management and controlled production implementation processes.Preferred Experience:IBM Db2 Administration ToolIBM OMEGAMON for Db2Db2 Query Monitor or equivalent performance monitoring toolsIBM or third-party Db2 utility productsREXXTSO/ISPFSDSFDb2 data sharing / Parallel Sysplex environments Compu-Vision Consulting