IBM Db2 Architect : 26-03295

Akraya Inc.; Westminster (CO); Remote; USD 117,000 - 124,000; Full time

Job summary

Akraya in Westminster, CO is seeking a Db2 LUW Database Administrator for a 6-month W2 contract. The role focuses on optimizing an IBM Db2 database supporting a critical transportation management system, with a migration from Windows to Linux and performance tuning.

You will collaborate with IBM support, resolve production incidents, tune SQL, and ensure business continuity during the migration, leveraging Windows and Linux administration expertise.

Qualifications

• Proven experience migrating live production Db2 databases from Windows to Linux.
• Deep expertise in Db2 LUW administration, tuning, and performance analysis.
• Strong Windows Server and Linux administration skills for database workloads.

Responsibilities

• Analyze Db2 architecture and performance to identify and resolve issues.
• Tune and optimize SQL queries for high-volume transactional workloads.
• Troubleshoot and resolve critical production database incidents.
• Enhance the Windows Server environment for optimal Db2 performance.
• Plan and execute a live Db2 database migration from Windows to Linux.

Skills

Db2 LUW administration

Windows Server tuning

Linux administration

PowerShell

SQL tuning

Job description

Job Details

• Primary Skills: Db2 LUW administration (advanced), Windows Server performance tuning (advanced), Linux administration (advanced), PowerShell scripting (intermediate), SQL performance tuning (advanced)
• Contract Type: W2
• Duration: 6 Months
• Location: Westminster, CO - 80021 (#LI - Remote)
• Pay Range: $85/hr - $90/hr

Job Summary: This role involves deep assessment and optimization of an existing IBM Db2 database supporting a critical transportation management system. You will be responsible for identifying and resolving performance bottlenecks, mitigating operational risks, and leading a complex migration from Windows to Linux. This position requires close collaboration with IBM support to ensure seamless transitions and continued business continuity.

Key Responsibilities

• Analyze Db2 architecture and performance to identify and resolve issues.
• Tune and optimize SQL queries for high-volume transactional workloads.
• Troubleshoot and resolve critical production database incidents.
• Enhance the Windows Server environment for optimal Db2 performance.
• Plan and execute a live Db2 database migration from Windows to Linux.

Must-Have Skills

• Proven experience migrating live production Db2 databases from Windows to Linux.
• Deep expertise in Db2 LUW administration, tuning, and performance analysis.
• Strong Windows Server and Linux administration skills for database workloads.

Domain / Industry Experience

• Experience supporting transportation management systems or similar enterprise-level operational workloads is preferred.