Senior Software Engineer - Binary Log Data Replication

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.

Fivetran is building data pipelines to power the modern data stack for thousands of companies. Fivetran is looking for a Senior Staff Software Engineer enthusiastic to join our fast‑growing company. As part 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.

We want someone who wants to learn and apply the key values that make our product great, dive deep into complex investigations into database transaction logs, binary log parsing, data replication, and build a world‑class ELT solution for SQL Server or Oracle systems.

We emphasize using no‑nonsense code, and take great pride in the simplicity and effectiveness of the systems we build. Our back‑end is built on Java, C, Postgres, and Kubernetes, and our front‑end is built on React and Type Script.

This is a full‑time, hybrid position based out of our New York office. Our hybrid work model offers a blend of remote flexibility and in‑person collaboration, including two days in the office each week to connect and build as a team.

Java, SQL Server, Oracle, SQL, Kubernetes

• 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: Utilize reverse engineering techniques to understand and improve upon the database binary log structure for better data integrity and replication performance.
• Dive Deep into Data Replication: Debug and analyze existing code that is in use by hundreds of customers today, including those operating the largest SQL Server clusters.
• Analyze New Features: Analyze 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; call for improvement in all areas of Fivetran's codebase and infrastructure.
• Cloud and Scale: Be a 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. Also collaborate with Database Group leadership in helping craft 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 (GTM) teams to assist in challenging customer situations. Provide technical expertise and solutions to ensure customer satisfaction and support Fivetran's growth objectives.

• 10+ years programming in Java, C or C++ languages, 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.
• Be able to solve critical problems for our largest customers to minimize impact.
• Be able to dive into code that has been previously written and suggest improvements.
• Understand and can explain how to build high performance systems and processes.
• Able to define project requirements and be proficient at designing software and infrastructure.
• Enjoy mentoring and growing junior developers.
• Have an analytical mindset that helps you identify design flaws in existing systems and come up with improvements.
• Experience understanding customer requirements and/or problems and breaking them down into engineering tasks.

• Advanced knowledge in reverse engineering, particularly with database systems.
• Experience in working with open source…