Fivetran is building data pipelines to power the modern data stack for thousands of companies. The company is looking for a Senior Staff Software Engineer to help build new features of their data pipeline service, improve software architecture, and maintain reliable operation of the service, specifically focusing on SQL Server and Oracle binary log reading and change data capture.
Requirements
- 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.
Responsibilities
- Develop and implement strategies for reading SQL Server or Oracle binary logs to enhance data replication accuracy and efficiency.
- Utilize reverse engineering techniques to understand and improve upon the database binary log structure for better data integrity and replication performance.
- Debugging and analyzing existing code that is in use by hundreds of customers today, including those operating the largest SQL Server clusters.
- Analyze new features introduced by SQL Server and/or Oracle in recent releases and determine how to develop supporting features.
- Participate in the maintenance and improvement of existing connectors; call for improvement in all areas of Fivetran's codebase and infrastructure.
- Be a part of the process to move a high-performance client-side service to the cloud and operate at scale.
- 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.
Other
- 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.
- Enjoy mentoring and growing junior develops.
- 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.
