Sql Dba And System Administrator jobs Gurgaon-For a client of TeamLease Services Ltd-4 to 10years of experience-27 September 2018

ü Having 4 plus years of ITexperience in SQL Server Database Administration.

ü Provided after hours and24/7 database maintenance and production support.

ü Experience inInstallation, Configuration, Maintenance and Administration of SQL Server2005and SQL Server 2008 and 2008R2 and 2012.

ü Experience in upgrading SQLServer from version 2005 to 2008 and 2008R2 and 2012 and 2016.

ü Experience inimplementing SQL Server security and Object permissions like creation of users,granting permissions and assigning roles to users.

ü Troubleshooting Orphanusers and Orphan logins.

ü Experience in Checking ofError logs, SQL server logs, Disk Space, Event Viewer and job history.

ü Experience in managinglarge databases.

ü Experience in DatabaseBackups, Recovery models and Disaster Recovery procedures.

ü Experience on installingthe Service Packs and Hot fixes and Troubleshooting.

ü Experience inimplementing database consistency checks using DBCC utilities.

ü Experience in using toolslike SQL Profiler, Windows Performance Monitor (counters) for monitoring andtuning purposes.

ü Scheduling the jobs forproactive performance tuning like the tasks which involve rebuilding of indexeson a regular basis, tables de-fragmentation.

ü Set up High-Availabilityas part Disaster Recovery strategy for databases(Log -Shipping and Mirroring)

ü Knowledge on Replicationand SQL 2016 features and installation of sql in linux .

ü Experience in performancetuning resolving issues like blocking ,deadlocks and slow running queries

ü Experience in configuringtwo node active passive clusterinstallation

ü Experince in configuringalwayson and deploy ssis packages and ssrs reports to production