SQL Server Developer

About Us :

Evince Development Pvt. Ltd. (EvinceDev) is a CMMI 3-Level leading IT service company that delivers innovative solutions to clients worldwide.

With a commitment to excellence and a dynamic team of professionals, we aim to exceed client expectations and drive success through cutting-edge technology.

Eligibility : 4 - 5 years experience.

Role Description :

• Design, develop, and maintain robust relational databases using Microsoft SQL Server (Structured Query Language Server), ensuring data integrity and optimal performance for business applications.
• Collaborate with stakeholders, developers, analysts, and data engineers to gather requirements, analyze business needs, and deliver scalable SQL-based (Structured Query Language-based) solutions.
• Write and optimize complex T-SQL (Transact-SQL) queries, stored procedures, functions, and triggers to support application and reporting requirements.
• Perform performance tuning, query optimization, and database profiling to ensure high-availability and responsiveness.
• Implement database security protocols, including access control, encryption, and compliance with data protection regulations.
• Provide troubleshooting and support for existing SQL Server databases and data-driven applications, conducting root cause analysis and resolution.
• Participate in Agile development processes, including sprint planning, stand-ups, and solution reviews.
• Document database designs, data flows, and technical specifications for ongoing reference and compliance needs.
• Stay updated with the latest SQL Server features, security practices, and cloud database trends such as Azure SQL Database (Microsofts cloud-based SQL Server) or AWS RDS (Amazon Web Services Relational Database Service).
• Strong development experience with MS SQL Server 2017 or above, including database design, implementation, and maintenance.
• Advanced expertise in writing and tuning T-SQL (Transact-SQL) queries, complex joins, CTEs (Common Table Expressions), window functions, and dynamic SQL (Structured Query Language).
• Capable of performance tuning : query optimization, indexing, partitioning, and execution plan analysis.
• Proficient in analyzing, troubleshooting, and resolving database-related issues efficiently.
• Familiarity with database security measures, data encryption, and user access management.
• Good knowledge of backups, recovery models, and database migration techniques.

(ref : hirist.tech)