Staff Cloud Database Engineer
Hyderabad, Telangana, India
Fanatics
Fanatics.com is the ultimate sports apparel and Fan Gear Store, featuring football Jerseys, T-shirts, Hats, Collectibles and merchandise for fans of the NFL, MLB, NBA, NHL, Soccer, and College.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
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Architecture AWS Cassandra CockroachDB Engineering Grafana MySQL NoSQL OKR PostgreSQL Python SQL Terraform
Perks/benefits: Conferences Team events
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.