CV
Mainframe DB2 DBA
Compu-Vision Consulting Inc.
- Location not stated
- Hybrid
- Mid level
- 17 hours ago
- $60 – $65 / hour
- DB2
- z/OS
- SQL
- Disaster Recovery
- Change Management
17 hours ago
Duration:6-12 months contract-to-hire
Location: Chandler - AZ, Plano - TX, Charlotte- NC, Jersey City-NJ (3days onsite, 2days WFH)
Job Description:
We are seeking an experiencedMainframe Db2 Database Administrator (DBA) with strong hands-on expertise inIBM 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 supportIBM 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 asREORG, RUNSTATS, COPY, RECOVER, LOAD, UNLOAD, CHECK DATA, and REBUILD INDEX. IBM documents these utilities as core mechanisms for maintaining, reorganizing, loading, checking, copying, and recovering Db2 for z/OS data.
- PerformSQL and database performance analysis and tuning, including review of access paths and indexing strategies.
- Monitor database health, performance, capacity, and space utilization.
- Supportbackup, 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 maintainJCL required to execute Db2 utilities and database maintenance processes. IBM notes that Db2 online utilities can run as standard batch jobs, while stand-alone utilities run as batch jobs using JCL.
- Participate in production incident resolution, root cause analysis, and implementation of preventive actions.
- Maintain technical documentation, operational procedures, standards, and recovery procedures.
- Strong hands-on experience withIBM Db2 for z/OS
- Strong knowledge of:
- Db2 database administration
- Tablespaces, tables, indexes, partitions, views, and Db2 catalog
- SQL and SQL performance tuning
- Db2 utilities
- Backup and recovery
- Database reorganization and statistics
- Database performance monitoring and troubleshooting
- Db2 locking and concurrency concepts
- Db2 storage and space management
- Strong experience withJCL
- Good working knowledge ofz/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.
- IBM Db2 Administration Tool
- IBM OMEGAMON for Db2
- Db2 Query Monitor or equivalent performance monitoring tools
- IBM or third-party Db2 utility products
- REXX
- TSO/ISPF
- SDSF
- Db2 data sharing / Parallel Sysplex environments
Mainframe DB2 DBA · Compu-Vision Consulting Inc.