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

- Solid collaborator during troubleshooting,



providing clear diagnostics and evidence to application developers without requiring ongoing pairing.
- 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:

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 runtime metrics o Index efficiency and fragmentation o Storage and filesystem behaviors relevant to DB2

________________________________________

Additional Valuable Skills

- Experience integrating monitoring and alerting with enterprise tooling such as LogicMonitor, Ignio, or ServiceNow.
- Knowledge of HA/DR architectures, including HADR, cluster manager integration, replication behaviors, and failover workflows.
- Familiarity with cloud database platforms (Azure SQL, PostgreSQL PaaS, MySQL PaaS) and hybrid environments.
- Solid understanding of application-to-database interaction patterns, including connection management, workload characteristics, and transaction design impacts.

📌 Database Administartion (India)
🏢 Clifyx
📍 India