Occupation:Database Administrator |
Location:Flushing, NY |
Education Level:Master |
Will Relocate:YES |
Description
Professional Summary * Having 5 plus years of professional experience in Microsoft SQL Server Database Administration, Development & Configuration. Providing (24x7x365) on-call production support. * Extensively involved in installation & configuration of MS SQL SERVER 2000,2005,2008,2008 R2. * Experience in Setting up (HA) High Availability solutions like Log shipping, Database Mirroring, Replication and Clustering as a part of Disaster Recovery (DR). * Extensively involved in configuration of different clustering modes such as Active-Active and Active-Passive. * Implemented new SQL Server 2005 concepts like Data partitioning Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-catch blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts, DTA, SQLCMD and dedicated admin connection. * Experience in using Dynamic Management Views (DMV) and Dynamic Management Functions (DMF) for finding out long running queries. * Experience in (ETL) Extracting, Transforming and Loading data from various heterogeneous data sources like Access, Excel, CSV, Oracle, flat file, Text Format Data using OLE DB connection by creating various SSIS/DTS packages. * SQL Server (BI) Business Intelligence Development Studio expertise to create SSRS reports, SSIS packages such as Conditional Split, Derived Column on the data retrieved, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse. * Expertise on physical storage SAN configuration on different RAID levels. * Extensive experience in Disaster Recovery, Troubleshooting, Backup and Restore Procedures. * Migrated SQL Server 2000 databases into SQL Server 2005 and SQL Server 2008. * Experience in upgrading SQL Server software to new versions, applying Service packs & hot fixes. * Excellent backend skills in creating SQL objects like tables, synonyms, stored procedures, views, Indexes, triggers, rules, defaults, user defined data types and functions. * Experience in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, Index rebuild, reorganize, horizontal and vertical partitioning. * Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.