Internship Software Reverse Engineer Jobs in Toronto, ON

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 You'll Use

Java, SQL Server, Oracle, SQL, Kubernetes

What You'll 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 We're 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