SQL DBA

SQL Server DBA

Key Responsibilities

• Database Management

  : Perform RDBMS software installation, database server builds, patch application, upgrades, configuration, and troubleshooting for SQL Server 2008R2/2012/2014/2016.

• Disaster Recovery & High Availability

  : Design and implement

  Disaster Recovery plans

  by configuring and managing

  AlwaysOn Availability Groups, Clustering, Log-shipping, Mirroring, and Replication (Snapshot and Transactional)

  . Implement

  High Availability in SQL 2012/2016 by configuring AlwaysOn Availability groups across Windows Server Failover Clustering

  .

• Security

  : Possess expertise in

  database encryption

  .

• Maintenance & Optimization

  : Perform regular database

  Back Up, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing indexes, Defrag Tables

  , and manage

  Database Maintenance Plans

  .

• Monitoring & Alerting

  : Monitor SQL Server instances, configure and enable alerts using tools like Quest Foglight/AppDynamics or other 3rd party monitoring tools.

• Performance Tuning

  : Conduct

  query optimization and performance tuning

  using tools such as

  SQL Profiler, Execution Plan, Performance Monitor, and DBCC Commands

  .

• Automation

  : Utilize

  PowerShell or SSIS to automate day-to-day activities

  and troubleshoot/enhance existing scripts.

• Troubleshooting

  : Respond to and troubleshoot database-related problems reported by customers, including issues with Log Shipping, DB Replication, and Always On.

• Documentation & Knowledge Sharing

  : Prepare Knowledge Articles and share best practices with the team.

Required Skills and Experience

• Expertise in

  RDBMS S/W installation, database server builds, applying patches, upgrading, configuring, troubleshooting of SQL SERVER 2008R2/2012/2014/2016

  .
• Expertise in

  Disaster Recovery plans

  by configuring

  AlwaysOn, Clustering, Log-shipping, Mirroring and Replication (Snapshot and Transactional)

  .
• Proficiency in implementing

  High Availability in SQL 2012/2016 by configuring AlwaysOn Availability groups across Windows Server Failover Clustering

  .
• Expertise knowledge in

  database encryption

  .
• Expertise in

  database Back Up, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing indexes, Defrag Tables, Replication, Linked Servers and Database Maintenance Plan

  .
• Experience in

  Monitoring Instances, Configuring and Enabling alerts using Quest Foglight/AppDynamics

  or any other 3rd party tool.
• Experience in

  query optimization and performance tuning

  .
• Experience in using

  SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands

  .
• Experience in

  PowerShell or SSIS to automate day-to-day activities and troubleshoot/enhance existing scripts

  .
• Ability to monitor/troubleshoot Log shipping /DB Replication/Always ON.
• Capable of responding to and troubleshooting database-related problems reported by customers.
• Ability to automate routine tasks.
• Experience in preparing Knowledge articles and sharing with the team.

Mandatory Skills

• SQL DBA