Description
Hi, We are looking for an experienced MS SQL Server Developer, Azure SQL to design, develop, optimize, and maintain database solutions that support business-critical applications. PLEASE NO FULL STACK .NET DEVELOPERS - THIS IS PURE MS SQL DEVELOPER ROLE. Experience - 6 to 8 years Strong English skill to work with Australian/Indian teams Working timezone - Indian timezone [usually 9.30 AM IST to 6.30 PM IST. 40 hours/Week [full time] - currently 4 months duration but can be extended based on client need and performance. Responsibilities Develop and maintain T-SQL stored procedures, functions, views, triggers, and scripts. Design and optimize complex SQL queries for high-performance applications. Analyze execution plans and resolve query performance issues. Create and maintain indexes and database structures for optimal performance. Investigate and resolve database-related production issues. Monitor and troubleshoot locking, blocking, and deadlock scenarios. Design scalable database schemas and data models. Develop data migration, import/export, and ETL processes. [not mandatory but good to have] Work closely with application developers to ensure efficient database interaction. Maintain database security, integrity, and availability. Participate in code reviews and database architecture discussions. Experience with: Stored Procedures User Defined Functions (UDFs) Triggers Views Dynamic SQL CTEs Window Functions Temp Tables and Table Variables Strong understanding of: Query Exec