Posted:2 days ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

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.

Mock Interview

Practice Video Interview with JobPe AI

Start DevOps Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

RecommendedJobs for You

Hyderabad, Telangana, India

Hyderabad, Telangana, India