Software Engineer II - Databases

About the Role Fivetran is looking for a Software Engineer II to join our fast-growing company. As a part of the Oracle Connector Team, 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 data replication and build a world class ELT solution for 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 tools, 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 Toronto, Canada. Technologies You’ll Use Java, C, Oracle, SQL, Docker and Kubernetes What You'll Do
• Dive deep into data replication debugging, analyzing existing code that is in use by hundreds of customers today. Some clients are operating the largest Oracle clusters in the world.
• Analyze new features that are introduced by Oracle in recent releases and determine how to develop supporting features.
• Contribute to the efforts to 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 technical roadmap for the team.
• Contribute to hiring by participating in the interview process. Skills We're Looking For
• Code:
  • 3+ years programming in Java or C languages
  • Writes well-structured and performant code
  • Be able to dive into code that has been previously written and suggest improvements
• Troubleshoot:
  • 1 experience on-call or supporting customer with live production system
  • Demonstrated ability to solve complex problems
• Design:
  • Understand and can explain how to build high performance systems and processes
  • Have an analytical mindset that helps you identify design flaws in existing systems and come up with improvements
• System:
  • 1+ year of infrastructure as code on Docker/Kubernetes, AWS CloudFormation, Terraform, Google Cloud Deployment Manager, or equivalent.
• Collaboration:
  • Experience working in large distributed teams Bonus Skills
• Working experience with database internals such as storage format, compression techniques, encryption, disaster recovery, transaction management, or high availability.
• Working experience in designing and developing file, event, application, or database connectors.
• Working experience with advanced Java development such as multi-threads, multi-tasking, different asynchronous programming mechanisms, garbage collector tuning, etc.
• Working experience setting up, maintaining and tuning production Oracle RDBMS.

#LI-MC1 #LI-HYBRID