Database Engineer (DB2)

PineQ Lab Technology is seeking a Database Engineer (DB2) for a long-term contract role. The position requires deep expertise in DB2 internals and involves configuring logging, monitoring, and performance optimization to enhance database efficiency.

Responsibilities:

• 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
• 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
• 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

Requirements:

• 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