Description
We are looking for an experienced Software Architect to provide deep technical leadership for a Db2 environment that supports a transportation management platform in Burlingame, California. This Long-term Contract position focuses on evaluating the current database and infrastructure landscape, strengthening performance and reliability, and recommending practical improvements that support critical business operations. The role also partners with technical stakeholders to solve complex platform issues, document findings, and guide modernization efforts while maintaining application stability.
Responsibilities:
Evaluate the existing Db2 platform, operating model, and supporting architecture to uncover performance gaps, capacity concerns, security risks, and reliability issues.
Analyze workload behavior across transactional processes and reporting activity, using execution plans, indexing strategy, locking patterns, memory settings, logging, and storage usage to recommend measurable improvements.
Review custom SQL and related application workflows, then refine inefficient queries or propose alternative functional approaches when database changes alone are not the best solution.
Resolve production-facing database and platform problems, including slowdowns, failed scheduled processing, storage limitations, replication concerns, backup or recovery issues, and interruptions to availability.
Improve the Windows-based environment currently supporting Db2 by assessing server configuration, memory utilization, disk and file system performance, network settings, service permissions, and security controls.
Build and enhance automation for recurring operational checks, configuration validation, backup confirmation, and ongoing monitoring using PowerShell or similar scripting tools.
Support the migration of a large production Db2 database from Windows to Linux by defining readiness criteria, dependency reviews, data movement strategy, testing plans, cutover activities, rollback steps, and post-go-live stabilization.
Configure and tune Linux infrastructure for Db2, including storage mounts, permissions, resource thresholds, networking, service management, and monitoring integration.
Work closely with vendor support and engineering teams to investigate open cases, accelerate issue resolution, and validate platform changes through benchmarking and documented runbooks.
Requirements
Strong hands-on experience architecting, administering, and optimizing IBM Db2 environments that support high-volume business applications.
Proven ability to diagnose database performance issues using SQL analysis, execution plans, indexing methods, locking behavior, and resource utilization metrics.
Experience supporting production platforms across Windows and Linux server environments, including storage, networking, security, and system configuration.
Demonstrated background in planning and executing database migration initiatives with attention to testing, rollback preparation, continuity, and post-migration validation.
Proficiency in scripting or automation tools such as PowerShell to streamline health checks, validation routines, and operational support tasks.
Working knowledge of backup, recovery, monitoring, high availability, and disaster recovery practices for enterprise database systems.
Ability to produce clear technical documentation, risk assessments, and procedural guidance for infrastructure, database, and support teams.
Strong communication skills with the ability to collaborate effectively with stakeholders, engineering teams, and external support partners.
Technology Doesn't Change the World, People Do.
Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.
2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use and Privacy Notice.
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: rhalfint
- Position Id: 04860-0013534610
- Posted 2 hours ago
