Lkd Naidu Email and Phone Number

Installation, Administration and Maintenance of SQL Server Instances. Setup Test, Dev, Staging and Production Environments. Create Users and assign permissions based on the level of database access the user would need. Create Linked Servers to SQL Servers and other databases such as Oracle, Access, etc. Design database Backup and Restoration Strategy. (Database Backups and SQL Server Agent) Once created the database Backups, monitor those backups are being performed regularly From time to time recover the databases to a specific point of time, as per the requests. Setup High-Availability as part Disaster Recovery Strategy for the Databases. (Failover Clustering, Database Mirroring, Log Shipping and Replication) Troubleshoot various problems that arise in a day-to-day work and fix the issues. Monitoring and Performance tuning; Physical Server Level, Database level (Database settings and options) and query tuning. (Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc) Documenting major changes to the SQL Servers.

SQL Server 2008 R2 and 2012 deployments using Building Blocks i.e. PowerShell Scripted code Optimized installation times through Slipstream installations as per requirement Hardening SQL Server instance configurations and database settings Creating alert notifications through email system for all fatal/critical system errors Fixing MSI and MSP corruptions for any failed installations of Service Packs Performed migrations (also in-place) from SQL Server 2005 to 2008 R2 Mirror failures through Mirror Monitor and resolving sync/corruption issues Worked on replication models and verifying replication agents status Working on deadlocks and blockings and identifying the key session behind the cause Improving query performance using different methodologies (Index Fragmentation, Table Statistics Analysis, Recommendations on file groups, TempDB optimization) Fixing 14420 and 14421 errors of log shipping and also job failures related to LS Node failure troubleshooting, Patch installations, Rolling upgrades, Failover RCA Handling escalations in team related to Clustering and Performance Tuning Performing database refresh across different versions. Creating Jobs/MPs for most frequent tasks like checking the integrity of database, rebuild index

SQL Server 2000, 2005, 2008 installations, configuration and security settings SQL Server upgrade with service packs and hot fixes Creating Database users, controlling access to instance and databases Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach Configuring / maintaining high availability SQL Server solutions that include Log shipping, Mirroring, Replication Implement database administration/ maintenance plans and monitor using alerts Monitor database usage and growth trends to forecast future storage needs as Capacity planning measure Migration of SQL Server 2000 to 2005 and also in-place upgrade Good experience in resolving blocking/locking and dead lock Issues Contacting Microsoft support for high end critical issues Good experience in resolving blocking/locking and dead lock Issues Creating and Maintaining scheduled jobs and implementing automation for other tasks Handling the database suspect situation Regular checking of the database consistency using DBCC commands Creating snapshots as per requirement of Application team Configuring and installing clustering 4-node (N+1) Coordinating with the onsite DBA Support Team on production support issues Creating CR’s for every client-raised request and from users/application team Preparing RCA as required for P1 critical issues and also for all problem tickets Preparing MOM for all the meetings held for constant updates to other team members Keep track of all databases & server related information in Portal for newbie’s Documenting all new resolved tasks/environment details in sharepoint