* Deep understanding and working experience of SQL Server (SQL 2005 and SQL 2008R2, 2012 and 2016 includes installation, configuration, Backup Recovery, HA and maintenance of standalone etc. * Performed Data Modeling, data analysis, database design, and developing E-R diagram using ER Win, Database Diagram * I have done database STIGs * Optimizing and Performance Tuning for Online Indexing, Query Optimization, Performance Tuning using execution plan, Profiler, Database Tuning Tool * Configure Managed and troubleshot all high availability in SQL Server like Log shipping, Mirroring, Replication and Clustering for Disaster Recovery * Experience in using Profiler and Windows Performance Monitor to resolve Dead Locks or long running queries and slow running server * Experience in administering AD (Active Directory)/Domain and monitoring user activities * Vast knowledge and working experience on SSIS, DTS, SQL Server Reporting Services, scripting for customized Report Generation * Create and set-up Jobs for Database Automation * Applied Service Pack (SP) on versions of Database Server - 2005, 2008R2 and 2012 * Migrated databases from other databases like Oracle 10gR2/11gR2, MySQL, * Upgraded databases from MS SQL Server 2005 to MS SQL Server 2008 R2, 2012 * Upgraded databases from MS SQL Server 2008R2 to MS SQL Server 2012, 2016 * Deployed Databases in Test, Dev and Production environment * Worked on Linked and Remote Servers to run queries between SQL servers and other data sources using ODBC, OLE DB drivers * Security Management - Access and security management like creating Logins with appropriate roles, creating users and groups and granting and revoking privileges for data security * Used DBCC to check physical and logical consistency of database and Rebuilding indexes. * Good experience data masking
Description
