Database Administrator - MySQL - Remote
Description
EGNYTE YOUR CAREER. SPARK YOUR PASSION.
Egnyte is a place where we spark opportunities for amazing people. We believe that every role has meaning, and every Egnyter should be respected. With 22,000+ customers worldwide and growing, you can make an impact by protecting their valuable data. When joining Egnyte, you’re not just landing a new career, you become part of a team of Egnyters that are doers, thinkers, and collaborators who embrace and live by our values:
Invested Relationships Fiscal Prudence Candid Conversations ABOUT EGNYTE
Egnyte is the secure multi-cloud platform for content security and governance that enables organizations to better protect and collaborate on their most valuable content. Established in 2008, Egnyte has democratized cloud content security for more than 22,000 organizations, helping customers improve data security, maintain compliance, prevent and detect ransomware threats, and boost employee productivity on any app, any cloud, anywhere. For more information, visit www.egnyte.com.
Our Database Platform team enables Egnyte to provide customers with access to their data 24/7 by providing best in class infrastructure.
We are seeking talented engineers to join our team in Mumbai or to work remotely elsewhere in India. If you’d like to contribute your skills to the development of a global product with an impressive client base, please reach out!
WHAT YOU’LL DO:
- Build, scale, and administer a large fleet of database clusters (MySQL, Postgres, Vitess, CloudSQL, BigTable, MongoDB, to name a few) spread over multiple data centres with a focus on performance, scale, and high availability.
- Monitor and troubleshoot critical performance bottlenecks for databases before it causes downtime.
- Review and assess the impact of database schema design, topology changes prior to their implementation
- Ensure that databases are secured, maintained, backed up, and highly available.
- Review stress testing results and provide recommendations to development teams
- Automate anomaly detection to surface databases with failures, IOPS, deadlocks, and other failure reasons.
- Automate management tasks, streamline processes, and perform standard administrative functions with Python-based tooling.
- Build monitoring and observability systems with Prometheus, Grafana.
- Drive SLIs/SLOs/SLAs for database reliability and uptime.
- Implement Infrastructure-as-Code using Terraform, Ansible, Puppet, and Kubernetes.
- Develop CI/CD pipelines for schema and infrastructure automation with Jenkins and GitLab CI.
- Collaborate with DevOps, data engineering, and analytics teams to deliver resilient data solutions.
YOUR QUALIFICATIONS:
- 4+ Years of relevant industry work experience
- Understanding of MySQL’s (8.0+) underlying storage engines like InnoDB
- Knowledge of Performance and scalability issues with MySQL and how to overcome them with expertise in replication, indexing, and partitioning.
- Strong analytical, troubleshooting, and optimization skills.
- Strong experience with MySQL HA using Orchestrator/ProxySQL/Consul/Pacemaker
- Good understanding of monitoring requirements with deep knowledge of observability stacks like Prometheus and Grafana.
- Experience in administering Linux-based systems
- Experience with configuration management like Puppet/Ansible/Kubernetes.
- Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases
- Strong multi-cloud experience (GCP, Azure).
- Strong automation experience with at least 1 language, ‘Python/Ruby/Perl/Go’ and ‘SQL’ scripting
- Analytical skills necessary to perform troubleshooting of errors and performance issues on a large array of MySQL clusters spread over multiple data centres.
- Self-taught and enthused to grow your skill set with new technologies as the industry continues to evolve.
- Commitment to security, compliance, and operational excellence
GOOD TO HAVE:
- Experience in other distributed systems like Redis, Memcached, Postgres, MongoDB.
- Experience in managing a large fleet of database servers.
- Knowledge of HA and scalability issues with PostgreSQL
- Knowledge about cloud providers (Google Cloud and/or Azure)
BENEFITS:
- Competitive salaries
- Medical insurance and healthcare benefits for you and your family
- Fully paid premiums for life insurance
- Flexible hours and PTO
- Mental wellness platform subscription
- Gym reimbursement
- Childcare reimbursement
- Group term life insurance
COMMITMENT TO DIVERSITY, EQUITY, AND INCLUSION:
At Egnyte, we celebrate our unique differences and thrive on our diversity for our employees, our products, our customers, our investors, and our communities. Our global Egnyte Employee Communities (EECs) support representation and inclusion across our diverse workplace. Egnyters are encouraged to bring their whole selves to work and to appreciate the many differences that collectively make Egnyte a higher-performing company and a great place to be.
Any employees with questions or concerns about equal employment opportunities in the workplace are encouraged to bring these issues to the attention of [email protected]. Egnyte will not allow any form of retaliation against employees who raise issues of equal employment opportunity. If employees feel they have been subjected to any such retaliation, they should contact [email protected]. To ensure the workplace is free of artificial barriers, violation of this policy including any improper retaliatory conduct will lead to discipline, up to and including discharge. All employees must cooperate with all investigations conducted pursuant to this policy.