Case Study
Albemarle & Bond
A 200-store pawn broking and financial services organisation operating across multiple data centers with complex systems tracking money and gold from retail stores into central financial systems.
Their platform had no existing DBA support, suffered from performance issues, and relied on undocumented legacy systems critical to financial tracking and regulatory compliance.
Engagement Summary
The client engaged us to provide comprehensive database support, resolve performance issues, and document critical legacy systems across their entire estate. Over the course of the engagement, we eliminated performance bottlenecks, implemented monitoring across all three data centers, and reverse engineered undocumented systems essential to financial operations.
This case study highlights the core workstreams delivered:
- Enterprise Database Support & Performance Organisation
- Legacy System Documentation & Reverse Engineering
- Monitoring, Alerting & ETL Modernisation
Workstream 1: Enterprise Database Support & Performance Organisation
Challenge / Scope
The organisation had no existing DBA support for their 200-store operation spanning three data centers, resulting in multiple performance bottlenecks impacting store operations and financial processing.
With systems tracking money and gold movements, performance issues created operational delays and potential compliance risks.
What Was Delivered
- Comprehensive performance tuning across the entire estate
- VM and infrastructure organisation across three data centers
- I/O performance analysis and resolution
- Query organisation and index design
- SQL Server configuration tuning
- Ongoing database administration and support
The Outcome
- Identified and resolved multiple critical performance bottlenecks
- Dramatically improved system responsiveness across all stores
- Eliminated operational delays caused by database performance
- Faster financial processing and reporting
- Established reliable DBA support for ongoing operations
- Optimised infrastructure utilization across data centers
Workstream 2: Legacy System Documentation & Reverse Engineering
Challenge / Scope
Critical systems tracking money and gold from stores into financial systems had no documentation, creating significant operational and compliance risk.
Understanding these legacy systems was essential to maintain financial accuracy, regulatory compliance, and support ongoing operations.
What Was Delivered
- Reverse engineering of legacy systems with no documentation
- Complete environment documentation across three data centers
- Data flow mapping for money and gold tracking
- System architecture and dependency documentation
- Business logic analysis and documentation
- Knowledge transfer to internal teams
The Outcome
- Comprehensive documentation of previously undocumented critical systems
- Clear understanding of money and gold tracking processes
- Reduced operational risk through improved knowledge management
- Enabled future system maintenance and improvements
- Improved regulatory compliance through documented processes
- Established foundation for system modernisation
Workstream 3: Monitoring, Alerting & ETL Modernisation
Challenge / Scope
The organisation lacked monitoring and alerting across their three data centers, making it impossible to proactively identify and resolve issues. Legacy SSIS packages required organisation to support reliable financial data processing across 200 stores.
What Was Delivered
- Implemented monitoring and alerting across entire estate
- SSIS monitoring package implementation
- SSIS package redesign and organisation
- Proactive alerting for performance and availability issues
- ETL process improvements for financial data processing
- Standardised monitoring practices across all data centers
The Outcome
- Complete visibility of system health across all three data centers
- Proactive issue identification and resolution
- Improved reliability of financial data processing
- Optimised SSIS packages delivering faster, more reliable ETL
- Reduced downtime through early warning systems
- Established operational best practices for ongoing monitoring
Long-Term Impact
Across all workstreams, the organisation moved from an unsupported, undocumented, and poorly performing infrastructure to a well-documented, monitored, and optimised platform with reliable DBA support, enabling confident operations across 200 stores and three data centers.
Technologies & Skills Used
- SQL Server (administration, performance tuning, configuration)
- SSIS (package redesign, organisation, monitoring)
- Performance tuning (VM organisation, I/O analysis, query organisation)
- Index design and organisation
- Monitoring and alerting implementation
- Legacy system reverse engineering
- Environment documentation and architecture mapping
- Multi-data center infrastructure management
- Financial systems support and tracking
- Data flow analysis and organisation
Interested in discussing any points raised in this case study?
Contact us today and speak to one of our team who will be happy to assist you with your enquiry.
View All Case Studies
Make an Enquiry