With DBAs scarce, SaaS firm outsources Snowflake administration to pros at Pythian

1 min read
Apr 8, 2022

Overview

SaaS Firm

Industries

Real Estate

Locations:

HQ in Boston, Massachusetts. Clients in the U.S., Canada, United Kingdom and Europe

An international SaaS company serving commercial real estate and property management needed dedicated resources to optimize their Snowflake-powered solution. Instead of hiring a full-time database administrator, they opted to outsource to Pythian. This approach keeps their internal developers focused on product enhancements, while simultaneously ensuring their proprietary platform operates at peak performance.

What we did

The tech company first tried to hire a full-time database administrator, but struggled to find top talent in a competitive job market. Instead, they outsourced to a team of highly specialized resources at Pythian.

Pythian’s work included:

  • Analyzing current database and virtual warehouse configurations
  • Deploying appropriate database monitoring and alerts to support company SLAs
  • Collaborating with the internal development team to support a multi-region infrastructure, including GDPR compliance
  • Providing a complete security assessment of users, privileges and roles
  • Creating actionable recommendations for improvement
 
 

Technologies used

 
  • Snowflake data warehouse
  • MySQL database
  • Looker for reports and analytics
  • Amazon Web Services cloud hosting

Key Outcomes

In just a few weeks, Pythian identified and implemented a number of improvements to streamline Snowflake database operations, enhance security and compliance, and increase performance. At every stage, Pythian subject matter experts worked closely with the internal team to educate and transfer knowledge. The company gained more confidence in their platform and better positioned its solution for future growth.

Explore our Snowflake Professional Services

No matter your business, no matter the challenge: Pythian’s solutions drive results.