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