SQL Server Administrative Solution for Global Transportation Company
For 30+ years, the Client has set out to solve complex transportation and logistics challenges with personalized solutions to deliver confidence to their customers. The company has grown from a small team of shipping pros to an expansive network of 2,000+ transportation experts with access to 50,000+ carriers, 250,000 intermodal containers and trailers, 2,000,000 pieces of equipment, and a network of global transportation partners.
Initially, the Client needed to extend its in-house capabilities around its Microsoft SQL Server technology stack. The Client needed additional expertise and bandwidth to support their on-premise SQL Server environments and assist in moving some systems from on-prem to the cloud leveraging Azure SQL Database.
Their transactional systems and data warehouse — including Microsoft SSIS ETL packages — required additional support. There was a tremendous amount of technical debt around the processes and packages within the ETL code that required detailed analysis and remediation.
XTIVIA provided on-going SQL Server management services via on-demand administration services, including monitoring and supporting their production environment both on-prem and in the cloud. This service includes strategy, health checks, SSIS development, performance tuning, internal assessments, and diagnosing system health to prioritize recommendations and best practices.
Today, the Client has end-to-end assistance with one point of contact with XTIVIA. Their systems have better notifications and processes as a whole, and when an error occurs within a package, error handling is addressed and added. Work is done using a testing protocol vs. a production environment; there is a Quality Assurance process before going to production. Getting the data warehouse running is now a priority. Their SQL server has a new development, along with troubleshooting, monitoring, and reporting.
A significant result of this work is that the Client now has deep expertise from a dedicated advisor who understands their system, is on-call, and can handle anything from a query that’s not performing to new process implementation and vendor communication around new technology. XTIVIA delivers advice on best practices and helps our Client reach their business targets effectively.