Description

Experience in T-SQL query analysis and optimization recommendations

              Analyzing execution plans and pinning the optimal using query store 

              Index statistics update and Index rebuild operations

              Partitioning functions for tables and Indexes

              Database blocking and impact analysis

              Stored procedure/Adhoc SQL performance improvement based upon execution analysis and patterns.

              Experience working in App-Dev environment

Database Administration

              Install, configure, and maintain Microsoft SQL Server (2016/2017/2019/2022).

              Apply patches, service packs,  CU

            Database and volume space management 

             Troubleshooting skills for Database performance, Availability and scalability

Monitor and maintain SQL Server databases  

              Always On Availability Groups

              Replication

             CPU/RAM/Disk Space

             TempDB allocations and performance evaluation

User roles, permissions, and ensure database security.

SSIS jobs and SQL agent jobs administration

Good to have below tools Operational knowledge:

SolarWinds

DPA

Dynatrace ( API-DB call tracing)

Key Skills

Education

Bachelor's degree