SQL DBA

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 Max Vendor Rate in Per Day INR 8,000/day + tax Work Location given in ECMS ID Hyderabad BG Check (Pre OR post onboarding) Post onboarding BGV.

Show more Show less