Sync.com

Database Administrator

Posted 8 Days Ago

Be an Early Applicant

Toronto, ON

Senior level

Cloud • Information Technology

The Role

As a Senior MySQL Database Administrator, you will design, implement, and maintain a scalable MySQL database infrastructure. Responsibilities include ensuring high availability, optimizing queries, managing data pipelines, conducting upgrades, enhancing security, and providing on-call support. You will also document procedures, validate application queries, and utilize monitoring tools for performance optimization.

Summary Generated by Built In

About the company
Since 2011, Sync has been on a mission to provide a safe space for the world to collaborate through its award-winning cloud apps and ground-breaking privacy protection features to share big ideas, store important information and collaborate on game-changing projects, making the world a better place.
Our core values are constant - four fundamental forces that help define us, shape us, guide us, and unify us. They govern our universe: who we are as a company, how we act as individuals, and what we can accomplish as a team. Humanity, ownership, growth, and commitment: when we’re in sync with our values and each other, we bring people together to do truly incredible things.
About the Role
We are seeking an experienced Senior MySQL Database Administrator to join our team. As a key member of our database operations team, you will be responsible for designing, implementing, and maintaining a high-performance, scalable, and reliable MySQL database infrastructure.
This is a remote role.
Responsibilities

Database Infrastructure Management: Design, implement, and maintain a replicated and sharded database setup that ensures data consistency, availability, and performance.
Query Performance Analysis and Optimization: Monitor and review queries executed in production to identify opportunities for optimization, applying necessary techniques to improve query performance, efficiency, and overall system responsiveness.
Database High Availability and Reliability: Ensure the high availability, disaster recovery, and reliability of our database infrastructure, implementing measures to minimize downtime and ensure business continuity.
Data Pipeline Management and Data Warehousing: 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.
Documentation and Knowledge Sharing: Document database architecture and design to educate software developers on database fundamentals, best practices, and performance considerations.
Database Upgrade and Migration: Perform database upgrades and migrations, ensuring minimal disruption to production services and maintaining database integrity.
Database Security and Compliance: 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.
Query Review and Validation: Review new application queries created by software developers for correctness and efficiency, applying expertise to identify potential performance issues and optimize query performance.
On-Call Support and Troubleshooting: Be available on-call to troubleshoot and repair database infrastructure issues, ensuring the reliability and availability of our databases.
Database Monitoring and Management Tools: Familiarize yourself with various database monitoring tools and apply knowledge to optimize database performance, identify potential issues, and implement corrective actions.

Qualifications

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.

Nice to Have:

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

Why Join Sync?

Opportunity to work with cutting-edge technologies and contribute to a dynamic and innovative team.
Chance to make a significant impact on the infrastructure that underpins our software products.
Competitive compensation package and benefits.
Professional growth opportunities through continuous learning and skill development.

Sync.com is an equal opportunity, dedicated to building a diverse and inclusive team. We encourage applications from all qualified candidates and will accommodate applicants’ needs throughout the recruitment, assessment, and selection process. If selected to participate in the process, please inform us of the nature of any accommodation(s) that you may require.
#LI-Remote