About Pmc

PMC combines consulting with expert software engineering capability and 24x7x365 managed services, to provide high quality technology services and solutions to retail, D2C and commerce. 

From supporting end-of-life legacy systems through to providing the latest digital retail solutions, we help retailers take control of their IT to deliver better retail experiences. 

Past projects and programmes we have delivered include: 

> Strategy roadmap development 
> Digital Transformation programmes 
> Acceleration of existing programmes of work 
> System upgrades and integrations 
> Web development and testing 
> App development 
> Payment system integration 
> Trading platform development 
> Managed Services 
> Database management 

For more information on our services please contact enquiries@pmcretail.com or +44 (0)1235 521900

Locations

Explore PMC office locations and service areas.

Headquarter

Certificate

iso-27001.jpg

Focus Area

Browse, Compare, Shortlist, and Hire your ideal business partner with ease.

Pmc's Technical Expertise

Java 25%
PHP 25%
Javascript 25%
AngularJS 25%

Focus Client

  • Medium Business ($100001 - $500000) 47%
  • Large Business (>$500000) 53%

Pmc's Industry Expertise

  • Retail 69%
  • Business Services 22%
  • Other Industries 9%

Portfolio

Explore PMC's portfolio and selected projects.

Strategic Database Migration

Enhancing Performance and Security through Strategic Database Migration Challenge In 2020, a prominent player in the customer-facing services industry tasked PMC with upgrading their legacy applications and database servers to modern systems, focusing on performance improvement and security enhancement, all while minimising downtime. Key challenges included: Upgrade Path: The legacy database was crucial to key business functions and required a two-step upgrade due to its outdated state. The system had no direct upgrade path to the latest version, demanding careful planning to avoid disruption. Database Size: The large database required a strategy to minimise downtime during migration. Approach PMC implemented a five-phase roadmap to ensure a smooth upgrade: discovery, design, build, migration, and optimisation. The approach focused on: Replication and Compatibility: Ensuring stable database replication and backward compatibility during the upgrade. Security Enhancements: Implementing security measures such as Windows Integrated Authentication using Kerberos. Performance Monitoring: Establishing performance baselines and using Query Store to maintain stability. Code Upgrades: Updating SQL code to address deprecated syntax incompatible with the new database version. Minimising Application Changes: Reducing application code changes with client aliases. PMC provided 24/7 support throughout the process, ensuring the legacy system remained operational while the upgrade took place. This approach also included backup, recovery, and disaster recovery testing to reduce risks. Solution PMC executed the migration using differential backups to minimise downtime. The first step involved a full backup, followed by a final differential backup on the go-live date. After the migration, Query Store was used to detect and address query performance issues caused by optimiser changes. A detailed migration runbook was created and shared with stakeholders to ensure transparency. Outcome The migration was successfully completed with outstanding results: Minimal Downtime: The migration was executed with minimal disruption to operations. Improved System Resilience: Post-migration, there were no further performance-related tickets, demonstrating improved system reliability. Commitment to Excellence: Over the last four years, PMC has maintained a 99.9% SLA for this client, showcasing the consistency and quality of service delivery. Read More

industry image

Industry

Retail

budget image

Budget

Not Disclosed

timeline image

Timeline

Weeks

Strategic Database Migration

Reviews

Read PMC reviews, client feedback, ratings, and experiences to learn more about the company's services and performance.

No reviews submitted yet...

This profile is not claimed

Do you own or represent this business? Enter your business email to claim your TopITFirms profile.

Similar Companies
PMC

Ask About PMC

Usually replies instantly