MS Sql DBA

MS SQL DBA

Roles & Responsibilities:

• 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 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, and indexing

  by applying industry best practices/standards.
• Define

  Server Health Policies

  like Temp DB configuration, and analyze server configuration based on user base, CPU utilization, etc.
• Execute

  SQL software/patch upgrades

  and technical initiatives.
• Perform

  resource (CPU, memory, IO & network) monitoring and management

  .
• Handle Ad-hoc requests from the business for DM and reporting extraction based on request type.
• Define

  DB backup and restore strategy and archiving

  .
• Manage documentation on installation, server build, migration, and infrastructure dependency setting/configuration.
• Manage access based on Role and Responsibility (RnR) and participate in Audits for Access management.
• Create and periodically track

  DB maintenance plans

  for Backup, Update Statistics, Indexing, and DBCC integrity.

Skills Required:

• Expertise as a

  Microsoft SQL DBA

  .
• Strong knowledge of designing and optimizing stored procedures and queries.
• Proficiency in continuous performance monitoring and analysis.
• Ability to conduct in-depth analysis of server configurations.
• Experience in enhancing security measures for data privacy.
• Expertise in addressing issues related to

  DB configuration, server configuration, partitioning, and indexing

  .
• Skill in defining Server Health Policies and managing CPU utilization.
• Experience with

  SQL software/patch upgrades and technical initiatives

  .
• Strong knowledge of

  resource monitoring and management

  .
• Ability to define

  DB backup and restore strategy and archiving

  .
• Proficiency in documentation management for installation, server build, migration, and infrastructure.
• Experience with access management and participation in audits.
• Strong skills in creating and tracking

  DB maintenance plans

  .

QUALIFICATION:

• Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent practical experience.