We have years of IT experience in SQL Database Administration, System Analysis, Design, Development & Support of MS SQL Servers 2012, 2008 R2, 2008, 2005, 2000 and 7.0 in Production, QA, UAT, IST, Reporting Services, Development environments & Replication and Cluster Server Environments.
Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2012/2008 R2/2008/2005/2000.
Experience in upgrading SQL Server from version 2000 to 2005/2008/2008 R2/2012.
Have good experience with partitioned schemas, partitioned tables and indexes, creating Filegroups using SQL Server 2012/2008 R2/2008/20005.
Implementing DR solution, High Availability of database servers using Database mirroring, replications and Log Shipping.
Implementing Database High Availability using AlwaysOn Availability Groups on SQL Server 2012.
Experience in Data Migration Management.
Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
Created maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.
Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS Packages.
Extensive experience in writing Distributed Queries between SQL Servers by creating link servers and federated servers.
Experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC utilities.
Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
Experience in applying patches and service packs to keep the database at current patch level.