Senior SQL Developer

Open Rainbow Ltd; Hyderabad; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A leading IT services company in Hyderabad is seeking a Sr Microsoft SQL Developer to manage and optimize SQL databases. The ideal candidate will have over 5 years of experience, proficiency in SQL and T-SQL, and the ability to work collaboratively in a team. This role offers full-time, on-site employment with responsibilities including database design and performance tuning.

Qualifications

• 5+ years of experience as a Microsoft SQL database developer.
• In-depth knowledge of complex SQL queries, CTEs, joins, functions, and stored procedures.
• Ability to work collaboratively in a team environment.

Responsibilities

• Develop, test, and maintain complex SQL code and scripts.
• Design, implement, and optimize SQL queries for performance.
• Conduct code reviews and ensure best practices in SQL development.

Skills

Microsoft SQL Server development

SQL

T-SQL

Performance tuning

Database design principles

Troubleshooting performance issues

Communication skills

Job description

Established in 2014, Open Rainbow offers a complete life cycle of IT services, including Design, Deploy, Test, Operate, Maintain, and Improve. We can join your project at any stage of your IT journey to ensure optimal outcomes. Renowned for flexibility without compromising quality, our team consistently delivers high-standard services and solutions. When you engage with Open Rainbow, you are partnering with a responsible and responsive organization.

Role Description

This is a full-time on-site role for a Sr Microsoft SQL Developer located in Hyderabad. The Sr Microsoft SQL Developer will be responsible for developing and managing SQL databases, designing database solutions. The role also involves data modeling, optimizing database performance, and ensuring data integrity. The developer will work closely with stakeholders to understand data requirements and deliver analytical solutions.

Responsibilities

• Develop, test, and maintain complex SQL code and scripts for database management and business applications.
• Design, implement, and optimize SQL queries, functions, stored procedures, triggers, and views to enhance performance and functionality.
• Perform advanced performance tuning and query optimization for large-scale databases to ensure high efficiency and speed.
• Write and maintain complex joins, Common Table Expressions (CTEs), and table-valued functions to support business logic and reporting.
• Work with indexes, execution plans, and database profiling tools to identify and resolve performance bottlenecks.
• Collaborate with development teams to understand application requirements and provide optimized database solutions.
• Assist in designing and maintaining data models, schemas, and normalization of data across the SQL Server environment.
• Conduct code reviews and ensure adherence to best practices for SQL development and performance optimization.
• Provide support and troubleshooting for database-related issues in production and pre-production environments.
• Implement security measures for database access, integrity, and confidentiality.
• Document database architectures, procedures, and methodologies for consistency across projects.
• Stay updated with industry trends and best practices related to SQL Server development and performance optimization.
• Mentor and guide junior developers in SQL best practices, code writing, and performance tuning.

Requirements

• Proven experience in Microsoft SQL Server development, including SQL, T-SQL, and performance optimization techniques.
• 5+ years primarily as a MS SQL database developer.
• In-depth knowledge of writing and optimizing complex SQL queries, including CTEs, joins, functions, and stored procedures.
• Strong proficiency in performance tuning techniques for high-volume databases.
• Solid understanding of database design principles, normalization, and optimization.
• Ability to troubleshoot and resolve performance issues using query analysis and execution plans.
• Excellent communication skills and ability to work collaboratively in a team environment.

Seniority level

Mid-Senior level

Employment type

Full-time

Job function

Information Technology

Industries

IT Services and IT Consulting

Referrals increase your chances of interviewing at Open Rainbow Ltd by 2x