Job Description
We are looking for a passionate and accomplished individual to join our Database Performance and Operability team at Fanatics Commerce.
As a Staff Cloud Database Engineer, you will be performing the database related activities including:
- Be the DB expert to reach out regarding NoSQL DBs.
- Stay up to date with the latest developments in the NoSQL space.
- Develop and maintain working relationships with engineering leads across our distributed teams to collaborate on initiatives.
- Review data models created by application teams.
- Manage our Cassandra and Scylla clusters with a focus on capacity management, cost optimization, high availability and performance.
- Work with large database clusters handling 1M+ IOPS in aggregate.
- Create automations to reduce toil.
- Create automations for monitoring and alerting.
- Create runbooks for alert handling.
- Setup backup and restore mechanisms.
- Troubleshoot and resolve various issues with cluster related to nodes, table data, high load, connectivity issues from clients, etc.
- Be the on-call support engineer on a rotational basis.
Qualifications
- Overall 12+ years of experience in SQL and NoSQL databases.
- Experience managing large-scale Cassandra and Scylla clusters with in depth understanding of architecture, storage, replication, schema design, system tables, logs, DB processes, tools and CQL.
- Experience with MySQL and/or Postgres databases.
- Experience with installation, configuration, upgrades, OS patching, certificate management and scaling (out/in).
- Experience in setting up backup and restore mechanisms with short RTO and RPO objectives.
- Experience with infrastructure automation and scripting using Terraform, Python or Bash.
- Experience working with AWS, with AWS certification preferred.
- Experience with monitoring tools like Grafana, Prometheus, New Relic, Datadog, etc
- Experience with managed Cassandra solutions (InstaClustr, Datastax Astra) is a plus
- Experience with Cloud native distributed databases (eg: TiDB, CockroachDB) is a plus.
- Experience in planning, scheduling and resourcing to deliver for OKRs and Keeping The Lights On (KTLO) deliverables.
- Ability to mentor, develop talent and drive technical excellence.
- Excellent communication skills
About Us
Fanatics is building a leading global digital sports platform. We ignite the passions of global sports fans and maximize the presence and reach for our hundreds of sports partners globally by offering products and services across Fanatics Commerce, Fanatics Collectibles, and Fanatics Betting & Gaming, allowing sports fans to Buy, Collect, and Bet. Through the Fanatics platform, sports fans can buy licensed fan gear, jerseys, lifestyle and streetwear products, headwear, and hardgoods; collect physical and digital trading cards, sports memorabilia, and other digital assets; and bet as the company builds its Sportsbook and iGaming platform. Fanatics has an established database of over 100 million global sports fans; a global partner network with approximately 900 sports properties, including major national and international professional sports leagues, players associations, teams, colleges, college conferences and retail partners, 2,500 athletes and celebrities, and 200 exclusive athletes; and over 2,000 retail locations, including its Lids retail stores. Our more than 22,000 employees are committed to relentlessly enhancing the fan experience and delighting sports fans globally.
About The Team
Fanatics Commerce is a leading designer, manufacturer, and seller of licensed fan gear, jerseys, lifestyle and streetwear products, headwear, and hardgoods. It operates a vertically-integrated platform of digital and physical capabilities for leading sports leagues, teams, colleges, and associations globally – as well as its flagship site, www.fanatics.com.
Fanatics Commerce has a broad range of online, sports venue, and vertical apparel partnerships worldwide, including comprehensive partnerships with leading leagues, teams, colleges, and sports organizations across the world—including the NFL, NBA, MLB, NHL, MLS, Formula 1, and Australian Football League (AFL); the Dallas Cowboys, Golden State Warriors, Paris Saint-Germain, Manchester United, Chelsea FC, and Tokyo Giants; the University of Notre Dame, University of Alabama, and University of Texas; the International Olympic Committee (IOC), England Rugby, and the Union of European Football Associations (UEFA).
At Fanatics Commerce, we infuse our BOLD Leadership Principles in everything we do:
- Build Championship Teams
- Obsessed with Fans
- Limitless Entrepreneurial Spirit
- Determined and Relentless Mindset