IBM Db2 Database and Platform Expert

RUSS HADICK & ASSOCIATES INC; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

RUSS HADICK & ASSOCIATES INC is seeking an experienced IBM Db2 Database and Platform Expert to assess, optimize, and evolve the Db2 implementation supporting TruckMate. The ideal candidate will identify performance and operational risks and implement improvements while ensuring business continuity during migration.

The role requires strong Windows and Linux DB2 administration, SQL performance tuning, and experience coordinating with IBM for issue resolution.

Qualifications

• Extensive hands-on Db2 LUW admin and tuning in production environments.
• Experience diagnosing CPU, memory, disk I/O, and network issues for DB workloads.
• Proven migration of live Db2 databases from Windows to Linux.
• Strong Linux administration skills for Db2 environments.
• Ability to create migration runbooks, cutover plans, rollback plans, and post-migration support.
• Excellent written and verbal communication for technical and non-technical stakeholders.

Responsibilities

• Assess Db2 architecture, workload, and configuration to identify bottlenecks.
• Tune SQL, indexes, and schema to improve performance for high-volume workloads.
• Review and optimize customer SQL and workflows.
• Lead or assist migration of Db2 databases from Windows to Linux with minimal downtime.
• Coordinate with IBM for issue resolution and leverage IBM support and engineering.

Skills

Db2 administration

SQL performance tuning

Windows server admin

Linux administration

Migration planning

Troubleshooting

Communication

Education

IBM Db2 certification

Linux certification

Tools

PowerShell

Job description

Our Client is seeking an experienced IBM Db2 Database and Platform Expert to assess, optimize, and help evolve the Db2 implementation supporting their TruckMate transportation management system. The ideal candidate will identify performance and operational risks and implement the improvements. They will also assist with the migration of a large customer's existing production Db2 database from Windows to Linux, while protecting application availability and business continuity and working directly with IBM to resolve issues.

Key Responsibilities

Assess the current Db2 architecture, configuration, security, and operational support model for TruckMate, and analyze database workload, SQL performance, execution plans, indexes, locking behavior, deadlocks, schema design, tablespaces, buffer pools, memory configuration, logging, and capacity to identify bottlenecks and improvement opportunities. Review the customer's custom SQL, understand the use case and workflow behind it, and tune or rewrite it, or recommend workflow or product changes where SQL is not the right fix. Tune Db2 for high-volume transactional workloads supporting

Required Qualifications

• Extensive hands-on experience administering and tuning IBM Db2 LUW in production enterprise environments, including configuration, buffer pools, tablespaces, memory management, logging, backup and recovery, indexing, statistics, and analyzing SQL execution plans to improve performance for large, transaction-heavy databases.
• Deep Windows Server administration and performance-tuning experience for database workloads, including diagnosing CPU, memory pressure, disk I/O, storage latency, paging, file system, and network issues, with PowerShell proficiency for automation and diagnostics.
• Proven experience migrating an existing, live production Db2 database from Windows to Linux. This is not a new customer going live on Linux. It is moving a current customer's existing database, with its data, custom SQL, and history, onto Linux.
• Strong Linux administration skills relevant to Db2, including storage and file systems, permissions, user and group management, resource limits, process management, networking, and service automation.
• Strong IBM relationships, or the standing to escalation effectively with IBM support and engineering.
• Experience creating migration runbooks, cutover plans, rollback plans, validation checklists, and post-migration support plans.
• Strong troubleshooting and root-cause analysis skills in high-availability, business-critical environments.
• Clear written and verbal communication skills, with the ability to translate technical findings into practical recommendations for both technical and non-technical stakeholders.

Preferred Qualifications

• Experience supporting TruckMate or another transportation management system with comparable operational workloads, including dispatch, order management, rating, settlement, billing, EDI, telematics, finance, and operational reporting.
• Experience with Db2 high-availability and disaster-recovery technologies, including HADR, replication, clustering, or pureScale.
• Experience with enterprise Linux distributions, preferably Red Hat Enterprise Linux or SUSE Linux Enterprise Server.
• Experience with 24/7 operational systems and planned maintenance or migration cutovers with limited downtime.
• IBM Db2 certification, Linux certification, or equivalent demonstrated enterprise production experience

This is a remote position.