Database Engineer

Harvest


3 weeks ago

07/28/2019 10:21:23

Job type: Full-time

Category: Software Dev


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.

Please mention that you come from Remotive when applying for this job.

Help us maintain Remotive! If this link is broken, please just click to report dead link!

similar jobs

  • 1 week ago

    You’ll be working on big, exciting projects like optimizing our social media post queueing system, building out UI components using React, adding support for social media platform-specific features like native video, and getting our onboarding juuuust right so that every user has a mind-blowing experience from their very first login.

    Our stack is Rails 5.2, Ruby 2.6, Sidekiq, Postgres 11, and Redis running on Heroku, with React & Redux on the front-end. It’s a great stack, and we take our time to write solid code and proper tests to make sure it stays that way.


    You’ll be joining our small Product & Engineering team, working daily with:

    - Chad, Engineering Director

    - Kevin, Product Director

    - Yuta, Senior Full-Stack Developer, who also serves as our Lead Architect

    - Sarah, Usability Project Manager, who also serves as our dedicated QA


    And you’ll also be frequently working alongside Kristina and Megan on our Customer Experience team. 


    **Spoiler alert** Take a sneak peek at this position's current "Work Agreement" here: http://ed.gr/sfsdev

    (We write these up with every employee at MeetEdgar and update them at least once a year to make sure we're all on the same page about how we're being evaluated and what types of expectations surround our roles.)

  • Timescale (US or Europe)
    2 days ago

    We need extraordinary engineers to join our team. You will act as both architect and programmer, designing, coding, and testing the core of our open-source time-series database. Our focus is on building a scalable, reliable, robust, usable, secure, performant database. You should have strong systems-building experience and expertise in C, understand both query optimization and database systems, and ideally already be a PostgreSQL expert (or show an interest and quick aptitude to become a PostgreSQL expert). And the future of managing and making sense of the deluge of time-series data should excite you.

    This is a full time position at our office in New York City, Stockholm, or Remote.

    Responsibilities:

    • Play a core role in helping to design and develop new database capabilities, including analytics, clustering and distributed operations, query and storage optimizations, and more.

    • Develop, test, and release new features and functionality from our database technical roadmap.

    • Continually improve, optimize, and test existing functionality of TimescaleDB.

    • Work with engineers both at Timescale and the open-source community to coordinate new functionality and deliver powerful integrations of the database into large applications and pipelines.

    • Provide elevated technical assistance to high-value customers, gaining insight into the needs and experiences of our users.

    • Be an enthusiastic and personable teammate, receiving and providing code reviews, and otherwise partnering and helping other engineers.

    Requirements:

    • Bachelor’s degree in computer science or equivalent experience; advanced degrees also welcome (most of our core engineering team have PhDs in computer systems).

    • 5+ years engineering experience.

    • Expertise building industrial-strength software in C/C++ for large code-bases.

    • Experience in PostgreSQL internal development highly desirable (but not required).

    • Solid knowledge of SQL, query processing and database engines, concurrency control, data replication, and/or distributed systems.

    • Passionate about building highly-reliable system software.

    • Experience with industry-standard software validation tools helpful, e.g., valgrind, Coverity, pprof, etc.

    Benefits

    • Premium medical, dental, and vision coverage

    • Stock options

    • 401k retirement plan

    • Flexible PTO and family leave

    • FSA and Dependent FSA plans

    • Educational self-improvement benefits

    • Commuter benefits

    • Flexible schedule

    • Awesome coworkers

    Time Series is everywhere, and Timescale is helping developers and companies make sense of it.

    Businesses worldwide trust TimescaleDB for mission-critical applications from industries as varied as manufacturing, finance, utilities, telecom, mining, ad tech, oil & gas, and the smart home. Applications built on TimescaleDB include IOT, complex monitoring systems, industrial machine data analysis, geospatial asset tracking, operational data warehousing, and financial risk management; via the edge, on premise, and cloud deployments.

    TimescaleThe team is based in New York City (HQ) and Stockholm, and is backed by top tier investors, including Benchmark Capital, New Enterprise Associates, Icon Ventures, and Two Sigma Ventures.

  • Interfolio, Inc (US only)
    3 days ago

    Interfolio is on a mission to build smart, inspired and useful products for faculty and academic communities. By building an engine for faculty activity, decisions, and data, Interfolio has become the first mover in defining and category of faculty-focused technology that cultivates goal-oriented collaboration around academic decision-making.

    Interfolio operates the first holistic faculty information system to support the full lifecycle of faculty work, from job seeking to review, tenure, sabbatical, committee work, research, and beyond. Offering colleges and universities increased and insight into faculty data to help achieve their strategic initiatives, Interfolio believes that advancing the faculty will advance the institution.

    What’s even better than that?

    We’ve crafted a fun, collegial, dynamic culture that celebrates team and individual success almost daily. We’ve got a lean team of super-smart, super-hard working, local and remote colleagues who collaborate closely to produce a valuable service for an industry we’re passionate about. And, we genuinely like working with each other and with our clients.

    Like what you’ve heard so far?

    Then consider joining our Engineering team. The position of Software Engineer (Elixir) can be a remote (based within the continental United States) OR work out of our office based in Washington, DC.

    We're seeking a talented and energetic Software Engineer with a deep understanding of Elixir to join our tight-knit team. You must be focused on producing high quality and maintainable code. This role offers a high level of creativity, and an opportunity to design the future with a company that is challenging the status quo.

    At Interfolio, we are committed to diversity and the principle of equal employment opportunity for all employees. You will receive consideration for employment without regard to race, color, religion, national, social or ethnic origin, age, gender identity and/or expression, sexual orientation, family or parental status (including pregnancy), or any other status protected by the laws or regulations in the locations where we operate.

    Required Experience

    • 3-5 years of relevant work experience

    • Deep knowledge of Elixir

    • Databases: MySQL, Postgres, NoSQL (Dynamo, Elasticsearch, JSONB)

    • Data cleaning, normalization, and transformation

    • Building, maintaining, and optimizing data processing pipelines

    • Understanding of Enterprise Architecture and the use of Microservices

    • Strong analytical and problem-solving skills

    • Experience with RDF and Graph data structures

    • Passion for using technology and data to solve business problems

    • Production experience with an industry standard web programming language and framework (Python/Django, Ruby/Rails, Elixir/Phoenix)

    • Experience with Git and/or Github or comparable version control system

    • Experience with GraphQL or Restful APIs

    In addition, you should

    • Possess a strong interest in higher education, startups, and/or SaaS technology

    • Be able to speak and write fluently in English (as a minimum requirement)

    • Be able to 20% travel (travel includes mostly quarterly planning meetings that take place in DC area)

    • Live within the continental United States

    In addition to a competitive salary, Interfolio offers a robust benefits package that includes medical insurance, unlimited PTO, a yearly wellness benefit stipend, a yearly professional development stipend, 401k, and professional development opportunities.

    Our culture sets us apart—we look forward sharing more about our company and our team!

Remotive can help!

Not sure how to apply properly to this job? Watch our live webinar « 3 Mistakes to Avoid When Looking For A Remote Startup Job (And What To Do Instead) ».

Interested to chat with Remote workers? Join our community!