Ms Sql Database Developer

• Database Design & Development:
  
• Design, develop, and optimize database structures, tables, views, stored procedures, and functions in MS SQL Server.
• Ensure data integrity, performance tuning, and security of database systems.
• Collaborate with development teams to design and implement database schemas based on application needs.
• .NET Web API Development:
  
• Develop and maintain RESTful Web APIs using .NET Core MVC.
• Ensure APIs are secure, scalable, and optimized for performance.
• Collaborate with front-end developers and other stakeholders to integrate APIs with applications.
• Data Management & Maintenance:
  
• Perform data migrations, backups, and recovery strategies.
• Monitor and troubleshoot database performance issues, query optimization, and implement best practices for indexing and partitioning.
• Collaboration & Communication:
  
• Work closely with business analysts, project managers, and QA teams to understand requirements and deliver solutions.
• Participate in code reviews, provide constructive feedback, and adhere to development standards and best practices.
• Documentation:
  
• Create and maintain technical documentation for database structures and APIs.

Required Skills and Qualifications:

• 2-3 years of experience in MS SQL Server (2016 or later), including database design, writing complex queries, stored procedures, and performance tuning.
• Strong experience in developing .NET Web APIs (using .NET Core MVC).
• Proficiency in C# and understanding of RESTful API principles.
• Strong experience in Entity Framework for data access.
• Familiarity with SQL Profiler and other database performance monitoring tools.
• Basic understanding of front-end technologies (HTML, JavaScript, etc.) is a plus.
• Strong problem-solving skills, attention to detail, and ability to work independently and in a team environment.

Preferred Qualifications:

• Experience with Azure SQL Database or other cloud-based database solutions.
• Understanding of Agile development methodologies.