 Conducted Performance Review of 300+ SQL Database Instances for business-critical applications with Senior Leadership team Generated Standard reports from database and analysed the reports for SQL wait events, resource consuming SQL queries, database growth Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries Using execution Plan and Query store feature to creation of new indexes to improve the performance of SQL… Show more  Conducted Performance Review of 300+ SQL Database Instances for business-critical applications with Senior Leadership team Generated Standard reports from database and analysed the reports for SQL wait events, resource consuming SQL queries, database growth Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries Using execution Plan and Query store feature to creation of new indexes to improve the performance of SQL statements Completed minimized the space related errors in SQL Databases by conducting review with Senior Management and addresses the space issues proactively Provided tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database like maintenance plan, add enough spaces to database, configuration changes on both DB and instance level Created a purge script to remove more than one year old dataPerform root cause analysis on failures. Resolve performance tuning related issues and queries. Show less

Installation and configuration of SQL Server 2005, 2008 and apply service pack.Installed and administered two node cluster Active/passive on Microsoft Windows Server 2003 R2 Enterprise Edition SP2 on SAN environment.Creation of New databases, tables, filegroups, users, assigning permissions.Managing data and log file growth.Install SQL Server, hardening and memory setting in UAT and Production.Create backup and setting up standard jobs for backup in the Production and UAT… Show more Installation and configuration of SQL Server 2005, 2008 and apply service pack.Installed and administered two node cluster Active/passive on Microsoft Windows Server 2003 R2 Enterprise Edition SP2 on SAN environment.Creation of New databases, tables, filegroups, users, assigning permissions.Managing data and log file growth.Install SQL Server, hardening and memory setting in UAT and Production.Create backup and setting up standard jobs for backup in the Production and UAT environments.Ensuring High Availability through Configuring / maintaining Replication & Log Shipping.Monitor and tune performance of databases.Capacity planning, Monitoring for disk space, errors.Handling issues related to SQL Server Performance & Query Performance, creating a backup strategy.Running DBCC consistency checks, and fixing data corruption in production databases.Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.Created the indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedures.Administrative tasks include, implementing security, maintenance, backup and recovering databases. Provided support to development team on performance tuning for enhancing application output.Migration of Databases from Old version of SQL server to SQL server 2008.Configuring SQL Server Memory settings, service packs, deploying databases, mapping user’s accounts to logins and assigning permissions and roles.Checking for low drive space and shrinking the SQL Server Log Files.Database size monitoring and resizing.Monitoring Event Logs and SQL Server Logs of Servers in Scheduled Manner.Worked in a 24x7 on call support. Co-ordination with Customers for new projects & implementationsInvolved in DR DrillsGood documentation skills (Prepared KBs/SOPs) Show less

 Maintenance of over 1000 Dell and HP Desktops with Windows server Support. Installation and configuration of application software in windows based systems. Monitoring all kind of servers and application servers, Logs and preparing reports on regular basis using Applications Manager tool Troubleshooting & Configuration of All the version of Microsoft Outlook & Outlook Express  Creating and Maintaining User, Groups, Shared Folders, Printers and Permissions in Windows 2003… Show more  Maintenance of over 1000 Dell and HP Desktops with Windows server Support. Installation and configuration of application software in windows based systems. Monitoring all kind of servers and application servers, Logs and preparing reports on regular basis using Applications Manager tool Troubleshooting & Configuration of All the version of Microsoft Outlook & Outlook Express  Creating and Maintaining User, Groups, Shared Folders, Printers and Permissions in Windows 2003 server and ADS  Maintain File Server, Create Shared Folder in server and Set User Access Permission Experienced in Remote Support through RDS, Dameware, GoTo Express, Mail, OCS R2 Chat and Voice based Support Scheduling Supporting Audio and Video Conferencing Through Polycom devices(Conference Room), Goto Meeting, Office Live Meeting and Avaya Audio Conference Bridge Co-ordinate with Various Global supporting teams for Application and many network and windows based issues Deploying and Supporting Mcafee Antivirus Through ePolicy Orchestrator 3.6.1 Creating Standard Symantec Ghost images to server for all desktop models. Show less