SQL Server DB Administration
Onsite Day One - Alpharetta , GA. or Berkley Heights, NJ
Vaccine required
Client laptop
BGV must be completed prior to start
Mandatory Skills
SQL Server Administration 7+ Expert
SQL server performance Tunning 7+ Medium
SQL Development 1+ Basic
DB migration 5+ Expert
SQL server installation & upgrade 6+ Expert
Documentation skills 4+ Basic
6+ years of experience in DBA activities on real time SQL Server production environment.
Has strong experience in installation, configuration and up gradation for SQL Server 2008, 2012, 2014, 2016.
Supporting 24x7 production and Dev/QA environments.
Assists in the planning, design, documentation, and implementation of various systems to including servers, software applications and databases.
Strong experience in Database Administration in SQL Server ( 2005 and 2008 )
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 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, Database Snapshot.
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 ( Profiler, DTA, SSMS, PerfMon, DMVs, system stored procedures)
SQL Development ability to write and troubleshoot SQL Code and design ( stored procedures, 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 )