Proficient in using Microsoft SQL Server for relational database management, querying, and reporting

Skilled in writing T-SQL (Transact-SQL) queries for data retrieval, filtering, sorting, and transformation

Experienced in:

• SELECT, JOIN (INNER, LEFT, RIGHT, FULL), WHERE, GROUP BY, HAVING, and ORDER BY

• Using aggregate functions like COUNT(), SUM(), AVG(), MAX(), and MIN()

Strong understanding of database design principles:

• Creating and normalizing tables

• Defining primary keys, foreign keys, and constraints

Able to create and manage stored procedures, views, and user-defined functions

Skilled in writing subqueries and optimizing queries for performance

Knowledge of indexes, triggers, and transactions

Capable of data import/export, using SQL Server Management Studio (SSMS)

Experience with backups, restoration, and security management (users, roles, permissions)

Familiar with reporting tools and integration with Power BI for dashboarding