Senior Staff Software Engineer (Binary Log Data Replication)

About the Role

Fivetran is building data pipelines to power the modern data stack for thousands of companies. The Database Team focuses on SQL Server and 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, diving deep into complex investigations of database transaction logs, binary log parsing, and data replication to deliver a world‑class ELT solution for SQL Server or Oracle systems.

We emphasize no‑nonsense code and take pride in simple, effective systems. Our back‑end is built on Java, C, Postgres, and Kubernetes; our front‑end on React and Typescript.

Product Focus

• Facilitates Data Analytics – reliably deliver best‑in‑class schemas and clean data for analysts.
• Contributes to our Community – develop tools like Data Lakes, SQL‑based Transformations, and schema explorers.
• Is Absolutely Dependable – make Fivetran the most reliable and secure component of our customers’ data infrastructure.

Technologies You’ll Use

Java, SQL Server, Oracle, SQL, Kubernetes

What You’ll Do

• SQL Server and/or Oracle Binary Log Reading: Develop and implement strategies for reading SQL Server or Oracle binary logs to enhance data replication accuracy and efficiency.
• Reverse Engineering Database Binary Logs: Use reverse engineering techniques to understand and improve the database binary log structure for better data integrity and replication performance.
• Dive Deep into Data Replication: Debug and analyze existing code used by hundreds of customers, including those running the largest SQL Server clusters.
• Analyze New Features: Evaluate new features introduced by SQL Server and/or Oracle in recent releases and determine how to develop supporting features.
• Contribute to Maintenance and Improvement: Participate in the maintenance and improvement of existing connectors and call for improvement in all areas of Fivetran’s codebase and infrastructure.
• Cloud and Scale: Be part of the process to move a high‑performance client‑side service to the cloud and operate at scale.
• Software Designs and Technical Roadmap: Develop software designs and a technical roadmap for the team, and collaborate with Database Group leadership on the rolling 12‑month technical roadmap for the organization.
• Assist Customer Success and GTM Teams: Work closely with the Customer Success and Go‑To‑Market teams to assist in challenging customer situations and provide technical expertise to ensure customer satisfaction and support growth objectives.

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 and performant code.
• Can solve critical problems for our largest customers to minimize impact.
• Can dive into previously written code and suggest improvements.
• Understands and can explain how to build high‑performance systems and processes.
• Able to define project requirements and design software and infrastructure.
• Enjoys mentoring and growing junior developers.
• Has an analytical mindset that helps identify design flaws in existing systems and propose improvements.
• Experience understanding customer requirements and breaking them into engineering tasks.

Bonus Skills

• Advanced knowledge in reverse engineering, especially with database systems.
• Experience working with open‑source projects and 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), paid sick time, inclusive parental leave, 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 therapy, coaching, and self‑guided mindfulness exercises for employees and covered dependents.

Work Arrangement

This is a full‑time, hybrid position based out of our Toronto, Canada office. Our hybrid model offers two days in the office each week for collaboration.

#J-18808-Ljbffr