SQL server DBA

 • 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