Senior Staff Software Engineer - Binary Log Data Replication

<div class="content-intro"><p>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.</p></div><p><span style="font-size: 10pt;"><strong>About the Role</strong></span></p> <p><span style="font-size: 10pt;">Fivetran is building data pipelines to power the modern data stack for thousands of companies.</span></p> <p><span style="font-size: 10pt;">Fivetran is looking for a Senior Staff Software Engineer enthusiastic to join our fast-growing company. Database Team with a focus on SQL Server, Oracle binary log reading and change data capture, you will be responsible to help build new features of our data pipeline service, help improve our software architecture, and maintain reliable operation of the service. We're looking for 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.</span><br><br><span style="font-size: 10pt;">Fivetran is the epitome of data-driven-development — our engineering team is focused on building a world class product that:</span></p> <ul> <li style="font-size: 10pt;"> <p><span style="font-size: 10pt;">Facilitates Data Analytics — join our mission to reliably deliver best-in class schemas, and clean data, designed to be intuitively useful to analysts.</span></p> </li> <li style="font-size: 10pt;"> <p><span style="font-size: 10pt;">Contributes to our Community — help develop tools like Data Lakes, SQL-based Transformations, and schema explorers to empower analysts to choose the best tools, and to make those tools more powerful.</span></p> </li> <li style="font-size: 10pt;"> <p><span style="font-size: 10pt;">Is Absolutely Dependable — work to make Fivetran the most reliable and secure component of our customers’ data infrastructure.</span></p> </li> </ul> <p><span style="font-size: 10pt;">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 Typescript.</span></p> <p><span style="font-size: 10pt;">This is a full-time, hybrid position based out of our Oakland, CA 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.</span></p> <p><span style="font-size: 10pt;"><strong>Technologies You’ll Use</strong></span></p> <p><span style="font-size: 10pt;">Java, SQL Server, Oracle, SQL, Kubernetes</span></p> <p><span style="font-size: 10pt;"><strong>What You’ll Do</strong></span></p> <ul> <li style="font-size: 10pt;"><span style="font-size: 10pt;"><strong>SQL Server and/or Oracle Binary Log Reading: </strong>Develop and implement strategies for reading SQL Server or Oracle binary logs to enhance data replication accuracy and efficiency.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;"><strong>Reverse Engineering Database Binary Logs: </strong>Utilize reverse engineering techniques to understand and improve upon the database binary log structure for better data integrity and replication <strong>performance.</strong></span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;"><strong>Dive Deep into Data Replication: </strong>Debugging and analyzing existing code that is in use by hundreds of customers today, including those operating the largest SQL Server clusters.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;"><strong>Analyze New Features: </strong>Analyze new features intro ... (truncated, view full listing at source)