Description
Professional Summary: Over 10 plus years of IT Experience in SQL Server database admin, System Analysis, Design and Development and Support of Microsoft SQL Server 2014 /2012 /2008 R2 / 2008 / 2005 / 2000 in Development, Test and Production Environments on various business domains like Auto, Financial, Insurance and Manufacturing. * Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2012/2008R2/2008/2005/2000 on Clustered and Standby Environments. * Good experience working with the SQL 2012 new feature Always ON. * Configured the servers on 32 bit and 64 bit clustered and standalone server environments. * Experience in supporting Very Large Database (VLDB) more than 2TB and troubleshooting problems * Expertise in Database Backup and Recovery procedures by using native and litespeed. * Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance. * Experience in using Performance Monitor, Profiler to identify Dead locks, blocking, long running queries. * Good experience in data (table) partitioning, filtered indexes, Policy based management. * Experience in data modeling like physical data modeling and logical data modeling by using ERWIN tool. * Migration from SQL server 2000 to 2005 and 2000 / 2005 to 2008 by using In-Place upgrade process and as well as side-by-side upgrade process, And documented the Upgrade Process. * Worked with SQL Server 2008 new MERGE statement * Expertise in Migrating SQL Server 2000 data bases into SQL Server 2005 and SQL Server 2008 and also expert in migrating DTS packages to SSIS Packages. * Experience in implementing different types of High Availability technics: Replication models like Snapshot, transactional, Log shipping and Database Mirroring in Cluster Environment. * Expertise in writing Stored Procedures, Functions and Triggers using T-SQL and also expert in tuning Complex Queries. * Good experience on configuring files with different RAID levels. * Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities and DMV's and DMF's, Re-indexing, Updating Statistics and online indexing. * Created linked servers between SQL Server, Oracle 9i & 10g, DB2 and Teradata. * Expertise on Business Intelligence Tools to Create SSRS Reports, SSIS Packages and SSAS with OLAP. * Extensively worked on Data and Backup compression in SQL Server 2008. * Expertise in implementation of security models Database authentication modes, creation of users, configuring permissions and assigning roles to users. * Experience in managing Alerts, Operators and Jobs through SQL Server Agent. * Extensively used tools like SQL Profiler, Database Engine Tuning Advisor and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance. * 24 X 7 Production Database on Call Support.
Accomplishments
Highlights:
Keywords
