Skill Required: Database Administration (DBMS)
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:
o Lock owners (user/session IDs)
o Programs or jobs initiating locks
o 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:
o Performance traces
o Query execution plans
o Wait-time and resource-consumption statistics
o Query snapshots and top-N consumer analysis
• Ability to identify:
o Inefficient query patterns (diagnosis only)
o Index gaps, unused indexes,
and suboptimal indexing strategies
o Configuration issues affecting CPU, memory, I/O, or bufferpool performance
• Capable of recommending:
o Indexing improvements
o Configuration and resource tuning
o 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:
o Performance regressions
o Shifts in workload or access patterns
o Increasing lock contention or blocking
o Index health degradation
• Ability to automate trend analysis across:
o Resource utilization (CPU, memory, I/O)
o Query
📌 Database Administartion (India)
🏢 Clifyx
📍 India