Job Summary:
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 role is responsible for database administration, performance optimization, availability, integrity, maintenance, and recovery of Db2 databases across development, test, and production environments. The successful candidate will collaborate closely with application development, systems programming, operations, security, and infrastructure teams to ensure reliable database operations and high availability.
Key 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 access path reviews and indexing strategy optimization.
• Monitor database health, performance, capacity, and space utilization.
• Support backup, recovery, and disaster recovery activities for Db2 databases.
• Troubleshoot Db2 database issues, SQL problems, performance degradation, locking and 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.
• Collaborate 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/OS.
• Strong knowledge of Db2 database administration.
• Experience managing tablespaces, tables, indexes, partitions, views, and the Db2 catalog.
• Strong SQL knowledge and SQL performance tuning experience.
• Hands-on experience with Db2 utilities.
• Knowledge of backup and recovery processes.
• Experience with database reorganization and statistics management.
• Experience in database performance monitoring and troubleshooting.
• Understanding of Db2 locking and concurrency concepts.
• Knowledge of Db2 storage and space management.
• Strong experience with JCL.
• Good working knowledge of z/OS.
• Experience supporting large, highly available production mainframe environments.
• Experience with production incident and problem management.
• Understanding of change management and controlled production implementation processes.
Preferred Qualifications:
• Experience with IBM Db2 Administration Tool.
• Experience with IBM OMEGAMON for Db2.
• Experience with Db2 Query Monitor or equivalent performance monitoring tools.
• Experience with IBM or third-party Db2 utility products.
• Knowledge of REXX.
• Familiarity with TSO/ISPF and SDSF.
• Experience with Db2 data sharing and Parallel Sysplex environments.
