Senior Staff Software Engineer - Binary Log Data Replication
About The Position
Fivetran is looking for a Senior Staff Software Engineer to join our Database Team with a focus on SQL Server, Oracle binary log reading and change data capture. In this role, you will be responsible for building new features for our data pipeline service, improving our software architecture, and maintaining the reliable operation of the service. The ideal candidate will be eager to learn and apply the key values that make Fivetran's product great, dive deep into complex investigations into database transaction logs, binary log parsing, and data replication, and help build a world-class ELT solution for SQL Server or Oracle systems. Fivetran emphasizes data-driven development, building a world-class product that facilitates data analytics, contributes to the community through tools like Data Lakes and SQL-based Transformations, and is absolutely dependable. The back-end is built on Java, C, Postgres, and Kubernetes, and the front-end is built on React and Typescript. This is a full-time, hybrid position based out of our Toronto, Canada office, with a blend of remote flexibility and in-person collaboration, including two days in the office each week.
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.
- 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.
Nice To Haves
- Advanced knowledge in reverse engineering, particularly with database systems.
- Experience in working with open source projects with other collaborators.
- Experience in data processing (ETL, ELT) and/or cloud-based platforms.
- Experience in designing and developing file, event, application, or database connectors.
- Experienced working in a cloud environment utilizing AWS, GCP, Kubernetes, Docker, BuildKite, or similar technologies.
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.
- 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 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.
- Collaborate with Database Group leadership in helping craft the 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.
- Provide technical expertise and solutions to ensure customer satisfaction and support Fivetran's growth objectives.
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 that offers personalized care and resources in areas such as: therapy, coaching, and self-guided mindfulness exercises for all covered employees and their covered dependents.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
