• Expertise in managing SQL Server 2005, 2008, 2012, 2014
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
• Experience in Performance Tuning, Query Optimization, using SQL Server monitoring utilities such as Idera SQLdm, BMC Patrol, NewRelic, Spotlight, SQLSentry
• Ability to detect/ troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention
• Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering
• Experience with AlwaysON Availability groups, clustering, replication, log shipping, mirroring and storage replication technologies
• Expert experience in implementing operational automation
• Strong knowledge of indexes, index management, integrity checks, configuration, patching
• Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
• Solid acquaintance with windows server, security delegation, SPNs, storage components
• Working knowledge of Business Intelligence (BI) platforms including SSIS, SSAS and SSRS
• Any skills in open source and/or No SQL databases
• Experience with Cloud database hosting providers AWS EC2, Azure VM and Azure SQL Database
• Excellent written and verbal communications skills are necessary.
• Highly organized, structured, and process oriented.
• Ability to work independently as well as with a team.
• Strong interpersonal skills with a desire to collaborate with internal and external business/technical teams.
Experience: 4-8 Years
Job Location: GGN or Noida Or Bangalore
Shifts: General(12 P.M
to 9P.M.)
Cabs: Yes
Client: Client Hewitt
Budget: For experience range 4-6 years, Max
we can offer is 8.5 LPA
For experience range 6-8 years, Max
we can offer is 13.0 LPA
