Job Description :
MS SQL DBA
Location: Hartford, CT

Hire Type: Fulltime

Client: COGNIZANT



5 to 7 years of experience in below
Knowledge in Database Installation, Administration in SQL Server (2008R2,2012,2014,2016)
Upgrade and migration of SQL databases;
Client facing, coordination and mentoring team.
Experience in troubleshooting and resolving database installation issues, integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
Strong Knowledge/experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
Ability to detect and 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, Database mirroring, Replication and AlwaysON.
Expert experience in implementing operational automation.
Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
Knowledge of SQL Server tools (Foglight, Profiler, DTA, SSMS, SSCM, PerfMon, DMVs, SSRS, SSAS)
Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc )
Deploy and support SSIS and DTS packages
Strong experience database upgrades from one SQL version to another SQL version
Database engineering support for Line of Business applications,
Support Application Development Requests for Database/Schema Refresh in SDLC
Troubleshoot application performance issues and recommend changes for the database