Must have SQL Basics such as Key constraints, Normalization, Joins, Loops, System Functions (window functions, Date, String, IsNull, IsDate, GetDate, etc.,), Sub queries, Co-related, Inline, Temp Tables, Table Variables, CTEs, operators
Should have SQL Advance such as Case statement, Cursors, Triggers, Stored Procedure Creation, Views, User Defined Functions, Logging, Magic Tables, Index, Transactions, Locks, Error handling
Strong proficiency in Debugging and Performance for SQL Profiler, Actual and Estimated Execution Plan, query optimization, and understanding of backend functions.
Proficient in writing SQL Server stored procedures, functions, and complex queries.
Experience in writing code following best practices, conducting unit testing, and performing regression testing
Good to have Experience in creating, managing, and maintaining tables with appropriate storage settings, and using the Database Configuration Assistant for database creation, backup, recovery, and performance tuning.
Skilled in database tuning at the memory level and optimizing SQL queries.
Proficient in using SQL Server Profiler, with a deep understanding of its options.