IBMI Series/AS400

IBMI Series/AS400

IBMI Series/AS400

Location: Delhi/Hyderabad/Bangalore

Experience: 10 years to 17 years

Must-Have:

Core Skills: Locking Analysis, Logging & Monitoring

• Deep understanding of DB2 engine internals, including locking, blocking, isolation levels, and transaction behavior.
• Ability to configure logging, auditing, and event tracing to capture:
• Lock owners (user/session IDs)
• Programs or jobs initiating locks
• SQL statements and transaction context
• Skilled in setting up monitoring for table locks and blocking chains, including proactive capture of diagnostic data.
• Experience with enterprise monitoring tools (LogicMonitor expertise is a plus).
• Ability to design custom logging, instrumentation, and automation to address recurring or high‑impact database issues.

Performance Diagnostics & Optimization (Without Query Rewrites)

• Proficient in running and interpreting:
• Performance traces
• Query execution plans
• Wait-time and resource-consumption statistics
• Query snapshots and top-N consumer analysis
• Ability to identify:
• Inefficient query patterns (diagnosis only)
• Index gaps, unused indexes, and suboptimal indexing strategies
• Configuration issues affecting CPU, memory, I/O, or bufferpool performance
• Capable of recommending:
• Indexing improvements
• Configuration and resource tuning
• Schema-level optimizations
• Strong collaborator during troubleshooting, providing clear diagnostics and evidence to application developers without requiring ongoing pairing.
• Comfortable performing performance baselining, capacity assessments, and recurring environment health reviews.

Monitoring, Alerting & Performance Regression Detection

• Ability to build and maintain performance baselines and track deviations over time.
• Experience implementing alerts for:
• Performance regressions
• Shifts in workload or access patterns
• Increasing lock contention or blocking
• Index health degradation
• Ability to automate trend analysis across:
• Resource utilization (CPU, memory, I/O)
• Query runtime metrics
• Index efficiency and fragmentation
• Storage and filesystem behaviors relevant to DB2

15 years of Continuous Education.