SQL DBA

Total Yrs

of Experience 6 to 8 Years Relevant Yrs

of experience 7 Years Detailed JD (Roles and Responsibilities) SQL DBA-

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

Expertise in Disaster Recovery plans by configuring AlwaysOn, Clustering, Log-shipping, Mirroring and Replication (Snapshot and Transactional)

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

Monitoring Instances, Configuring and Enabling alerts using Quest Foglight/App Dynamics or any other 3rd part 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 the day to day activities and troubleshoot/enhance the existing scripts

Monitoring/Troubleshooting Log shipping /DB Replication/Always ON

Respond and Troubleshoot database related problems reported by customers

Automate the routine tasks

Preparing Knowledge articles and sharing with the team on day to day activities

Mandatory skills SQL DBA