Senior MySQL Database Administrator
Job Description:
We are seeking a Senior MySQL Database Administrator with demonstrated expertise in multi-site clustering to join our dynamic Global Support team. The ideal candidate will be responsible for installing, managing, maintaining, and optimizing our MySQL databases, ensuring high availability, performance, and security. This role requires a deep understanding of MySQL clustering, replication, backup, and recovery processes, specifically using Percona XtraDB Clustering across distributed systems. The database administrator will handle critical database operations spanning multiple locations, ensuring near real-time data replication and disaster recovery. This position reports to the VP of Global Support and IT.
Position 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.
- Close collaboration with development teams to design, implement database schemas and queries as well as application profiling for optimized DB tuning.
- Troubleshoot and resolve database-related issues and provide technical support.
- Implement and enforce database security policies and procedures.
- Work with on-site and remote teams, managing database operations across various locations to ensure seamless, synchronized data flow between clusters.
- Create and maintain documentation related to database configurations, processes, and procedures.
- Handle database distribution biased toward internal Development and QE teams, with some interaction with customers for support consultations and engagements.
Position Requirements:
- Proven experience as a (Percona) MySQL Database Administrator with 5 years+ of experience in Multi-site Clustering, specifically with distributed databases across multiple geographic locations.
- 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 to ensure minimal downtime in disaster scenarios.
Education/Certification:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Relevant certifications in Percona and database administration are highly preferred.
Location: Cary, NC (Hybrid – 3 days in office, 2 days remote)
Duration: 3 months (W2 contract)
Hourly Rate: $65-75/hr. (DOE)
Please Note: We are unable to work with C2C arrangements.