- Senior
- Optionales Büro in Hyderabad
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.
Required Skills G Ǫualifications:
- 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.
