Full Time

Senior Software Engineer (Data) - Query Optimization, Schema Design

Tenable
$120,000 - $160,000* / year (about $58–$77 an hour)

Job Description

This job was posted over 30 days ago, so it has most likely closed. See newer jobs like it.

Written by AI from the job title and company, not by Tenable, so some details may not match this job. The employer's own page has the real description.

Overview

The Senior Software Engineer (Data) - Query Optimization, Schema Design at Tenable plays a pivotal role in enhancing the efficiency and performance of data queries and optimizing data schemas for our advanced analytical needs. This position involves collaborating with cross-functional teams to identify data-related challenges, designing scalable database structures, and implementing optimization techniques that result in high-performance data retrieval and manipulation. The ideal candidate will possess strong analytical skills, a deep understanding of database management systems, and a commitment to delivering outstanding solutions that contribute to the company’s strategic objectives.



Job Responsibilities

  • Design and optimize data schemas for enhanced query performance and data organization.
  • Analyze and improve existing SQL queries and database performance.
  • Collaborate with data scientists and engineers to understand their data needs and provide actionable solutions.
  • Implement best practices for data storage, indexing, and retrieval.
  • Conduct performance tuning and benchmarking activities to ensure optimal system efficiency.
  • Develop and maintain comprehensive documentation of schema designs and optimization strategies.
  • Participate in code reviews and provide mentorship to junior engineers.


Qualifications

  • Bachelor’s degree in Computer Science, Software Engineering, or a related field.
  • Minimum of 5 years of experience in software engineering with a focus on database optimization.
  • Strong proficiency in SQL and experience with both relational and NoSQL database systems.
  • Hands-on experience with performance tuning and optimization of SQL queries.
  • In-depth understanding of database design principles and data modeling.
  • Proficiency in at least one programming language such as Python, Java, or C#.
  • Solid experience with data warehousing and ETL processes.


Technologies & Tools

This position utilizes a variety of technologies and tools that are essential for effective query optimization and schema design. Proficient experience with relational databases such as PostgreSQL and MySQL, as well as NoSQL alternatives like MongoDB, is expected. Familiarity with cloud services such as AWS and Azure is beneficial, alongside skills in programming languages including Python and Java for scripting and automation tasks. Additionally, knowledge of data warehousing technologies and ETL tools will aid in delivering high-quality solutions.



Ideal Candidates

The ideal candidate for the Senior Software Engineer (Data) - Query Optimization, Schema Design role will embody a blend of technical expertise and collaborative spirit. They should possess strong problem-solving abilities, an analytical mindset, and an unwavering attention to detail. Effective communication skills are essential for articulating complex ideas to diverse teams. Furthermore, a proactive approach to challenges and a commitment to continuously improving performance and efficiency will mark a standout candidate. A genuine enthusiasm for data and its potential to drive business success is highly desirable.

Free tools for your search, no account needed: a LinkedIn headline writer, a resume checker and more. Free tools →

View Similar Jobs

Matches Jobs

Similar jobs which you may be interested in. Typically using your existing skillset.