Search jobs > Toronto, ON > Database administrator

Database Administrator

Sync.com
Toronto, ON, CA
Full-time
Quick Apply

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 Powered by JazzHR

13 days ago
Related jobs
BMO Financial Group
North York, Ontario

Understands data in terms of its business and technical lifecycle (Create, Release, Update, and Delete), technical underpinnings of database theories (e. Assists in creation, implementation/installation, configuration, change, and support of data models, databases, data marts, data warehouses. Proac...

Broadridge
Toronto, Ontario

Database Administrators participate in the design, build, run, and modernization of our databases. You will perform all database administration tasks and should be well versed with database features, utilities, and recovery procedures. They are part of a senior technical team to ensure that our data...

AGMD GROUP
Mississauga, Ontario

Operate database management systems to analyze data. ...

pt Health
Toronto, Ontario

Senior Database Administrator / Developer. You are a database geek with many years of professional work experience and know how to code T-SQL as well as troubleshoot long running queries and other database performance tweaks. Manage and optimize databases hosted on Azure SQL Database, Azure SQL Mana...

Macropus Global
Canada

Oracle Database Administrator/Team Leader. Our client has an immediate need for an Oracle Database Administrator. The Oracle Database Administrator works closely with all data centre professionals and the successful incumbent will be a member of the data center DBA team. Oracle Database Administrato...

Uncharted Talent Inc
Toronto, Ontario

We are seeking an experienced SQL Server Database Administrator to manage and maintain our production SQL Server Platform as a Service (PaaS) databases. The ideal candidate will have a proven track record of optimizing database performance in a high-concurrency transaction environment and will play ...

Acosta
Mississauga, Ontario

The SQL Server DBA plays an important role that is responsible for managing, maintaining, monitoring and troubleshooting our database infrastructure both On-Premises and in the Cloud. The primary responsibility of the DBA is to manage the daily operations for MS SQL Server database technologies in m...

Astra North Infoteck Inc.
Toronto, Ontario

Weekly twice / thrice to visit office.DB2 on any OS : 10+ Experience (Senior).Data volume : experience with heavy ETL processing millions of records.Working knowledge of Linux / Unix commands.Experience with Batch Jobs Automation : Autosys or CA7.Experience with ITIL Processes....

Alltech Consulting Services
Toronto, Ontario

Expert level knowledge of Oracle 19c database administration, maintenance, security implementation, upgrade and patching, database performance tuning, sizing and capacity planning, database backup and recovery using RMAN. ...

Global Technical Talent
Toronto, Ontario

Create physical database designs, operate and administer the database management system (DBMS) including database optimization, performance tuning, backup, and recovery. The consultant will be responsible for creating physical database designs and operating and administering the database management ...