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. SL Developer with 57 years of hands- on expertise in performance tuning, optimization of complex SL 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 SL 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 SL 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 SL code quality and maintainability.
Required Skills G ualifications:
- 57 years of strong experience in SL development and query optimization.
- Expertise in tuning complex queries and stored procedures for large-scale datasets.
- Hands-on experience with tools like SL 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 SL Server, PostgreSL, MySL, 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.
