Database Engineer

Remote · United States · DevOps expand job description ↓

Description

Harvest is an independent software company that makes tools to help businesses run more smoothly. For the past 14 years, our customers have relied on our products as a critical part of their day-to-day operations. They’re the reason we’re still in business, and their needs drive our product decisions.

Harvest started as a team of 3 and grew slowly to today’s current total of just over 55 lovely faces. Though we have an office in NYC, we hire the right people for the job no matter where they call home. We’ve worked as a remote team since the beginning, and we work hard to make sure everyone feels included and heard.

One more thing, and this is a big deal: if you are a member of a group that is historically underrepresented and disadvantaged in tech (and society generally), please know that we welcome your application with open and enthusiastically-waving arms. We want to meet you!


What would you be working on?

Working alongside our friendly Senior Database Engineer, we’d be looking to you to guide our efforts in all areas of database design, performance, and reliability. You'll champion performance, and encourage best practices, on all database projects across multiple teams. We rely heavily on MySQL to store our data, but we also use Elasticsearch, Redis, and Memcache currently.

Collaborating with product developers, and operations team members, you'll be working to make sure our database infrastructure performs reliably. This typically includes translating application requirements to schema, examining indexes, query analysis, deploying clustering tools, designing backup solutions, investigating caching issues, and more.

You’d implement monitoring to catch slow queries, and iterate on making them perform better.

You might see an opportunity to provide value to Harvest customers with enhanced data reporting functionality, and we’d be looking to you to collaborate with different teams across the organization to help roll new product features out.

Operations at Harvest

The Harvest Systems Operations Team is currently seven people and we have one open position. We have the task of keeping all of our applications running smoothly. We have wide ranging responsibilities, and lots of leeway to have fun in the process. On our team we prefer to self-select which projects we work on, choosing what interests you the most.

Why are we hiring at this time?

Good question! This is an exciting time on the infrastructure front: we are designing new production systems in Google Cloud, and someone with experience in designing cloud database infrastructure will have a lot of fun at this particular stage we are at.

Requirements

Who You Are


If you know the following stuff, you've likely been doing the type of things we are looking for help with:

  • Managing MySQL infrastructure which is processing tens of thousands of queries per second
  • Collaborating with developers to design great data models and schemas. If you can read Ruby code, and wrestle with Ruby on Rails opinions, you’ll fit in really quickly here.
  • Troubleshooting, and performance tuning complex SQL queries
  • Devising methods for schema changes to large, busy databases
  • Working with ORM libraries (eg: ActiveRecord) to understand application database needs
  • Implementing caching strategies
  • Deploying tools like Orchestrator for high availability
  • Devising monitoring tools for database infrastructure
  • Understanding cloud infrastructure


We are a flexible remote-first work environment, and we are looking for candidates who are able to work hours with a 2-hour to 3-hour overlap to Central Standard Time.

Did we mention a sense of humor yet? It's important, we like to have fun while we work.


When You Apply

  • Tell us a bit about yourself, your hobbies and interests.
  • Why did you decide to apply to Harvest specifically?
  • Let us know what you like about MySQL, or what you really dislike about MySQL. Perhaps you have some strong opinions about PostgreSQL? Do you have a story about an SQL query that was challenging to optimize? Share some thoughts with us that let us know you have spent quality time working with an Open Source RDBMS in a production setting, and we’ll know to pay careful attention to your application.
Personal information
Your Profile
Application Details