MySQL/MariaDB Database Administrator

Summary

Join Sync's team as a Senior MySQL Database Administrator and contribute to a safe and collaborative cloud environment. This remote role involves designing, implementing, and maintaining a high-performance MySQL database infrastructure. You will be responsible for query optimization, ensuring high availability and reliability, managing data pipelines, and maintaining database security. The ideal candidate possesses extensive experience in MySQL/MariaDB administration, including expertise in architecture, optimization, replication, and security. Sync offers a competitive compensation package and benefits, along with professional growth opportunities.

Requirements

• 8+ years of experience in MySQL/MariaDB database administration
• Expert-level knowledge of MySQL/MariaDB architecture, indexing, storage engines (e.g., InnoDB), query optimization techniques, replication, load balancing, and cluster management tools
• Strong understanding of database security, access control, backup/restore procedures, and data warehousing concepts
• Experience with database monitoring tools and technologies to optimize performance, troubleshoot issues, and ensure high availability

Responsibilities

• Design, implement, and maintain a replicated and sharded database setup that ensures data consistency, availability, and performance
• Monitor and review queries executed in production to identify opportunities for optimization, applying necessary techniques to improve query performance, efficiency, and overall system responsiveness
• Ensure the high availability, disaster recovery, and reliability of our database infrastructure, implementing measures to minimize downtime and ensure business continuity
• Manage and monitor data pipelines that populate our data warehouse, ensuring high-quality data accuracy, integrity, and timeliness. Develop and implement data warehousing strategies to meet business needs
• Document database architecture and design to educate software developers on database fundamentals, best practices, and performance considerations
• Perform database upgrades and migrations, ensuring minimal disruption to production services and maintaining database integrity
• Ensure the security of our database systems, implementing measures to protect against data breaches, unauthorized access, and other threats. Comply with relevant regulations and industry standards for database security
• Review new application queries created by software developers for correctness and efficiency, applying expertise to identify potential performance issues and optimize query performance
• Be available on-call to troubleshoot and repair database infrastructure issues, ensuring the reliability and availability of our databases
• Familiarize yourself with various database monitoring tools and apply knowledge to optimize database performance, identify potential issues, and implement corrective actions

Preferred Qualifications

• Experience with cloud-based MySQL deployments (e.g., AWS RDS, Google Cloud SQL) or containerization technologies (e.g., Docker)
• Experience with Data warehouse platforms e.g. Redshift, Snowflake
• Experience with ETL tools such as Stitch, AWS Glue
• MongoDB experience
• Knowledge of automation tools and scripts for database administration tasks
• Familiarity with DevOps practices and principles

Benefits

• Competitive compensation package and benefits
• Professional growth opportunities through continuous learning and skill development