Dear friends,
Please respond with suitable profiles with contact details, visa copy DL, Passport number and LinkedIn for the below urgent requirement.
Position: Sql server DBA(7+yrs exp. Needed)
Location: Alpharetta, GA/Berkeley heights, NJ(Day 1 onsite)
Type: long term contract
Rate: open
Position summary:
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 )
Years of Experience: 7.00 Years of Experience
Regards,
Radha Venkatraman
Recruitment Lead
ReqRoute,Inc
Desk: 408-600-2008; Fax: 888-400-2698
Email: ra...@reqroute.com