SQL DBA and System Administrator

For a client of TeamLease Services Ltd

4 to 10 Years

BE/B.Tech

Gurgaon

5,00,000 - 10,00,000

Job is expired

Posted on 27 Sep 18

Job DescriptionLast Date 31 Oct 18

ü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

Job Type

Full Time

Interview Type

Face to Face Interview

Company Description

TeamLease Services established in 2002, is one of India's leading human resource service companies in the organized segment. A Fortune 500 company listed on both NSE & BSE markets, with eight offices and 1400 clients across the country. The company at present has about 100,000+ live associates/ trainees spread across the country and have till date given employment to 1.5+ million people with an aim to hire millions more