We have around 10 years of experience in SQL server, Expertise in Query optimization and writing complex quires. Expertise in T-SQL writing stored procedures, triggers and functions. Administering SQL Server High Availability and Disaster Recovery strategies. Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations. Experience in using DMV and dynamic management functions for finding out long running queries. Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability. Experience in Disaster Recovery Planning and Security Management operations. Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning. Having hands on experience in DR processes including Log Shipping and Database Mirroring. Worked on configuring SQL Server with minimum privileged access. Troubleshoot performance problems, fine-tuning of databases and index Analysis. Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support years of experience in SQL Server Database Administration/ Development using MS SQL Server Management Studio2012, 2008 R2, Management Studio 2005, Enterprise Manager 2000. Expert with Database Administration backup/recovery methodologies and procedures on a Windows/SQL Server platform. As well as expert in Implementing Database Mirroring and Log shipping with SQL server 2012, 2008 R2, 2005 Strong knowledge in implementing different types of Replication Models such as Transaction, Snapshot and Merge in SQL Server 2012, SQL Server 2008R2, 2005in OLTP environments. Experience with Database Backup- full, differential, log, etc Recovery and Disaster recovery procedures. Immense experience in the manual fail over fail back process to make the DRserver as the active server. Very strong implementation of Microsoft Business Intelligence BI platforms including SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , SQL Server Analysis Services SSAS and Microsoft office SharePoint Server 8 in SQL Server 2005/2008. Experience in monitoring SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully. Experience in SQL Server DTS and SSIS Integration Service package design, constructing, and deployment.