Pentagon Consultancy Services
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:
MS SQL DBA
Experience: 10+ yrs
Job Location: Bangalore
Responsibilities:
- 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
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...
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...
RPO
Recruitment Process Outsourcing (RPO) is a form of business process outsourcing (BPO) where an employer transfers all or part of its recruitment...
