AWS Redshift Infrastructure Optimization for Luxury Department Store

Organization

Our client is a leading fashion retailer offering compelling clothing, shoes, and accessories for men, women, and kids. They operate around 350 stores in the US and Canada and serve customers online. Founded in 1901, they have been committed to providing customers with the best possible service and improving every day. For more than 100 years, they have worked to deliver the best possible shopping experience, helping their customers express their style, not just buy fashion. Our client is a Hall of Fame member of Fortune Magazine’s “100 Best Companies to Work For”. They have grown organically and through acquisitions.

Challenge

As part of the cloud strategy, our client migrated a significant workload from their existing Teradata data warehouse to AWS Redshift. However, the cost and performance advantage was not significant enough. Resource-intensive analytical queries’ performance was poor. Database users were created in Redshift having the users maintain separate credentials for AWS and Redshift.

Technical Solution

• Architected AWS VPC environment for Data & Services account
• Architected Redshift clusters based on the need for dense computing vs. dense storage
• Designed Data & Services account to make them scalable, highly available, and resilient
• Migrated Redshift clusters (16 different systems) to a new architecture
• Implemented Federated Authentication on Redshift clusters
• Implemented in-transit and at-test data encryption for Redshift and S3
• Optimized taxonomy with S3’s performance
• Defined and optimized lifecycle policy for object-based storage
• Redesigned overall storage policy with best and most suitable options from EBS, EFS,
• S3 (Standards, IAS, RRS), and Glacier to reduce the cost
• Optimized and simplified IAM policies for access management
• VPCs management and peering between 20+ different AWS accounts
• Made the overall migration activity seamless with the least impact on current customers/users/processes

BUSINESS RESULT

• Seamless authentication to Redshift using IAM and Federated Authentication
• Improved Redshift infrastructure performance and resiliency
• Balanced infrastructure configuration between compute and storage needs
• Reduced infrastructure cost
• Improved security and availability

XTIVIA needs the contact information you provide to us to contact you about our products and services. You may unsubscribe from these communications at anytime, read our Privacy Policy here.