Over 3 years of experience as a DBA in Training and Production environment.
Installation, configuration and migration of SQL Server 2012 / 2008 / 2005.
Backup/Recovery, Disaster recovery solution - High Availability using Database Mirroring, Replication and Log Shipping.
Set-up of Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g.
Usage of SQL Server Profiler, SQL Server Agent, Database Engine Tuning Advisor (DTA), Rebuilding of indexes.
Knowledge of DBCC commands and Dynamic Management Objects
Implementation of SQL Logins, Roles and Authentication Modes as a part of Security
Policies for various categories of users.
Troubleshooting knowledge of SQL issues by using SQL Tools, Execution plans,
Trace, Statistics and Index tuning wizard.
Partitioned schemas, Partitioned tables and Indexes, Creation of File groups.
Creation of Jobs, Alerts, SQL Mail Agent.
Troubleshooting performance issue.
Troubleshooting production sql issues.