Senior Ms Sql Database Administrator
Current•Administrating more than 1000+ Database servers across all the countries in the world•Installation and Configuration of SQL Server 2008 R2.2012/2014/2016.•Troubleshooting the performance issue in SQL server and identify the issues and providing the root cause with resolution.•Prepare SQL server for High Availability environment.•Upgrading SQL Server 2000, 2005,2008, 2012,2014,2016•Install patch or service pack for SQL 2000, SQL 2005,SQL 2008,2012,2014,2016•Maintaining Production and development database•Disk space Planning and Management in all the servers.•Backup and Restoration of Database.•Implement and maintain database security.•Creating Users and giving permissions to them.•Having experience on Scheduling Jobs and assign Jobs.•Using SSIS for Scheduling Job, Creating reports for SQL services availability.•Developing successful Backup strategies based on recovery model.•Configure Maintenance plan activity to maintain the database healthy and performance.•Working on Ticket Logging System based on Remedy and HP tools.•Resolve incident, service call and work order ticket based on SLA.•Impact Analysis and Client Interaction•Deploying the stored procedures and jobs, DTS, SSIS in the production environment.•Worked on migration tasks•Good knowledge to update more new techniques by Microsoft and developing the standard of supporting the SQL servers.