Pentagon Consultancy Services
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:
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
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...
