Key Skills: Ms Sql, Azure
Roles and Responsibilities:
- Design, develop, and maintain complex MS SQL Server databases with a focus on high availability, performance, and data integrity
- Identify and resolve performance bottlenecks, implement tuning strategies, and monitor query execution plans
- Collaborate with cross-functional teams to define database requirements, align with application features, and support new development
- Develop backend components using C#.NET and ensure robust integration with SQL databases
- Enhance and optimize existing stored procedures, functions, and triggers for performance and scalability
- Conduct database unit testing using tools like tSQLt, and manage schema versioning using tools like Flyway
- Participate in code reviews, ensuring adherence to best practices in SQL development and database design
- Work with RESTful APIs and web services to enable seamless data flow across application layers
- Stay current with evolving database technologies and industry trends to drive innovation and efficiency
Skills Required:
Must-Have:
- Strong expertise in MS SQL Server database development and optimization
- Solid experience in C#.NET backend programming
- Proficiency in writing complex T-SQL queries, stored procedures, and performance tuning
- Experience with unit testing (tSQLt) and database migration tools (Flyway)
Nice-to-Have:
- Exposure to Microsoft Azure and cloud-based database services
- Experience with RESTful APIs, JSON/XML data handling
- Familiarity with Agile methodologies and DevOps tools
Education: Bachelor's or Master's degree in Engineering (BE/BTech) or Computer Applications (MCA)