Senior SQL Server Database Administrator
SQL Server DBA | IBM Global Business services
May 2008 - October 2010
1 Installation and configuration of SQL server software and related products.
2 Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policy for various categories of User Support.
3 Experience on planning & Implementation of Backup strategies, Restores
4 Knowledge on Maintaining High Availability of Databases using Mirroring concepts.
5 Monitoring SQL Server performance using SQL Profiler and DMV Queries.
6 Configuring the appropriate SQL Server settings using SP_Configure.
7 Creating Databases, Maintenance plans & Jobs.
8 Extensive knowledge on Database Replication.
9 Configuring and Monitoring Log Shipping.
10 Export or Import data from other data sources like flat files using Import/Export.
11 Creation of linked servers as per the requirement.
12 Configuring database mail by creating database profiles and accounts.
13 Suggesting and Implementing solutions for improving performance and availability.
14 Proactive monitoring of the database servers.
SQL Server Support Engineer | Microsoft India
October 2010 - March 2013
1. Technical issues include troubleshooting SQL Server issues like Installation of all versions of SQL Server on different Environments & Configurations.
2. Issues related to Security which includes different types of Encryption configuration.
4. Providing information and helping Customers in implementing High Availability solutions like Database Mirroring & Clustering.
5. Analyzing the logs and providing the root-cause for the Cluster Failover/ SQL Server crash.
7. Troubleshooting SQL Server performance problems and providing suggestions to resolve the performance issues.
8. Educating Customers and other Team members with best practices to improve the performance.
9. Configuration & Troubleshooting issues related to different types of Replication topologies.
10. Troubleshooting Blocking/Deadlock issues in SQL Server.
11. Troubleshooting issues relate
Work Terms
12+ years of experience as SQL Server database administrator