Our Company- Lavu, Inc
Lavu is at the forefront of transforming the way that restaurants are managed through its Point-of-Sale system, online ordering system, payment and API based integration with various delivery service providers using cloud and mobile tech stack.
The company is in growth mode and there has never been a more exciting time to join the team. Lavu R&D is one of the best and has offices in Florida, New Mexico, and India. The management team is a strong team with deep domain and technical experience. Visit us to know more about us at https://www.lavu.com/
Job Description
We offer unique engineering opportunities for smart, hands-on engineers to solve challenging problems in distributed systems, massive OLTP databases and modern cloud platforms. We are looking for a PRODUCTION DBA for MySQL clusters running in AWS environments for our SaaS products which have customers in 60+ countries and with BIG DATA.
This role owns critical system changes and projects which include MySQL database upgrades, migrations, major/minor patching, OS upgrades, backups, recovery, monitoring, and other DB related services. This person will be reporting to the DevOps Manager in the USA. This position is based in the US and it can be anywhere inside the country.
The ideal candidate is customer oriented, results driven, and passionate about delivering 24/7 service to our customers in 60 plus countries. To be successful, you will need to work well in a fast paced, startup environment.
Responsibilities:
- Installation, configuration, upgrades and maintenance of our production MySQL/MariaDB clusters in self-hosted EC2 and AWS Aurora environments
- Daily operational tasks which include troubleshooting and deployment tasks in both staging and production environments of our DB clusters
- Ensure database performance, availability and security of our DB clusters
- Work with development teams to design and implement database tables, SQL and to optimize database usage in applications
- Implement and regularly test backup & recovery plans to ensure data integrity
- Monitor and optimize database performance using tuning techniques
- Implement robust security frameworks to protect data against unauthorized access
- Diagnose and resolve database related issues in production, staging and development environments
- Forecast future database needs and plan for necessary hardware/software upgrades
- Maintain detailed documentation of database architectures, configurations and processes
- Ensure database processes and implementations comply with legal regulations and industry standards
- Execute customer success team requests and be on-call to cover 24x7 production support
- Collaborate and work with our team of DevOps engineers
- Manage projects and resources to ensure on-time delivery of milestones
Requirements:
- Minimum 3 years’ experience as production DBA for MySQL clusters for SaaS or B2C internet services with high scale and large data size
- 3+ years of experience in managing highly available internet applications
- Experience with data replication in a cluster environment
- Experience in monitoring for potential issues and proactively recommending solutions
- Experience in working closely with development teams
- Self-starter with a problem solver’s mentality
- Experience with DB production operations and troubleshooting issues when they arise in production
- Ability to work in a collaborative, cross-functional team environment
- Managing both self-hosted DB clusters in the EC2 environment in the Linux OS environment and in AWS Aurora
- Ability to communicate technical ideas verbally and in writing
- Understand the end to end configuration, technical dependencies and overall characteristics of production services
- Deep understanding in OS, data backup and recovery
- Experience in OLAP clusters such as AWS Redshift
- Strong SQL skills, and automation scripting capability in Terraform and Python
- In-depth knowledge in Linux systems for various applications and configurations, optimization towards high availability and effectiveness of services
- Experience implementing monitoring and alerts following practical monitoring frameworks
- B.S. Computer Science, or related fields