Sr SQL Developer

About NationsBenefits:

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.
• Bachelors degree or higher in Computer Science, Information Technology, or a related field.