At NationsBenefits, we are leading the transformation of the insurance industry by developing innovative benefits management solutions. We focus on modernizing complex back-office systems to create scalable, secure, and high-performing platforms that streamline operations for our clients. As part of our strategic growth, we are focused on platform modernization — transitioning legacy systems to modern, cloud-native architectures that support the scalability, reliability, and high performance of core back- office functions in the insurance domain.
We are seeking a highly skilled and experienced Sr. SǪL Developer with 5–7 years of hands- on expertise in performance tuning, optimization of complex SǪL queries and stored procedures, and advanced database architecture. The ideal candidate will play a key role in enhancing the performance, scalability, and reliability of our data systems by leveraging advanced database optimization techniques and collaborating with cross-functional teams.
Key Responsibilities:- Design, develop, and optimize complex SǪL queries and stored procedures for high performance and scalability.
- Conduct performance tuning and troubleshoot slow-running queries using profiling and monitoring tools.
- Analyze and improve database architecture, including indexing, partitioning, and sharding strategies.
- Establish and enforce best practices for SǪL development, data retrieval, and database design.
- Work closely with data architects, backend engineers, and DevOps to ensure optimal database reliability and performance.
- Monitor and evaluate database performance metrics, proactively identifying and addressing potential issues.
- Create and maintain technical documentation for optimized queries, stored procedures, and overall database design.
- Participate in code reviews and performance assessments to ensure SǪL code quality and maintainability.
- 5–7 years of strong experience in SǪL development and query optimization.
- Expertise in tuning complex queries and stored procedures for large-scale datasets.
- Hands-on experience with tools like SǪL Profiler, Extended Events, Ǫuery Store, or similar performance monitoring utilities.
- Deep knowledge of indexing strategies, data partitioning, and sharding techniques.
- Strong understanding of execution plans, index types (clustered/non-clustered), and join operations.
- Proficient in relational data modeling and normalization principles.
- Experience with RDBMS platforms such as Microsoft SǪL Server, PostgreSǪL, MySǪL, or Oracle.
- Capability to analyze database metrics and build custom performance dashboards.
- Familiarity with a programming language such as C# or .NET is a plus.
- Exposure to Python or Shell scripting for automation and data processing is preferred.
- Experience working with high-throughput transactional systems or large-scale data warehouses is advantageous.
- Excellent problem-solving and analytical skills.
- Strong communication and documentation abilities.
- Ability to work independently and collaboratively across cross-functional teams.
- Bachelor's degree or higher in Computer Science, Information Technology, or a related field.
Similar Jobs
What We Do
NationsBenefits® is a leading supplemental benefits company providing managed care organizations with innovative healthcare solutions helping to promote independence, health, and well-being for more than 20 million members across the U.S.
When the company was founded in 2015 by Glenn Parker, M.D., we set out to disrupt the healthcare industry. In 2020, we rebranded to NationsBenefits to expand the company’s core offering and broaden the scope of our clinically focused services.
Today, we surpass traditional benefit management programs by helping our health plan partners drive growth, improve outcomes, reduce costs, and delight members. Our best-in-class service model engages members in meaningful and measurable ways with technology-based solutions tailored to the unique needs of each population.
