with Excellent communication skill as this is overseas projectMandatory: 8+ Relevant (.Net and C#, API, SQL Server) Angular any version (4 Years Relevant)Please find the details below:1. Location : SDSI Office, Gurugram.2. Work Mode : Hybrid3. Indian Shift Timing : 08:30am to 5:30pm4. Joining Date : ASAP5. Preferred Experience Level : 8+yrs6. Project Name : Promotool7. No of Positions : 18. Hiring Manager : Syed SaberBudget - 32 LPASr. DOT NET Developer Angular FrameworkYears Of Experience-: 8 10 Years Of Experience (Sr. Developer)Key AccountabilitiesEnsure optimal performance, availability, and reliability of SQL Server databases.Diagnose and resolve issues related to deadlocks, blocking, query performance, and timeouts.Optimize stored procedures, queries, and functions to improve application performance.Design and implement indexing strategies, review execution plans, and fine-tune queries.Collaborate with development teams working on (C#, .NET Core, EF/EF Core, Angular) to ensure efficient database design and usage.Proactively monitor database health, perform performance tuning, and implement corrective actions.Support database security, backup, and disaster recovery strategies.Provide guidance and best practices on database access, schema design, and query optimization.Must Have Skills8 12 years of experience with Microsoft SQL Server (2016/2019/2022 preferred).Strong expertise in performance tuning, indexing strategies, and execution plan analysis.Proven ability to troubleshoot deadlocks, blocking, and database performance bottlenecks.Deep knowledge of T-SQL, stored procedures, triggers, and query optimization.Experience with SQL Server monitoring tools, DMVs, Extended Events, Profiler.Strong understanding of Entity Framework / EF Core database interactions.Hands-on experience with .NET Core Web APIs from a database integration perspective.Knowledge of database security, backup, and recovery best practices.---Good to Have SkillsExperience with Azure SQL Database, Azure Managed Instances, or other cloud-based SQL solutions.Exposure to CI/CD pipelines for database deployments.Familiarity with Always On Availability Groups, Replication, and other HA/DR solutions.Experience with scripting/automation (PowerShell, SQL Agent jobs, etc.).Knowledge of Angular front-end integration with APIs and database-backed services.
