MS Sql DBA

Job Description

Job Description* Total Yrs. of Experience* 5 to 10 years Relevant Yrs. of experience* 5 to 10 years Detailed JD *(Roles and Responsibilities) Microsoft SQL DBA : Design and provide inputs to optimize stored procedures and queries based on system performance to reduce server load Monitor performance continuously and take immediate measures based on the analysis of current system behavior Conduct In-depth Analysis of the current server configuration and identify requirements to improve performance, particularly in database settings. Enhance security measures to ensure data privacy and information security Address issues related to DB configuration, server configuration, partitioning, indexing by applying industry best practices/standards Define Server Health Policies like Temp DB configuration, analyse the server configuration based on user base, CPU utilization, etc SQL software/patch upgrades and technical initiatives Resource (CPU , memory , IO & network) monitoring and management Handling Ad-hoc request from business for DM and reporting extraction based on Request type Define DB backup and restore strategy and archiving ; Documentation Management on installation, server build , migration, infra dependency setting/configuration Access management based on the RnR and participation in Audit for Access mgmt DB maintenance plan creation and periodic tracking on Backup, Update Statistic, Indexing , DBCC integrity Mandatory skills* Microsoft SQL DBA. Details above in JD Desired skills*