Ms Sql Dba
Net2Source Inc. is an award-winning total workforce solutions company recognized by Staffing Industry Analysts for our accelerated growth of 300% in the last 3 years with over 5500+ employees globally, with over 30+ locations in the US and global operations in 32 countries. We believe in providing staffing solutions to address the current talent gap - Right Talent - Right Time - Right Place - Right Price and acting as a Career Coach to our consultants. Please find below the job description. Position: MS SQL DBALocation: Alpharetta, GA (Onsite from Day 1)Type: Long Term Contract Mandatory Skills
- SQL Server DB Administration
- 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
- Manager - MS SQL DBA
- 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 )
- America's Most Honored Businesses (Top 10%)
- Awarded by USPAAC for Fastest Growing Business in the US
- 12th Fastest Growing Staffing Company in USA by Staffing industry Analysts in the US (2020, 2019, 2020)
- Fastest 50 by NJ Biz (2020, 2019, 2020)
- INC 5000 Fastest growing for 8 consecutive years in a row (only 1.26% companies make it to this list)
- Top 100 by Dallas Business Journal (2020 and 2019)
- Proven Supplier of the Year by Workforce Logiq (2020 and 2019)
- 2019 Spirit of Alliance Award by Agile1
- 2018 Best of the Best Platinum Award by Agile1
- 2018 TechServe Alliance Excellence Awards Winner
- 2017 Best of the Best Gold Award by Agile1(Act1 Group)