Report this job

---

What is the problem? *

Incorrect company
Incorrect location
Job is expired
Job may be a scam
Other

Client: Lavu, Inc. Location: 100% Remote (ideally, San Fran because that is where the VP is, but knows the government is where we will find these people most likely) Position: Production DBA Duration: 6 Month Contract to Hire Citizenship: US Citizen and Green Card Only Job Description: This is back to being wide-open. They are looking for Production DBA's working in a product environment- SaaS or B2C (not from IT departments They need heavy MySQL, MariaDB, AWS Aurora, ECS and RDS experience. This person should also be coming from 15-20+ years of experience as well. Very senior, very capable of jumping in and helping out. This is an Aldrich Capital company that is having issues with their uptime. They are a very highly scaled restaurant software service. They were running the operation without a dba. They have been doubling their growth in the last 6 months. The database is at 7 terabytes. Notes: DBA MySQL Ideal: experienced person who is not afraid of databases. Be able to jump into it. No hand holding. Very old school database. Nothing magical about it, it has literally just been ignored and now they need it. Probably 20+ years of experience. Team: 40 people across the US and they are a mature team just lacking DBA. Good friendly team Top Skills: 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 application MariaDB is what they are running, but it is derived from MySQL PL/SQL An oracle background would also be ok here because the VP is from Oracle. 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