Colorado Jobs

Colorado Jobs

Job Information

Cognizant Technology Solutions SQL DBA - 00037954521 in Englewood, Colorado

SQL DBAWe have aSQL DBA position. The position is Permanent opportunity. Selectedcandidates must be willing to join at a short notice.Qualified candidates should be willing to work at Englewood CO.Note: Must be legally authorized to work in United States without the needof employer sponsorship, now or at ay time in the futureMust Have:Primaary Skill SQL DBA, Secondary Skill - AWSJob Description:Strong experience in Database Administration in SQL Server ( 2012,2014 and2016 )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 PerformanceMonitor, 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 shrinkoperations, DBCC commands, Clustering, Database mirroring, Replication, AlwaysExpert experience in implementing operational automation.Participate in on-call rotation (1 week in 7)Strong knowledge of how indexes, index management, integrity checks,Database Encryption, configuration, patching. How statistics work, howindexes are stored, how they can be created and managed effectively.Knowledge of SQL Server 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 )Solid acquaintance with windows server, security delegation, SPNs,storage components.Documentation skills for processes and procedures ( creating KBs,runbooks, topology etc )SQL Database Operational support to tech usersEqual OpportunityEmployer-minorities/females/veterans/individuals withdisabilities/sexual orientation/gender identity

DirectEmployers