MYSQL - Database Administrator [India]

Engineering - India Mumbai, India or Remote, India


Description

Job Description

At Egnyte we build and maintain our flagship software: a secure content platform used by companies like IKEA, Red Bull, Nasdaq & Yamaha.

This role involves the design, scale, performance tuning, monitoring, and administration activities on the various databases (majority on MySQL).

We store, analyze, organize, and secure billions of files and petabytes of data with millions of users. We observe more than 1M API requests per minute on average. To make that possible and to provide the best possible experience, we rely on great engineers. For us, people who own their work from start to finish are integral. Our Engineers are part of the process from design to code, to test, to deployment, and back again for further iterations.  

We have 300+ engineers spread across the US, Poland, and India.

What You’ll Do will include (But not limited to):

  • Build, scale, and administer a large fleet of MySQL servers spread over multiple data centers with a focus on performance, scale, and high availability.
  • Monitor and troubleshoot critical performance bottlenecks for MySQL 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

Your Qualifications:

  • 2 - 5 Years of relevant industry work experience
  • Understanding of MySQL’s (5.7+) underlying storage engines
  • Knowledge of Performance and scalability issues with MySQL
  • Strong experience with MySQL HA using Orchestrator/ProxySQL/Consul/Pacemaker
  • Experience with configuration management like Puppet/Ansible
  • Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases
  • Automation experience with ‘Python/Ruby/Perl’ and ‘SQL’ scripting
  • Analytical skills necessary to perform troubleshooting of errors and performance issues on a large array of MySQL cluster spread over multiple data centers.

Due to the nature of the role, it would be nice if you have also:

  • Experience in other distributed systems like Redis, Elasticsearch, Memcached.
  • Experience in managing a large fleet of database servers.
  • Knowledge of HA and scalability issues with PostgreSQL

About Egnyte

In a content critical age, Egnyte fuels business growth by enabling content-rich business processes, while also providing organizations with visibility and control over their content assets. Egnyte’s cloud-native content services platform leverages the industry’s leading content intelligence engine to deliver a simple, secure, and vendor-neutral foundation for managing enterprise content across business applications and storage repositories. More than 16,000 customers trust Egnyte to enhance employee productivity, automate data management, and reduce file-sharing cost and complexity. Investors include Google Ventures, Kleiner Perkins, Caufield & Byers, and Goldman Sachs. For more information, visit www.egnyte.com

#LI-Remote