MySQL DBA/ Architecture

Most roles at Convoso function as "hybrid" with some opportunities for travel to in-person business events and company meetings. For remote positions, Convoso's U.S. hiring is open to candidates who are residents of the following states: AL, AZ, CA, CO, CT, FL, GA, IL, IN, MA, MI, NC, NJ, NV, NY, OH, PA, SC, TX, UT.

The Job:

We are looking for a MySQL Database expert who will be responsible for assessing, designing, deploying, and maintaining complex databases as well as brainstorming possible improvements that can be made to a system in the future.

What You'll Be Doing:

• Maintain and support the current MYSQL/InnoDB & Redis /KeyDB database, including the creation of new DB's, migrations, backups, and replications.
• Design, plan and deploy database schemas.
• Review the existing databases and provide recommendations and drive the implementation to fine-tune and growth-proof the performance and scalability of our databases, including multi-sites replication.
• Ensure that data is properly backed up and consistent.
• Defines customers' needs and functionality in a service development cycle.
• Provide and communicate the best practices and specific detailed information for database management, including present and future capacity requirements.
• Provide documentation as required to ensure accurate and current information is available for each database schema, relationships, performance bottleneck, and data flows.
• Assists in the coordination of various teams testing and evaluating for the development of design and its implementation including database tools and software selection, including present and future capacity requirements.
• Ensures the highest level of database and systems availability, stability and scalability.
• Implements warranty and support activities.
• Plans and implements system automation as required for better efficiency.
• Oversees the development of customized software and hardware requirements.
• Willing to stay up-to-date with security best practices and drive implementation accordingly
• Collaborates with other professionals to ensure high-quality deliverables within organization guidelines, policies, and procedures.
• Run diagnostics to resolve customer-reported issues
• Deals with work process, optimization methods, and risk management tools in the given projects for successful accomplishments according to the requirements of the stakeholders.

Who You Are:

• Minimum 3 years experience configuring and supporting MySQL/MariaDB database management and data modeling. Databases running in Linux environments first, with strong domain knowledge.
• Solid database concepts and database design knowledge (ACID, abstraction levels, schemas and constraints, stored procedures, replication, etc.)
• Strong troubleshooting skill in database performance analysis and improvements.
• Good knowledge of storage, networking, and other systems directly impacting database performance.
• Solid experience in the administration and performance tuning of database-related tools and environments.
• Experience with monitoring systems like Grafana, Prometheus, Zabbix, etc.
• Experience with planning, executing, and managing large - scale system deployments, ensuring high availability and performance.
• Skilled in system scripting and automation to streamline deployment processes and operational tasks, utilizing tools such as Ansible, Chef, Terraform, etc.
• Solid scripting skills (e.g., Python, Ruby, Bash, Perl, etc)
• Proven working experience in configuring and troubleshooting UNIX/Linux-based environments.
• Strong work ethic and communication skills both spoken & written
• Flexibility to work a variety of shifts with availability to work overtime
• BS/MS degree in Computer Science, Engineering or a related subject.

Work Perks Worth The Hype:

• Competitive compensation package
• Stock options
• 100% covered premiums for employees; Medical, Dental, Basic life insurance, Long term disability
• Affordable Vision plan and optional FSA
• PTO, Paid Sick Time, Holidays, Bereavement time, Parental Leave
• Your birthday off
• 401k program with generous company match
• No cost Employee Assistance Program and Travel Assistance
• Monthly Gym membership reimbursement
• Monthly credits toward food & beverage
• Company Outings
• On and offsite team building events
• Paid training for departments
• Apple laptop (most roles)
• And a team of highly experienced and kind colleagues!

HQ Office:

• Casual office environment & dress
• Daily catered lunches
• Fully stocked kitchen (Dietary restriction-friendly)
• Happy Hours
• Monthly Massages
• On-site Car Wash
• Free Parking

Compensation:

The base salary range is: $120,000 - $140,000

The Base Pay Range for this position is based on the industry benchmark for position, function, level and the company's compensation strategies. However, final offers may vary from the amount listed based on geography, candidate experience and expertise, and other objective business. Convoso's compensation package also includes equity for all eligible U.S full time roles and exceptional benefits, including generous 401k match.

Your California Privacy Rights:

As a California resident who is an applicant to be an employee of Convoso, you have certain rights under California law with respect to information collected by Convoso in the course and scope of its evaluation of your application. The types of information Convoso collects and your rights with respect to that information are contained in Convoso's privacy policy, which you can review by going to https://www.convoso.com/privacy-policy/.