Description
Oakland, California, United States, AMERPosition Title: Senior Staff Software Engineer - Binary Log Data Replication
From Fivetrans 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. Were proud that more organizations continue to leverage our technology every day to become truly data-driven.
About the Role
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. 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.
Fivetran is the epitome of data-driven-development our engineering team is focused on building a world class product that:
-
Facilitates Data Analytics join our mission to reliably deliver best-in class schemas, and clean data, designed to be intuitively useful to analysts.
-
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.
-
Is Absolutely Dependable work to make Fivetran the most reliable and secure component of our customers data infrastructure.
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.
This is a full-time, hybrid position based out of our Toronto, Canada 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.
Technologies Youll Use
Java, SQL Server, Oracle, SQL, Kubernetes
What Youll 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: 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: 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: 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.
Skills Were Looking For
- 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 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.
Bonus Skills
- 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.
#LI-HYBRID #LI-AM1
The compensation range displayed on this job posting reflects the minimum and maximum target for new hire compensation for the target position and level, and may include sales incentives or target bonuses depending on the role. Our compensation ranges are determined by role, level, and location. Our job titles may span more than one career level. Within the range, individual compensation is determined by additional factors, including job-related skills, experience, relevant education or training, business need, market demands. The compensation range is subject to change and may be modified in the future. Your recruiter can share more about the specific compensation range for your location during the hiring process.
Perks and 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.
*May vary by country and worker type - please reach out to your recruiter for more information
Click here to learn more about Fivetran's Benefits by Region.
Were honored to be valued at over $5.6 billion, but more importantly, were proud of our core values of Get Stuck In, Do the Right Thing, and One Team, One Dream. Read about us in Forbes.
Fivetran brings together high-quality talent across the globe to make data access as easy and reliable as electricity for our customers. We value and recognize that our customers benefit from having innovative teams made of people from many backgrounds, experiences, and identities. Fivetran promotes diversity, equity, inclusion & belonging through attracting, recruiting, developing, and retaining a diverse workforce, not only because it is the right thing to do, but because it helps us build a world-class company to better serve our customers, our people and our communities.
To learn more about Fivetrans culture and what its like to be part of the team, click here and enjoy our video.
To learn more about our candidate privacy policy, you can read our statement here.
We are committed to ensuring that all candidates have an equal opportunity to participate in our interview process. If you require accommodations at any stage of the process due to a disability, medical condition, or any other circumstance, please don't hesitate to submit your request by filling out this form. We will work with you to provide reasonable accommodations to facilitate your participation and ensure a fair and accessible interview experience. Your request and any information provided will be kept confidential and will not impact your candidacy. We look forward to hearing from you and accommodating your needs to the best of our ability.
Equal Opportunity Employer, including disability/protected veterans
PI284868609