Lead SQL Database Engineer

Company 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