Senior IBM Db2 Database Architect (Contract) - Location: Westminster, CO - Duration: 6 month contract (mid November 2026 through May 2027) - Schedule: 40 hours per week - Pay: $85/hr - $95/hr - Benefits: Our consultants are eligible to enroll in medical, dental and vision benefits. About the Opportunity Our client, a leading software company in the transportation and logistics space, is looking for a true IBM Db2 expert. The Db2 environment you’d work on supports a transportation management system that runs dispatch, billing, and settlement around the clock for some of the biggest carriers in the industry. This role has two big pieces. First, you’ll assess and tune the current Db2 environment to find and fix performance and reliability risks. Second, you’ll help move a large customer’s live production Db2 database from Windows to Linux. You’ll be the go-to expert, working with internal teams and directly with IBM to get it done right. What You’ll Do - Assess the current Db2 architecture, configuration, and security, and dig into SQL performance, execution plans, indexing, locking, buffer pools, and memory to find bottlenecks - Review customer custom SQL, understand the workflow behind it, and tune it, rewrite it, or recommend a better approach - Diagnose and resolve production issues, including performance slowdowns, failed jobs, storage constraints, and backup or recovery problems - Tune the Windows Server environment behind Db2 and build PowerShell automation for health checks and backup verification - Lead readiness planning for the Windows to Linux migration, including runbooks, cutover steps, rollback plans, and validation criteria - Configure and tune Linux for Db2, then benchmark performance before and after the move - Work hand in hand with IBM support and engineering to drive open cases to resolution - Share what you find through clear recommendations and knowledge transfer to internal teams What You Bring - Extensive hands on experience administering and tuning IBM Db2 LUW in large, transaction heavy production environments - Proven experience migrating an existing, live production Db2 database from Windows to Linux (with its data, custom SQL, and history, not a fresh install) - Deep Windows Server performance tuning experience and strong PowerShell skills - Strong Linux administration skills relevant to Db2 - Established IBM relationships or the credibility to escalate effectively with IBM support and engineering - Experience writing migration runbooks, cutover plans, and rollback plans - Strong troubleshooting skills in high availability, business critical environments - The ability to explain technical findings clearly to both technical and non technical audiences Nice to Have - Experience supporting a transportation management system or similar 24/7 operational platform - Db2 HADR, replication, clustering, or pureScale experience - Red Hat Enterprise Linux or SUSE Linux Enterprise Server experience - Experience with limited downtime cutovers - IBM Db2 or Linux certification #DICE LNTS