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 upHigh-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