SQL Database Administrator
We are looking for an experienced DB2 Database Administrator with strong hands-on experience in IBM DB2 for z/OS to support enterprise mainframe database environments.
Key Responsibilities:
Administer and monitor DB2 z/OS database environments.
Perform SQL performance tuning, query optimization, and index optimization.
Monitor DB2 subsystem performance, including CPU, I/O, buffer pools, and locking.
Troubleshoot performance issues using Omegamon, EXPLAIN, RMF, and SMF.Manage DB2 utilities, maintenance, PTFs, and version upgrades.
Support critical production systems and ensure high availability and reliability.
Collaborate with application teams on database enhancements and performance improvements.
Required Skills:
5–10 years of hands-on DB2 for z/OS DBA experience.
Strong SQL performance tuning and execution plan analysis.
Experience with DB2 architecture, utilities, logging, and recovery.
Knowledge of Mainframe, z/OS, JCL, datasets, and batch processing.
Experience with Omegamon, RMF, and SMF.Production support experience in large enterprise environments.
Knowledge of SOX compliance and database security.
Important:
Hands-on DB2 for z/OS DBA experience is required. General SQL Server, Oracle, or DB2 LUW experience alone will not be a fit. Interested candidates can share their updated resumes via DM or email