• Cognizant Technology Solutions
  • Englewood, CO, USA
  • Nov 09, 2020
[Information Technology]

Job Description

SQL DBAWe have aSQL DBA position.The position is Permanent opportunity. Selected candidates must be willing tojoin at a short notice.Qualified candidates should be willing to workat Englewood CO.Note: Must belegally authorized to work in United States without the need of employersponsorship, now or at ay time in the futureMust Have: Primaary Skill SQL DBA, Secondary Skill - AWSJob Description:Strong experiencein Database Administration in SQL Server ( 2012,2014 and 2016 )Experience introubleshooting and resolving database integrity issues, performance issues,blocking and deadlocking issues, replication issues, log shipping issues,connectivity issues, security issues etc.Experience inPerformance Tuning, Query Optimization, using Performance Monitor, SQL Profilerand other related monitoring and troubleshooting tools.Ability to detectand troubleshoot SQL Server related CPU, memory, I/O, disk space and otherresource contention.Strong knowledgeof backups, restores, recovery models, database shrink operations, DBCCcommands, Clustering, Database mirroring, Replication, Always ON.Expert experiencein implementing operational automation.Participate inon-call rotation (1 week in 7)Strong knowledgeof how indexes, index management, integrity checks, Database Encryption,configuration, patching. How statistics work, how indexes are stored, how theycan be created and managed effectively.Knowledge of SQLServer tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)SQL Development ability to write and troubleshoot SQL Code and design ( stored procs,functions, tables, views, triggers, indexes, constraints )Solidacquaintance with windows server, security delegation, SPNs, storagecomponents.Documentationskills for processes and procedures ( creating KBs, runbooks, topology etc )SQL DatabaseOperational support to tech users
Associated topics: data administrator, data analyst, data engineer, data management, data scientist, data warehousing, database, hbase, sybase, teradata