Staff Cloud Database Engineer

This role is part of the 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.
• 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 Mandatory

• Bachelors/Masters in Engineering from reputed institutions.
• Overall 10+ 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 installation, configuration, upgrades, OS patching, certificate management, scaling (out/in) for Cassandra and Scylla clusters.
• 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 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 with MySQL and/or Postgres on Linux is a plus.
• Experience working with AWS, with AWS certification preferred.
• Excellent communication skills.

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).