Database Engineer (DB2)

Role : Database Engineer (DB2) Hire Type : Contract Location : USA, Remote Project duration : Long term Job Description:- 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 (Logic Monitor 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 code changes. 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