Sr. SQL Developer
Sr. SQL Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
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. 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# 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.
Required Experience:
Senior IC
Employment Type
Full-Time
