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 every day. 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 SingeStore 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

  • Previous experience as a DBA or a career of hands-on database work.
  • Deep expertise with relational/distributed database implementation and 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.

 


SingleStore is one platform for all data, built so you can engage with insight in every moment. Trusted by industry leaders, SingleStore enables enterprises to adapt to change as it happens, embrace diverse data with ease, and accelerate the pace of innovation. SingleStore is venture-backed and headquartered in San Francisco with offices in Portland, Seattle, Boston, Bangalore, London, Lisbon, and Kyiv. Defining the future starts with The Database of Now™.

Consistent with our commitment to diversity & inclusion, we value individuals with the ability to work on diverse teams and with a diverse range of people.

To all recruitment agencies: SingleStore does not accept agency resumes. Please do not forward resumes to SingleStore employees. SingleStore is not responsible for any fees related to unsolicited resumes and will not pay fees to any third-party agency or company that does not have a signed agreement with the Company.

#remoteli #liremote

Apply for this Job

* Required
  
  


U.S. Equal Opportunity Employment Information (Completion is voluntary)

Individuals seeking employment at SingleStore are considered without regards to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation. You are being given the opportunity to provide the following information in order to help us comply with federal and state Equal Employment Opportunity/Affirmative Action record keeping, reporting, and other legal requirements.

Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.


Form CC-305

OMB Control Number 1250-0005

Expires 05/31/2023

Voluntary Self-Identification of Disability

Why are you being asked to complete this form?

We are a federal contractor or subcontractor required by law to provide equal employment opportunity to qualified people with disabilities. We are also required to measure our progress toward having at least 7% of our workforce be individuals with disabilities. To do this, we must ask applicants and employees if they have a disability or have ever had a disability. Because a person may become disabled at any time, we ask all of our employees to update their information at least every five years.

Identifying yourself as an individual with a disability is voluntary, and we hope that you will choose to do so. Your answer will be maintained confidentially and not be seen by selecting officials or anyone else involved in making personnel decisions. Completing the form will not negatively impact you in any way, regardless of whether you have self-identified in the past. For more information about this form or the equal employment obligations of federal contractors under Section 503 of the Rehabilitation Act, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Disabilities include, but are not limited to:

  • Autism
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, or HIV/AIDS
  • Blind or low vision
  • Cancer
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or hard of hearing
  • Depression or anxiety
  • Diabetes
  • Epilepsy
  • Gastrointestinal disorders, for example, Crohn's Disease, or irritable bowel syndrome
  • Intellectual disability
  • Missing limbs or partially missing limbs
  • Nervous system condition for example, migraine headaches, Parkinson’s disease, or Multiple sclerosis (MS)
  • Psychiatric condition, for example, bipolar disorder, schizophrenia, PTSD, or major depression

1Section 503 of the Rehabilitation Act of 1973, as amended. For more information about this form or the equal employment obligations of Federal contractors, visit the U.S. Department of Labor's Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.