MySQL Database Administrator

London Computer Systems; Cincinnati (OH); Hybrid; USD 95,000 - 135,000; Full time

Benefits offered by this job

Health, dental, and vision insurance

401(k) with employer match

Profit sharing

Hybrid work schedule

Job summary

London Computer Systems, based in Cincinnati, Ohio, seeks a MySQL Database Administrator to develop, maintain, and optimize core databases supporting our software. You will design architecture, tune queries, secure data, and ensure high availability across large-scale systems.

The role emphasizes collaboration with technical teams, handling upgrades, and automating routine tasks using tools like Ansible and Python. A hybrid work model is available in the Cincinnati area.

Qualifications

• Strong MySQL database administration and management experience.
• Proficient Linux knowledge and administration.
• Experience monitoring, troubleshooting, and optimizing database performance.
• Proficient in writing and optimizing SQL statements.
• Understanding of database security, backup, recovery, and availability practices.
• Strong analytical, problem-solving, and organizational skills.
• Ability to work independently and in a team.

Responsibilities

• Design, implement, configure, and maintain MySQL databases.
• Install and optimize MySQL architecture and related systems.
• Monitor performance, security, integrity, and availability.
• Manage database access and privileges.
• Develop and maintain backup and recovery processes.
• Monitor resources and troubleshoot performance or capacity issues.
• Analyze and optimize queries, indexes, configurations, and processes.
• Plan upgrades and migrations for MySQL versions.
• Configure and maintain replication.

Skills

MySQL DBA

Linux

SQL tuning

Security/Backup/Recovery

Troubleshooting

Analytical thinking

Team collaboration

Education

Bachelor's degree in computer science / information technology or equivalent

Tools

Ansible

Python

Percona Toolkit

MySQL Replication

Job description

Are you an experienced MySQL professional who enjoys solving complex database challenges? Are you skilled at improving performance, protecting critical data, and keeping database environments running reliably?

LCS is seeking a MySQL Database Administrator to develop, maintain, and optimize the databases that support our business-critical software. In this role, you will manage database architecture, configure database hosts, maintain access privileges, tune queries, and help ensure the security, availability, and reliable operation of our database servers. This is an excellent opportunity to make a meaningful impact within a collaborative technology environment while working with large-scale systems and modern database tools.

What You’ll Do

• Perform day-to-day database administration, including designing, implementing, configuring, and maintaining MySQL databases.
• Install, maintain, and configure MySQL database architecture and related systems.
• Monitor database performance, security, integrity, and availability.
• Manage database access and privileges to help ensure company information is stored securely.
• Develop, implement, and maintain database backup and recovery processes.
• Monitor server resource usage and troubleshoot performance or capacity concerns.
• Analyze and optimize queries, indexes, configurations, and database processes.
• Test new versions and features of MySQL and plan and execute database upgrades and migrations.
• Configure and maintain database replication.
• Automate routine database administration and maintenance tasks.
• Identify current and future database resource and capacity requirements.
• Incorporate the long-term needs of database operations and administration into the organization’s overall systems planning.
• Collaborate with technical teams to troubleshoot database-related issues and support the reliable performance of LCS applications.

What We’re Looking For

• Strong proficiency in MySQL database administration and management.
• Strong Linux knowledge and experience.
• Experience monitoring, troubleshooting, and optimizing database performance.
• Proficiency in writing and optimizing SQL statements.
• Understanding of database security, backup, recovery, and availability practices.
• Strong analytical, problem-solving, and organizational skills.
• Ability to work both independently and collaboratively in a team environment.
• Bachelor’s degree in computer science, information technology, or a related field preferred; equivalent professional experience will also be considered.

Nice to Have

• Knowledge of MySQL features, architecture, and administration best practices.
• Experience configuring and maintaining MySQL replication.
• Experience using Percona products and tools.
• Experience planning database capacity and resource requirements based on high-level specifications.
• Experience with Ansible or other configuration-management tools.
• Experience scripting in Python.
• Experience automating routine database administration tasks.
• Experience planning and completing MySQL upgrades or migrations.

Benefits

• Health, dental, and vision insurance
• Wellness program with rewards for healthy activities
• 401(k) with employer match
• Profit sharing
• 10 paid company holidays
• Paid time off
• Life insurance
• Paid medical leave/disability insurance
• Contemporary office building
• Wooded campus with nature trail
• On-site fitness center
• LCS Work Perks program
• One of Cincinnati’s Top Workplaces
• Hybrid work schedule available

About LCS

London Computer Systems (LCS), based in Cincinnati, Ohio, provides businesses with critical software and technology solutions. Since 2012, LCS has been consistently recognized as a Top Workplace with a supportive culture that fosters collaboration and authenticity. We also love having fun—from on-site food trucks and game rooms to trivia and sports teams, there are plenty of ways we make the workday exciting. Our high-tech office is designed to support many working styles, with hybrid work schedule options available.

Candidates must live in the Greater Cincinnati area or be willing to relocate.

LCS is an Equal Opportunity Employer.

Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment visa at this time.