Mahindra satyam

5-8yrs  experience,  who worked in similar roles like  as  below  .

Area

Description

Expected Expertise

SQL

Monitoring

Good

Performance   tuning – DB indexing, SQL Counters, Locking, DBCCS, DMVs commands etc.

High

SSIS, SSAS,   SSRS (+ Basic Administration)

Good

High   availability concepts (mirroring, replication, log shipping)

Good

Clustering

High

Backup &   restore strategies

High

IIS

Installing   certificates in IIS.

Good

Troubleshooting   “unable to browse website” kind of issue

Good

Patching on a   cluster. (nice to have)

Good

Admin

Moving services   or applications from one node to another in windows cluster.

High

Restarting a   service from a windows cluster.

High

Patching on a   cluster. (nice to have)

Basic