Recently postedOther

IBM Db2 Database and Platform Expert

Russ Hadick & Associates, Inc.United States🇺🇸United States

Quick overview

SeniorityMid Senior

Work modeHybrid

LocationUnited States

SQLPowerShellTelematicsLinuxWindows Server

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 ResponsibilitiesAssess 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 escalate 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