years of experience in Database Administration, Database Design, Modeling ,Development & Support of MS SQL Server 2008R2/2008/2005/2000 in Production & Development environments. Good knowledge of MS SQL Server 2008 implementing new features like Row and Page compression mechanism, CDC, Data Compression, Backup compression, Resource Governor, Performance Data Collector and Transparent Data Encryption. Performed Log Shipping and implemented Replication as High Availability techniques. Experience in Database Mirroring as Disaster Recovery Solution. Experience in Creating Tables, Views, Triggers, Cursors, Dynamic Stored Procedures, User Defined Functions and other Transact-SQL (DDL, DML) statements for various applications. Worked with SSIS & SSRS for various BI requirements. Proficiency and Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning. Tracked Server Activity, Query Performance and Disk usage activity statistics via Performance Data Collection. Expertin designing Relational Database Model, implementation and testing as per business needs. Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities. Implemented SQL Server 2005 new concepts like Data partitioning, Snapshot Isolation, Online Indexing, Try-Cache Blocks, DDL Triggers and DMV & DMF. Created Partition function, Partition scheme and multiple file groups and files to host the table data for Data partitioning. Optimized the Disk space for performance using RAID and SAN. Experience in data migrating (using tools like DTS, BULK_INSERT, BCP) between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
Experience in extracting, transforming and loading data (ETL) using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages. Extensive use of DTS in SQL Server, Performance Tuning & Application Design, Disaster Recovery Planning, Security Management, Managing server and clients, T-SQL, etc. Experience in building Adhoc Reports, Parameterized Reports, Linked Reports, Toggle Reports, and Reports with Sub Reports using SSRS. Experience in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008. Intensive experience in Monitoring and Tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, Windows Performance Monitor. Expert in automating process by creating jobs, and error reporting using Alerts, SQL Mail Agent. Experience in creation of logins, users and configuring permissions and assigning roles to users. Good understanding of Normalization /De-normalization, Normal Form and database design methodology. Experience in Database Backup and Disaster Recovery procedures like Log shipping. Worked extensively in Clustered environment (Active / Passive) to further increase scalability and stability of business critical systems. Development of automated notification when SQL Server Backups and schedule maintained Jobs. Expertise andInterest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2 Terabytes. Experience in optimizing the query by creating various clustered, non-clustered indexes and indexed views. Experience in creation of logins, users and configuring permissions and assigning roles to users. Experience in Migrating of SQL Server 2000 to SQL Server 2005 & SQL Server 2005 to SQL Server 2008using suitable approach.