Pentagon Consultancy Services

Job Description

• 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

Job Summary