MsSQL - Bengaluru, India - Quess IT Staffing

Quess IT Staffing

Verified Company

Bengaluru, India

3 weeks ago

Posted by:

Deepika Kaur

beBee Recuiter

Description

About Us
"Magna Infotech, now Quess IT Staffing, is India's largest IT staffing company with over 20 years of experience in staffing IT professionals in 300+ companies across levels and skillsets. Our 10,000+ associates deployed in 80+ cities and towns are proficient in over 500 technological skills. Our associates help enable cutting edge solutions some of the biggest names across industried. Quess IT Staffing is a division of Quess Corp Limited, India's leading business services provider and largest domestic private sector employer. Quess Corp Limited is - 'A Great Place to Work' certified - a testament to our excellent culture, people, and processes."

About Company

Roles and Responsibility
Location - Bangalore ( relocate to Bangalore as and when asked)

Exp

6 plus

Client round will be there.

Skill / Role:
MSSQL L3

Np

15days to Immediate

Relevant Experience: 6+yrs in MSSQL

Qualification:
Bachelors / Masters

Must be having good knowledge and experience on:
Excellent communication and conversation skills (Verbal and Written)

Good working knowledge of MS OFFICE

Evaluate the Database Server Hardware.

SQL Server 2005, 2008R2, 2012, 2014.

Installation and Configuration of SQL Server Pre-requisites (Standalone and Cluster).

SQL Clustering (Adding new Node or Removing Node from cluster), configuration

Always On

Database security

Experience in Performance Tuning and Monitoring session.

Troubleshoot issues related to TempDb, Transaction Log and System Databases

Creation of SQL agent jobs and troubleshooting.

Database migration/Up gradation from 2005/2008 R2 to 2008 R2/2012/2014.

Database Backup and restore (Full, Trans, Diff, File Group)

Database Indexing and index Maintenance.

Database maintenance

Creation of Always On groups

Troubleshooting of cluster and Always On

Excellent communication and conversation skills (Verbal and Written)

DR Replication configuration and testing.

Port configuration

Good knowledge of Windows server 2003,2008R2, 2012 R2

Hardware sizing Capacity planning for DB and O/S parameter like CPU, Memory and Disk, log, T.log for New project requirement.