Senior Cloud Database Engineer

Staff Cloud Database Engineer

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:

1. Be the DB expert to reach out regarding NoSQL DBs.
2. Stay up to date with the latest developments in the NoSQL space.
3. Develop and maintain working relationships with engineering leads across our distributed teams to collaborate on initiatives.
4. Review data models created by application teams.
5. Manage our Cassandra and Scylla clusters with a focus on capacity management, cost optimization, high availability and performance.
6. Work with large database clusters handling 1M+ IOPS in aggregate.
7. Create automations to reduce toil.
8. Create automations for monitoring and alerting.
9. Create runbooks for alert handling.
10. Setup backup and restore mechanisms.
11. Troubleshoot and resolve various issues with cluster related to nodes, table data, high load, connectivity issues from clients, etc.
12. 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