DB2 DBA (IBM Db2 for z/OS)

Work Mode: Remote Notice Period. : 15 to 20 days C2H Position

Key Responsibilities

• Administer, maintain, and optimize IBM Db2 for z/OS databases.
• Perform performance tuning using EXPLAIN, SQL analysis, catalog reviews, MainView, and Query Monitor.
• Manage backup, recovery, disaster recovery, and high-availability solutions.
• Troubleshoot database, SQL, locking, catalog, and performance issues.
• Implement database security, access controls, authentication, and auditing.
• Design schemas, indexing strategies, normalization, and capacity planning.
• Support production, test, and development environments.
• Collaborate with application teams and provide technical guidance.

Required Skills

• Strong hands-on experience with IBM Db2 for z/OS administration.
• Expertise in performance tuning, backup/recovery, and troubleshooting.
• Knowledge of RACF, ACF2, Top Secret, database security, and auditing.
• Experience with EXPLAIN plans, catalog analysis, MainView, and Query Monitor.
• Strong database design, modeling, and capacity planning skills.
• Experience supporting high-volume, highly available transactional systems.
• Strong communication and problem-solving abilities.

Preferred Skills

• Very Large Tables (VLTs) management.
• IBM Q Replication (Db2z ↔ Db2z).
• Db2 Data Sharing and Sysplex environments.
• Db2 Connect and distributed access.
• BMC tools (Catalog Manager, Utilities, MainView).
• Payments/FinTech domain experience.

Location: Bangalore / Hyderabad

Work Mode: Remote Notice Period. : 15 to 20 days