Desired Skills:
Good knowledge in SQL Server 2008, 2008 R2, 2012 and 2014 with hands on Migration experience .
Good understanding of background process functionality.
Create, manage, and maintain tables using appropriate storage settings and create database using the Database Configuration Assistant Backup / Recovery and Performance Tuning
Knowledge of Backup and Recovery options and can carry out Basic recovery under guidance
Good knowledge and hands on experience in tuning the Database at Memory level, able to tweak SQL queries.
Good understanding of the SQL Server architecture and can trouble shoot connectivity issues.
Should have good administrative knowledge of Windows OS.
Should be able to administer and alter security and audit parameters under guidance.
Good working knowledge of SQL Server profiler and Perfmon console and can carry out administrative job.
Familiar with using most of the options available in Profiler
Working knowledge on Clustering, Mirroring and Log shipping Knowledge of SQL Server high availability like Clustering, Log shipping, Mirroring and Replication
Bachelor's degree