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 explicit diagnostics and evidence to application developers without requiring ongoing pairing.
Comfortable performing performance baselining, capacity assessments, and recurring setting 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 effi

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