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
As a Senior Software Engineer (Data) specializing in Query Optimization and Schema Design at Tenable, you will be an integral part of a dynamic team responsible for enhancing data performance and usability within our systems. Your expertise in optimizing complex queries and designing efficient database schemas will help in improving the data architecture, thereby significantly impacting the ability to analyze and leverage vast data sets. You will engage in various stages of the development lifecycle, collaborating closely with cross-functional teams to ensure the delivery of high-quality software solutions that align with both user needs and business goals.
Job Responsibilities
- Design and implement optimized query strategies to enhance the performance of database systems.
- Develop and maintain database schemas that support efficient data retrieval and storage.
- Collaborate with data scientists and other stakeholders to understand data requirements and translate them into technical solutions.
- Analyze existing query performance metrics and provide recommendations for optimization.
- Conduct code reviews and provide mentorship to junior engineers regarding best practices in database management and query optimization.
- Continuously monitor system performance and troubleshoot any issues related to data access and retrieval.
- Contribute to the development of Data Engineering best practices and documentation.
Qualifications
- Bachelor's degree in Computer Science, Engineering, or a related field; Master's degree preferred.
- Minimum of 5 years of experience in software engineering with a focus on database development and optimization.
- Proficiency in SQL and experience with various database systems (e.g., PostgreSQL, MySQL, or Oracle).
- In-depth knowledge of schema design principles, normalization, and denormalization techniques.
- Familiarity with data warehousing and ETL processes.
- Experience in performance tuning and optimization of SQL queries in production environments.
- Strong analytical and problem-solving skills, with a keen attention to detail.
Technologies & Tools
In this role, you will utilize a variety of technologies and tools including, but not limited to, SQL databases such as PostgreSQL and MySQL, data modeling tools, performance monitoring tools, and version control systems. Exposure to cloud technologies, such as AWS or Azure, and data analytics platforms will also be advantageous. Familiarity with programming languages such as Python or Java can enhance your contributions to automation and integration efforts.
Ideal Candidates
The ideal candidate for this position will possess a combination of technical acumen and collaborative skills, demonstrating a strong ability to solve complex problems efficiently. Candidates should be proactive, detail-oriented, and passionate about data optimization and system enhancement. An inclination towards continuous learning, adaptability to new technologies, and a commitment to team success are essential. The ability to communicate effectively with both technical and non-technical stakeholders will further enable you to thrive in this role at Tenable.
A full-time year is 2,080 hours: $26 an hour is $54,080 a year before taxes, and $52,000 a year is $25.00 an hour. Pay calculator →
View Similar Jobs
Similar jobs which you may be interested in. Typically using your existing skillset.