Enterprise SQL Strategy & Support

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

• Strategic Guidance: Provided senior-level SQL Server Database Administration expertise, ensuring optimal use and performance tuning for the client’s extensive database environment.
• Cost Efficiency: Implemented cost-benefit analyses for new SQL-related software releases, reducing overall cost of ownership and avoiding compatibility issues.
• Operational Support: Supplemented the client’s internal staff with high-level skills, allowing them to focus on critical tasks without impacting their workload.
• Seamless Transition: Facilitated the transition of website ownership to the client through comprehensive documentation and project status reports.