Job Description:
· 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.