.Net lead/ Architech

Must have-

Need excellent experience in both .Net and SQL Database

AI experience will be preferred.

Need excellent experience in .NET CORE 6+ and excellent experience in SQL Database with C# SQL and MVC frameworks. Web API.

JD-

• Design, develop, and maintain .NET applications using .NET CORE 6+, C# and MVC frameworks. (MUST have)
• Develop and optimize SQL Server databases, including stored procedures, functions, and complex queries. (Must have)
• Collaborate with cross-functional teams to gather and analyze business requirements.
• 10+ years of experience in .NET development using C#.
• Strong proficiency in SQL Server, including database design and optimization.
• Experience with , MVC, Web API, and Entity Framework.
• Solid understanding of object-oriented programming and design patterns.
• Strong understanding of Agile Methodology.
• Experience with using Jira and confluence.
• Experience with version control systems (e.g., Git).
• Excellent problem-solving and analytical skills.
• Strong communication and teamwork abilities.

SQL Roles and Responsibilities

Key Responsibilities:

• Database Design and Development:

1. Oversee the design, development, and implementation of robust and scalable SQL database systems.

1. Collaborate with cross-functional teams to gather requirements and translate them into effective database solutions.

1. Design and optimize database schemas, stored procedures, functions, and triggers.

• Database Performance and Optimization:

1. Monitor, manage, and optimize database performance, including query tuning, indexing strategies, and resource usage.

1. Identify and resolve performance bottlenecks and ensure high availability and reliability of databases.

1. Implement and manage database replication, clustering, and load balancing for scalability.

• Troubleshooting and Support:

1. Investigate and resolve production database issues in real-time, providing end-to-end problem resolution.

1. Provide support and guidance to the development team on database-related challenges.

1. Refine and automate regular processes to improve efficiency and reduce manual effort.

Required Skills and Qualifications:

• Extensive experience in SQL database design, development, and administration.
• Proficiency in SQL Server or other relational database management systems (e.g., MySQL, Oracle).
• Strong understanding of database architecture, performance tuning, and security best practices.
• Excellent analytical and problem-solving skills.
• Strong leadership, communication, and interpersonal skills.
• Ability to work independently and as part of a team, managing multiple priorities effectively.