About the role
Location :- Hyderabad, 1.00 PM to 10.00 PM (Mon to Fri) – Work from Office
Mandatory Skills:
1. Strong Proficiency with T-SQL.
2. Experience with MS SQL Server relational database.
3. Experience in writing T-SQL queries, Custom Stored Procedures, Indexes, Functions and
Triggers as per the client requirements.
4. Good Knowledge and working experience in Performance Tuning.
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 Perform on 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