Cloud Database Administrator

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