Cloud Database Administrator at Fanatics

Hyderabad, Telangana, India -

Full Time

Start Date

Immediate

Expiry Date

07 May, 26

Salary

0.0

Posted On

06 Feb, 26

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Cassandra, Scylla, NoSQL, SQL, MySQL, Postgres, AWS, Terraform, Python, Bash, Grafana, Prometheus, New Relic, Datadog, Automation, Monitoring

Industry

Manufacturing

Description

We are looking for a passionate and accomplished individual to join our Database Performance and Operability team at Fanatics Commerce. As a Senior 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 8+ 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

Responsibilities

The Cloud Database Administrator will manage Cassandra and Scylla clusters, focusing on capacity management, cost optimization, high availability, and performance. They will also create automations for monitoring and alerting, troubleshoot cluster issues, and provide on-call support.