Enhancing Performance and Security with Strategic Database Migration

PMC’s DBA team seamlessly integrated into the business’s operations, augmenting their in-house capability and providing around-the-clock 24/7 support, including backup, recovery, and disaster scenario tests as part of their services.

PMC used differential database backup, initially taking a full database backup and then a final differential backup on the go-live date to reduce downtime and associated risks. Post-migration, PMC leveraged the Query Store feature to identify and resolve query regressions caused by Query Optimiser changes. This methodology, crucial for maintaining performance stability, was also applied during the application load-testing phase.

During the go-live migration, PMC’s support channels were available to address any post-implementation issues promptly, ensuring a smooth transition. Additionally, a comprehensive migration run book was created, detailing all steps and approaches taken, and shared with the company’s stakeholders for transparency and future reference.g critical initiatives such as implementing advanced search and merchandising tools across Signet’s websites in record time. This included enabling warranties to be seamlessly available online, a feature previously exclusive to physical stores. PMC also spearheaded the development and implementation of a Pick, Pack, and Dispatch (PPD) solution as part of Signet’s broader digital transformation efforts.