Job Title :IBM DB2 Architect
Location: Open For 100% Remote (US Only)
Duration: 6 months to long term
W2 Only
$70-90 /hr on W2
Skills:
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.
Expected Deliverables
Current-state assessment of the TruckMate Db2 environment.
Prioritized list of performance, reliability, security, and operational risks.
Windows Server and Db2 tuning changes implemented, with supporting recommendations.
Target Linux platform design and Db2 configuration standards.
Contributions to the Windows-to-Linux migration strategy, cutover plan, rollback plan, and validation approach.
Support for the migration of the customer's production Db2 database to Linux, through cutover, validation, and post-migration stabilization.
Performance baseline and post-migration comparison report.
Monitoring, backup, recovery, and disaster-recovery recommendations.
Operational runbooks and knowledge-transfer materials for internal teams.
#LI-NS1
#INDPRO