Client Snapshot
A large, North American engineering and construction organization operating at enterprise scale, supporting complex, mission-critical systems across multiple business units.
Engagement Overview
Keyhole Software partnered with this organization to support and modernize its cloud and data platforms across multiple concurrent engineering teams. A Principal Consultant worked alongside internal stakeholders to strengthen Azure architecture, improve data platform performance, and stabilize production systems supporting core business operations.
The engagement required senior-level architectural judgment, hands-on development, and the ability to operate effectively across parallel teams with differing priorities.
What We Did
Enterprise Azure Architecture & Platform Support
As part of the Cloud Platform team, the Keyhole consultant conducted architectural assessments, produced detailed design and landscape diagrams, and supported Azure resource provisioning and production issue resolution. This work helped establish clearer platform standards and reduced friction across teams consuming shared cloud infrastructure.
Cloud-Native Data & Application Services
Supporting the Power Engineering group, the consultant designed and implemented Azure-based solutions using Azure Data Factory, Cosmos DB, Azure Functions, and Azure Search. Custom services were developed in C# and Python, and the team introduced Azure DevOps CI/CD and source control practices to improve deployment reliability and development consistency.
Large-Scale Database Modernization & Performance Optimization
In parallel, a Keyhole consultant supported a major database modernization initiative, migrating a legacy SQL Server 2008 environment to SQL Server 2017. Beyond the migration itself, the engagement focused heavily on performance tuning—optimizing approximately 10,000 database objects (views and stored procedures). By applying advanced SQL techniques including CTEs, set-based operations, and DMVs, the team significantly improved query performance and application responsiveness.
Impact
- Strengthened Azure platform architecture supporting multiple enterprise teams
- Improved reliability and consistency of cloud-based data and application services
- Modernized legacy database infrastructure while materially improving performance at scale
- Enabled internal teams through clearer architecture, tooling, and delivery practices
