Job Title : MS SQL DBA

Job ID : 2551860104

Posted on : 11-03-2015

Designation : MS SQL DBA

Experience : 10 to 17 yrs

Location : Bangalore

Salary : Industry Standard

Client Name : MNC

Education : Graduation

Skills : MS SQL, DBA, Technical Support, SQL Server

Priority : HOT

Description :

Job Description: 


Experience: 10+ yrs 

Job Location: Bangalore 


- 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 

- Restoring the Databases using the Database Snapshots 

- Resolving the Disk Space Usage, Data file and T-Log files shrinking etc 

- Managing SQL Server security 

- Knowledge on SCOM tool 

- Knowledge on Reporting services 

- Team management & Coordination with the client 

- Willingness to work on 24 x 7 (on call) & work during UK business hours 

- Having knowledge on windows administration is an added advantage 

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