Russ Hadick & Associates, Inc.
Russ Hadick & Associates, Inc.

IBM Db2 Database and Platform Expert

Remote • Posted 10 hours ago • Updated 10 hours ago
Contract W2
6 Months
No Travel Required
Remote
$80 - $95/hr
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Windows PowerShell
  • Linux Administration
  • Microsoft Windows Server Administration
  • SQL
  • Performance Tuning
  • IBM DB2
  • Linux
  • IBM

Summary

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
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: RUSSHD
  • Position Id: 9130483
  • Posted 10 hours ago
Contact the job poster
BH

Bob Hadick

Recruiter @ Russ Hadick & Associates, Inc.

View Profile
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.
Remote jobs at Russ Hadick & Associates, Inc.