SQL DBA-CGEMJP00348806

Role: SQL DBA

Location: Fort Mill USA

JD

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)?