TechClub Inc · 21 hours ago
DB2 DBA wiTh AS400
United States
Contract
Remote
Mid LevelTechClub Inc is seeking a skilled DB2 DBA with expertise in AS400. The role involves deep understanding of DB2 engine internals, performance diagnostics, and optimization, as well as configuring logging and monitoring for database systems.
AnalyticsArtificial Intelligence (AI)Cloud ComputingCyber SecurityInformation TechnologySoftware
Responsibilities
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 (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:
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 ongoing pairing
Comfortable performing performance baselining, capacity assessments, and recurring environment health reviews
Qualification
Required
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 (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: 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 ongoing pairing
Comfortable performing performance baselining, capacity assessments, and recurring environment health reviews
Company
TechClub Inc
TechClub renders avant-garde IT solutions to corporations.
Founded in 2014
201-500 employees
H1B Sponsorship
TechClub Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (25)
2024 (13)
2023 (18)
2022 (7)
2021 (4)
2020 (1)
Funding
Current Stage
Growth StageCompany data provided by crunchbase