Enterprise SQL Support for Ecommerce

Case Study Topics:

Text Link

Overview

Challenge

The client needed a 24x7x365 solution to manage its extensive database environment.

Wimmer worked with the E-commerce client's team for installation, upgrade and maintenance of MS SQL Server to aid their e-commerce environment using business analysis skills, project management, and database architecture.

Wimmer Solutions’ team provided testing and implementation services for new releases of SQL-related software, documentation for users, and consistent cost-benefit analysis, which reduced overall cost of ownership, avoided compatibility issues in future upgrades, and end user support.

Download Case Study
Solution
Innovation

Challenge

The E-commerce company sought senior-level SQL Server Database Administration expertise and a solution to take on responsibility for the extensive database environment used to support its online store, as well as a suite of other sites comprising the organization’s overall corporate internet presence.

As part of a 24x7x365 on-call support rotation, our team was brought on to design, implement, and communicate innovative database solutions that added value to the client's website, and to design, create, and optimize the back-end structure underlying the client's corporate web sites. Wimmer Solutions also provided consultation and advice to application developers regarding the optimal use of SQL Server, code reviews, and performance tuning.

Solution

Wimmer supported the client's team across installation, upgrade and maintenance of MS SQL Server environments and applications in the internet e-commerce environment; designed physical data structures to support application requirements; and provided planning, recommendations, and implementation strategies related to capacity, growth and changes for SQL Server architecture. From a maintenance perspective, our team coordinated database server maintenance and patching, and implemented infrastructure changes.

In order to achieve the above deliverables on schedule with a focus on quality, the Wimmer Team utilized the following technical skills:

  • Business Analysis
  • Database Analysis
  • Project Management
  • Database Architecture

Wimmer’s robust network of senior-level database administration professionals and extensive experience in the space enabled us to bring the client and its application developers effective consultation and advice regarding the optimal use of SQL Server, code reviews, and performance tuning.

Innovation & Impact

While working to design and implement secure environments, and control and monitor user access and activity levels, the Wimmer team provided ongoing analysis and resolution for application issues affecting the database. Later in the project, resources offered the client the added value of testing and implementation services for new releases of SQL-related software; the associated cost-benefit analyses they performed allowed the client's site to reduce overall cost of ownership and avoid compatibility issues in subsequent software upgrades. By crafting manuals, project status reports and other documentation, our team facilitated the transition of the website ownership to the client at the end of the engagement. Throughout the project, end user support was provided at appropriate levels to ensure user productivity across the client's suite of online properties. The client’s internal staff was supplemented with high-level skill sets to accomplish critical operational tasks and projects without impacting their existing workload.