Senior Staff Software Engineer - Binary Log Data Replication, Toronto

From Fivetran’s founding until now, our mission has remained the same: to make access to data as simple and reliable as electricity. With Fivetran, customer data arrives in their warehouses, canonical and ready to query, with no engineering or maintenance required. We’re proud that more organizations continue to leverage our technology every day to become truly data-driven.

About The Role Fivetran is building data pipelines to power the modern data stack for thousands of companies. We’re looking for a Senior Staff Software Engineer to join our fast-growing company. As a member of the Database Team with a focus on SQL Server, Oracle binary log reading and change data capture, you will help build new features of our data pipeline service, improve our software architecture, and maintain reliable operation of the service. You will dive deep into complex investigations into database transaction logs, binary log parsing, and data replication to build a world‑class ELT solution for SQL Server or Oracle systems.

Our mission is to reliably deliver best‑in‑class schemas and clean data, empower analysts with tools like SQL‑based transformations, and remain a dependable, secure component of our customers’ data infrastructure.

Technologies You’ll Use

Java

SQL Server

Oracle

SQL

Kubernetes

What You’ll Do

Develop and implement strategies for reading SQL Server or Oracle binary logs to enhance data replication accuracy and efficiency.

Use reverse engineering techniques to improve the database binary log structure for better data integrity and replication performance.

Debug and analyze existing code used by hundreds of customers, including those operating the largest SQL Server clusters.

Analyze new features introduced by SQL Server and/or Oracle and determine how to develop supporting features.

Contribute to the maintenance and improvement of existing connectors and call for improvement in all areas of Fivetran’s codebase and infrastructure.

Help move a high‑performance client‑side service to the cloud and operate it at scale.

Develop software designs and a technical roadmap for the team, collaborating with Database Group leadership to craft a rolling 12‑month technical roadmap for the organization.

Work closely with the Customer Success and Go‑To‑Market (GTM) teams to assist in challenging customer situations, providing technical expertise and solutions to ensure customer satisfaction.

Skills We’re Looking For

10+ years programming in Java, C, or C++ with a strong background in SQL Server.

Experience with SQL Server and/or Oracle binary log reading and the ability to reverse engineer database binary logs.

Writes well‑structured, performant code.

Ability to solve critical problems for our largest customers to minimize impact.

Ability to dive into previously written code and suggest improvements.

Understand and explain how to build high‑performance systems and processes.

Able to define project requirements and design software and infrastructure.

Enjoy mentoring and growing junior developers.

Have an analytical mindset to identify design flaws and propose improvements.

Experience understanding customer requirements and breaking them down into engineering tasks.

Bonus Skills

Advanced knowledge in reverse engineering of database systems.

Experience working on open source projects with collaborators.

Experience in data processing (ETL, ELT) and/or cloud‑based platforms.

Experience designing and developing file, event, application, or database connectors.

Experience working in a cloud environment utilizing AWS, GCP, Kubernetes, Docker, or similar technologies.

Perks and Benefits

100% employer‑paid medical insurance

Generous paid time‑off policy (PTO), plus paid sick time, inclusive parental leave policy, holidays, and volunteer days off

RSU stock grants

Professional development and training opportunities

Company virtual happy hours, free food, and fun team‑building activities

Monthly cell phone stipend

Access to an innovative mental health support platform offering personalized care and resources, including therapy, coaching, and self‑guided mindfulness exercises for all covered employees and their dependents

E‑EO Statement Fivetran promotes diversity, equity, inclusion&belonging through attracting, recruiting, developing, and retaining a diverse workforce, not only because it is the right thing to do, but because it helps us build a world‑class company to better serve our customers, people, and communities.

Ontario Pay Range: $206,699—$258,374 CAD

#J-18808-Ljbffr