MySQL DB Developer

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

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.

You will be part of the Site Reliability Engineering Team. This role involves the design, scale, performance tuning, monitoring, and administration activities on the various databases (majority on MySQL).

Your day-to-day at Egnyte:

• 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

About you:

• 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

We are hiring candidates who are looking to work in a cloud environment and ready to learn and adapt to the evolving technologies.

Linux Administrator Roles &  Responsibilities:

• 5+ or more years of professional experience with strong working expertise in Agile environments
• Deep knowledge in managing Linux servers.
• Managing Windows servers(Not Mandatory).
• Manage Web servers (Apache, Nginx).
• Manage Application servers.
• Strong background & experience in any one scripting language (Bash, Python)
• Manage firewall rules.
• Perform root cause analysis for production errors.
• Basic administration of MySQL, MSSQL.
• Ready to learn and adapt to business requirements.
• Manage information security controls with best practises and processes.
• Support business requirements beyond working hours.
• Ensuring highest uptimes of the services.
• Monitoring resource usages.

Skills/Requirements

• Bachelor’s Degree or Diploma in Computer Science, Engineering, Software Engineering or a relevant field.
• Experience with Linux-based infrastructures, Linux/Unix administration.
• Knowledge in managing databases such as My SQL, MS SQL.
• Knowledge of scripting languages such as Python, Bash.
• Knowledge in open-source technologies and cloud services like AWS, Azure is a plus. Candidates willing to learn will be preferred.
• Experience in managing web applications.
• Problem-solving attitude.
• 5+ years experience in the IT industry.