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 workplace 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.

📌 IBMI Series/ (Delhi)
🏢 Tata Consultancy Services
📍 Delhi