Project Efficiency

December 23, 2019

Project Efficiency

Implementation of HA enterprise level SQL Database server

Re architect and implementing a high availability SQL Database environment to host enterprise level application with high performance & security availability.

45 sql Servers with high availability using SQl clustering and mirroring techniques. Implement RBS in SQl server with zero production downtime.

 

Customer Highlights

Challenges
  • Complex environment for architecting the new solution.
  • No redundancy for databases.
  • Tight implementation timelines with zero.
  • Downtime expectation of live servers.
  • Outdated applications and poor security in place.
Solution
  • SQL Database environmentand implementiion 
  • Implemention of  RBS in SQl server with zero production downtime
Result
  • Successfully implemented the solutions with in 15 days with no downtime for 45 servers
  • Created Dashboards using SQL server SSRS for Sr management to view projects
  • Implemented data warehouse solution for high level reports
  • Project implemented before the stipulated timelines
  • Define processes to sustain the implementation for sustenance phase
  • Received appreciation from customer for overall project
Project Complexity
Project Complexity
March 25, 2020
Project Quality
Project Quality
March 25, 2020