Job Title : SQL Server SME

Job ID : 2132478773

Posted on : 11-03-2015

Designation : SQL Server SME

Experience : 10 to 12 yrs

Location : Chennai

Salary : Industry Standard

Client Name : MNC

Education : Graduation

Skills : SQL Server, UAT, CTO

Priority : HOT

Description :

Job Description:


- Standalone and Cluster SQL Server Installation and configuration 

- Up-gradation and Patch management 

- Responsible for L3 and L4 Production issues 

- Troubleshooting Production/UAT/DEV/TST SQL Server Issues (Job failure, , Login failure, Performance Issues, Blocking, Deadlock, Suspect database etc) 

- Supporting business user requests (Heath Check Reports, Performance Issue, Access/Permission, Job failures etc) 

- Developed policy for database decommission, user decommission, SQL Server migration and escalation 

- Performance and Tuning of SQL Server, Database and Queries 

- Capacity Planning (Backup Share, Disk, CPU and Memory) 

- SQL Server Migration 2000 to 2005 and 2005 to 2008 

- Develop and configure the database maintenance script for all the production and UAT servers 

- Maintain the databases by creating the Backup Plan, Disaster Recovery Plan and Maintenance Plan 

- Automated the Backup and Maintenance plan using third party tool 

- Database and Application tuning, Performance monitoring and system tuning 

- Troubleshooting and resolving SQL alerts and SQL errors arriving into the ticketing system/queue 

- Implementation, Configuration and troubleshooting HA Services (Log Shipping, Database Mirroring, Replication and Cluster) 

- Implementation, Monitoring and Troubleshooting database issues, jobs and database high-availability services 

- Migration of SQL Server databases between production, development and staging servers 

- OS and DB Alert setup on Production Server 

- Daily Server health check 

- Building DTS Packages, SSIS packages and managing them. 

- Designing database backup and maintenance plan 

Apply Now

Permanent Staffing

Permanent staffing assignments refers to those Jobs when you as a company look to hire people on your payroll on a permanent basis...

Read More

Contract Staffing

Although Professional Services in Human Contracting is a fairly new concept in India, The PS market is fast maturing and catching up with the changing industry...

Read More


Recruitment Process Outsourcing (RPO) is a form of business process outsourcing (BPO) where an employer transfers all or part of its recruitment...

Read More