Senior MySQL Database Administrator

$135,200 - $156,000/Yr

OSI Engineering - Cary, NC

Full-time - Mid Level

Hybrid - Cary, NC

Administrative and Support Services

About the position

The Senior MySQL Database Administrator will be responsible for the installation, management, maintenance, and optimization of MySQL databases within a multi-site clustering environment. This role is crucial for ensuring high availability, performance, and security of database operations across distributed systems, specifically utilizing Percona XtraDB Clustering. The administrator will work closely with development and Quality Engineering teams to support critical database operations and ensure seamless data replication and disaster recovery.

Responsibilities

• Install, configure, and maintain MySQL databases and clustering solutions.
• Monitor database performance, identify bottlenecks, and optimize queries and indexes.
• Implement and manage database backup and recovery processes.
• Ensure high availability and disaster recovery solutions for Percona Server for MySQL databases using Percona XtraDB Clustering.
• Perform database upgrades, patches, and migrations.
• Collaborate closely with development and Quality Engineering teams to set up, test, and optimize MySQL databases in a distributed, Linux-based environment.
• Design and implement database schemas and queries, and perform application profiling for optimized DB tuning.
• Troubleshoot and resolve database-related issues and provide technical support.
• Implement and enforce database security policies and procedures.
• Manage database operations across various locations to ensure seamless, synchronized data flow between clusters.
• Create and maintain documentation related to database configurations, processes, and procedures.

Requirements

• Proven experience as a (Percona) MySQL Database Administrator with 5 years+ of experience in Multi-site Clustering.
• Strong knowledge of MySQL database architecture, replication, and clustering technologies.
• Experience with database performance tuning, query optimization, and indexing.
• Must have 3+ years of experience with Percona Server for MySQL and Percona XtraDB Cluster.
• Knowledge of scripting languages (e.g., Python, Bash) for automation.
• Experience with cloud-based database solutions (e.g., AWS RDS, Google Cloud SQL) and containerization technologies such as Docker and Kubernetes.
• Proficiency in backup and recovery processes and tools.
• Familiarity with database security best practices.
• Strong experience working in Linux environments for database management.
• Experience with high availability (HA) setups, disaster recovery (DR) strategies, and maintaining critical database infrastructure.

Nice-to-haves

• Relevant certifications in Percona and database administration are highly preferred.

Benefits

• Hourly rate of $65-75/hr. (DOE)
• Hybrid work model (3 days in office, 2 days remote)