Database Performance Engineer

Promote Project; Seattle (WA); On-site; USD 150,000 - 200,000; Full time

Job description

Charlotte, North Carolina, United States

50000 - 100000 a year (US Dollars)

Description

Database Performance Engineer - East Coast

Position Overview

Our customers are at the forefront of some of the most interesting data in the world, using SingleStore DB to push the boundaries daily. To do this well, they leverage the expertise of our Support Engineering Team, composed of technical subject matter experts on the frontlines of critical product and customer issues.

Our Database Performance Engineers develop a deep understanding of the SingleStore query optimizer and query execution. They leverage that knowledge to help customers achieve the full lightspeed capabilities of the SingleStore engine.

This is a customer-facing role where the problems that you are investigating and solving have been escalated to you straight from our customers. The Database Performance Engineer role is within our Support Engineering department and reports to Support Engineering management. Additionally, some of your closest colleagues will be members of the Query Optimization and Query Execution engineering teams as you collaborate on the behavior of the optimizer, bugs, and general product behavior daily.

You should be excited to:

• Explore new features and improvements that are making your job easier and providing you with a constant source of new subject matter and product features to delve into.
• Dive into the internals of our query optimizer to become an expert with our query engine.
• Keep up to date on the ways statistical information is collected on tables and used in our cost-based query optimizer.
• Discover how even small changes in query text can achieve 10x performance gains.
• Reproduce query performance problems across various on-premise and cloud platforms to understand the whole scope of an issue, even parts that are Linux or systems-related.
• Enlighten a customer on database implementation for peak performance.
• Be part of a small, tight-knit team where you can have a real impact and help shape product direction.

Role and Responsibilities

• As a subject matter expert, collaborate with our customers and the rest of the Support Engineering team on escalated query tuning and workload performance-related support tickets.
• Understand how the underlying Linux host configuration can impact database performance and suggest changes to improve it.
• Build reproductions of poorly performing customer workloads to investigate issues along with the query processing team to identify bugs or areas where the product can be enhanced.
• Collaborate with software developers, sales engineers, and technical account managers to keep all internal teams up to date with the current customer status.
• Work to streamline and improve various Support and Engineering processes and tools, author new internal run-books or public documentation, and help the team continually improve efficiency and effectiveness.
• Participate in our on-call rotation that may include weekends and holidays.

Required Skills and Experience

• 8+ years of previous experience as a DBA or hands-on database work.
• Deep expertise in relational/distributed database implementation, advanced SQL query optimization, and SQL query tuning.
• Strong background in general product troubleshooting, keeping in mind that query processing issues can be impacted by database or Linux configuration and resource availability.
• A solid Linux performance background. That means you are hands-on with Linux, and your skills include generating and reading flame graphs, checking system resource utilization, and parsing verbose log files—bonus points for familiarity with Kubernetes.
• Experience with a scripting or coding language. Whether it’s C++, Python, Go, or Bash, you should have a go-to solution for quick problem-solving and be able to navigate through our extensive code base.
• Familiarity with distributed systems and AWS/GCP. You understand how organizations deploy and maintain distributed applications and services across multiple machines and know how to analyze these systems for performance bottlenecks.
• Strong written and verbal English communication skills. Have the ability to explain technical concepts to a wide range of end-users.
• Note: Applicants from anywhere in the U.S. are welcome to apply, but must be available to work during Eastern Standard Time (EST) business hours.

SingleStore delivers a cloud-native database with the speed and scale to power the world’s data-intensive applications. With a distributed SQL database that introduces simplicity to your data architecture by unifying transactions and analytics, SingleStore empowers digital leaders to deliver exceptional, real-time data experiences to their customers.

SingleStore values individuals for their unique skills and experiences, and we’re proud to offer roles in a variety of locations across the United States. Salary is based on permissible, non-discriminatory factors such as skills, experience, and geographic location and is just one part of our total compensation and benefits package. Certain roles are also eligible for additional rewards, including merit increases and annual bonuses.

Our benefits package for this role includes stock options, flexible paid time off, monthly three-day weekends, 14 weeks of fully-paid gender-neutral parental leave, fertility and adoption assistance, mental health counseling, 401(k) retirement plan, and rich health insurance offerings—including medical, dental, vision and life and disability insurance.

SingleStore’s base salary range for this role, if based in California, Colorado, Washington, or New York City, is: $92,000 - $152,000 USD per year.