Write complex SQL queries from scratch, including development and testing scripts.
Design and create database objects such as tables, views, triggers, stored procedures, and functions with strong proficiency in MS SQL Server.
Develop efficient and scalable database structures including tables, views, indexes, and user-defined functions.
Optimize SQL queries and database performance through indexing and query tuning techniques.
Write and maintain test cases to support internal testing and ensure data accuracy and functionality.
Requirements
Education & Certification
UG: B.Tech/B.E. in Any Specialization
PG: M.Tech/M.E. in Any Specialization, MCA/M.Sc in Any Specialization
SQL Certification (optional)
Skills
Solid understanding of Database Architecture and Normalization principles
Strong experience with DDL (Data Definition Language) and DML (Data Manipulation Language)
Expert-level proficiency in T-SQL development
Proven track record in database performance tuning, query optimization, and troubleshooting