ARCIS e Services Pvt. Ltd.
Website:
arcisindia.com
Job details:
Mainframe DB2 z/OS System Programmer SME
Experience: 9+ Years
Location: Hyderabad / Chennai
Employment Type: Full-Time
Job Description:
We are hiring an experienced Mainframe DB2 z/OS System Programmer for a large enterprise environment supporting mission-critical systems.
This is strictly a DB2 z/OS System Programming role. We are not looking for DBAs, application support professionals, or developers.
Key Responsibilities:
• Installation, configuration, customization, and maintenance of DB2 for z/OS environments
• DB2 upgrades, migrations, and modernization initiatives (V11 → V12 → V13)
• DB2 subsystem architecture management including IRLM, DDF, EDM Pool, and Buffer Pools
• DB2 ZPARMs planning, implementation, and tuning
• Buffer Pool design and performance tuning
• Management of DB2 Logging, Active/Archive Logs, and BSDS
• Disaster Recovery (DR) and High Availability (HADR) planning and implementation
• Strong knowledge of DB2 Data Sharing concepts and Coupling Facility structures
• DB2 Security administration using RACF, AUTHIDs, Roles, and Privileges
• DB2 Utilities management including LOAD, UNLOAD, REORG, RUNSTATS, and COPY
• Hands-on experience with BMC tools such as AMI Ops, Catalog Manager, LOAD/UNLOAD, and REORG
• IBM Utilities vs Vendor Utilities analysis and optimization
• DB2 Catalog and Directory management
• DB2 Locking, Concurrency, and Deadlock analysis
• Performance Monitoring and Tuning
• Accounting & Statistics trace analysis
• Dynamic SQL / Static SQL analysis
• EXPLAIN, PLAN Stability, and Access Path Control
• DB2 Maintenance activities including PTFs, RSUs, SPRs, and HIPERs
• Automation and Scheduling integration with CA7 / TWS
• DB2 Backup, Recovery, and Clone strategies
• Utilities failure analysis and recovery
• Problem determination using DSN Dumps & Diagnostics
• Support for high-volume data loads and enterprise production environments
• Vendor coordination and IBM case management
• Compliance, audit, governance, and SLA adherence
• System ownership and architecture support
Mandatory Skills:
• DB2 for z/OS System Programming
• z/OS
• DB2 Installation & Migration
• DB2 Upgrades
• DB2 Subsystem Architecture
• RACF
• Sysplex / Data Sharing
• Buffer Pool Tuning
• DB2 Utilities
• BMC Utilities
• CA7 / TWS
• PowerExchange
• DB2 Diagnostics & Dumps
Click on Apply to know more.