Posted 31 May, 2026
Database Administartion
ClifyX
India
Full Time
Reference: 365_594563_26-02762
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 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.
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 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.
