SQL with Dot Net Developer

Key Responsibilities:

• .NET Application Development:
• Design, develop, and maintain web and desktop applications using C#, ASP.NET, and other .NET technologies.
• Implement new features, enhancements, and bug fixes based on business requirements.
• Ensure the quality and maintainability of the codebase by following best practices and standards.
• SQL Database Design & Optimization:
• Design and develop SQL queries, stored procedures, and triggers to interact with databases efficiently.
• Optimize complex queries for performance, scalability, and security.
• Ensure data integrity and consistency through proper database design and validation.
• Work on database migrations, schema changes, and data integrations.
• API Development & Integration:
• Develop and integrate RESTful APIs and web services in .NET for data exchange between systems.
• Ensure smooth integration between frontend and backend components, as well as with external systems.
• Database Management:
• Implement database security measures, backup strategies, and disaster recovery procedures.
• Monitor, analyze, and optimize database performance, ensuring high availability and minimal downtime.
• Troubleshoot and resolve database issues, such as slow queries or data integrity problems.
• Collaborate with Cross-Functional Teams:
• Work closely with frontend developers, business analysts, and project managers to define project requirements and deliver high-quality solutions.
• Assist in gathering business requirements, translating them into technical solutions, and testing functionality.
• Code Reviews & Best Practices:
• Participate in peer code reviews to ensure adherence to coding standards and best practices.
• Write and maintain technical documentation related to system designs, workflows, and database schemas.
• Testing & Debugging:
• Perform unit testing, debugging, and troubleshooting to ensure code quality and system performance.
• Write automated tests to improve software quality and reduce manual testing.

Qualifications & Skills:

• Technical Skills:
• Strong experience in C#, ASP.NET MVC, .NET Core, or similar .NET technologies.
• Solid knowledge of SQL Server (T-SQL, stored procedures, functions, triggers).
• Hands-on experience in database design, performance tuning, and query optimization.
• Familiarity with RESTful API design and integration.
• Experience with Entity Framework and LINQ is a plus.
• Knowledge of JavaScript, HTML5, and CSS is an advantage.
• Experience:
• Minimum of 2-4 years of experience in developing applications with .NET and SQL Server.
• Proven experience in SQL query optimization, data modeling, and database administration.
• Familiarity with version control systems such as Git or SVN.
• Problem-Solving Skills:
• Strong analytical and debugging skills, with the ability to troubleshoot complex issues.
• Ability to think creatively and work independently to solve technical problems.
• Soft Skills:
• Excellent communication and interpersonal skills.
• Ability to work collaboratively in a team environment.
• Strong time-management and organizational skills, with the ability to meet deadlines.

Desirable:

• Experience with Cloud Technologies (e.g., Azure, AWS).
• Familiarity with Microservices Architecture or Docker.
• Knowledge of Agile or Scrum methodologies.
• Bachelor's degree in Computer Science, Information Technology, or a related field.