DB2 DBA with AS400

Introduction:

We are looking for a skilled DB2 DBA with AS400 experience to join our team. The ideal candidate will have a deep understanding of DB2 engine internals, locking analysis, logging, and monitoring. They will be responsible for configuring logging, auditing, monitoring, and performance optimization to ensure the efficient operation of our database systems.

Responsibilities:

• Deep understanding of DB2 engine internals, including locking, blocking, isolation levels, and transaction behavior.
• Configure logging, auditing, and event tracing to capture lock owners, programs or jobs initiating locks, SQL statements, and transaction context.
• Set up monitoring for table locks and blocking chains, including proactive capture of diagnostic data.
• Design custom logging, instrumentation, and automation to address recurring or high-impact database issues.
• Run and interpret performance traces, query execution plans, wait-time and resource-consumption statistics, query snapshots, and top-N consumer analysis.
• Identify inefficient query patterns, index gaps, unused indexes, suboptimal indexing strategies, and configuration issues affecting performance.
• Recommend indexing improvements, configuration and resource tuning, and schema-level optimizations.
• Collaborate during troubleshooting, providing clear diagnostics and evidence to application developers.
• Perform performance baselining, capacity assessments, and recurring environment health reviews.

Requirements:

Required Skills:

• IBM DB2
• IBM iSeries
• Database Administration
• AS400

Preferred Skills:

• Experience with enterprise monitoring tools (LogicMonitor expertise is a plus)