IBM Db2 Database Administrator

TEKsystems•Broomfield, CO

6d•$70 - $95•Hybrid

About The Position

TEKsystems is seeking an experienced IBM Db2 Database and Platform Expert to assess, optimize, and evolve the IBM Db2 implementation supporting a TruckMate transportation management system. The consultant will identify and remediate performance, operational, and infrastructure risks while supporting migration of a large customer's live production Db2 database from Windows to Linux. The role works with internal teams and IBM support organizations to improve performance, operational stability, and best practices for business-critical systems throughout the migration lifecycle. The position includes assessing Db2 architecture, configuration, security, performance, and operational processes; tuning high-volume transactional workloads; diagnosing production and infrastructure issues; and optimizing both Windows Server and Linux environments. The consultant will lead migration readiness assessments and contribute to planning, testing, cutover, rollback, validation, and stabilization. Deliverables include performance benchmarks, assessments, migration runbooks, risk analyses, operational documentation, automation and monitoring standards, and knowledge-transfer materials.

Requirements

Deep expertise in IBM Db2 LUW.
Expertise in Windows Server administration and Linux administration.
Expertise in SQL tuning and enterprise-scale database migrations.
Experience with enterprise database troubleshooting.
Experience assessing, optimizing, and supporting Db2 databases and platforms.

Nice To Haves

IBM mainframe experience.
TruckMate or transportation management system experience.
Transportation logistics industry experience.
Experience with Db2 HADR, Db2 Replication, or Db2 pureScale.
Clustering technologies experience.
Red Hat Enterprise Linux experience.
Linux certification.
Telematics platform experience.

Responsibilities

Assess current-state Db2 architecture, configuration, security, performance, and operational processes.
Analyze workloads, SQL execution plans, indexing strategies, schema design, locking behavior, deadlocks, tablespaces, buffer pools, memory settings, capacity, and logging configurations.
Review customer-developed SQL and optimize or redesign database interactions where appropriate.
Tune Db2 for high-volume transactional workloads supporting dispatch, order management, rating, billing, settlements, operational reporting, and system integrations.
Diagnose performance degradation, storage constraints, backup failures, replication issues, and production outages.
Optimize Windows Server infrastructure, including CPU, memory, storage, paging, security settings, antivirus exclusions, and networking.
Develop health-check automation, configuration validation, backup verification, and monitoring standards using PowerShell or comparable tools.
Lead readiness assessments for Windows-to-Linux migration efforts and contribute to migration planning, testing, cutover, rollback, validation, and stabilization.
Work directly with IBM support and engineering teams to resolve complex production issues.
Design and tune Linux environments supporting Db2 workloads.
Establish performance benchmarks and validate system performance before and after migration.
Produce assessments, migration runbooks, risk analyses, operational documentation, and knowledge-transfer materials.

Benefits

Medical insurance, if eligible.
Dental insurance, if eligible.
Vision insurance, if eligible.
Critical illness, accident, and hospital coverage, if eligible.
401(k) retirement plan, with pre-tax and Roth post-tax contributions available, if eligible.
Voluntary life and AD&D insurance for employees and dependents, if eligible.
Short- and long-term disability coverage, if eligible.
Health Spending Account (HSA), if eligible.
Transportation benefits, if eligible.
Employee Assistance Program, if eligible.
Time off or leave, which may include PTO, vacation, or sick leave, if eligible.