Cloud Database Administrator at Fanatics Retail Group Fulfillment, LLC
Fanatics Retail Group Fulfillment, LLC · Hyderabad, India · Onsite
- Senior
- Office in Hyderabad
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
