SUMMARY:

• Having 9 years of experience as SQL Server DBA (2014, 2012, 2008R2, 2008, 2005, 2000) in Production, Development and Staging.
• Experience and good Knowledge about the newly added features like Always ON High Availability and contained databases in MSSQL 2014/2012.
• Extensive experience in Configuration, Implementation and Maintenance for Disaster Recovery solutions using Log Shipping, Mirroring and Clustering.
• Extensive experience in Installation, Configuration, Patches, Upgrades and Administration for SQL Servers in Clustered (Fail - over) and Non-Clustered Environments.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Migrating Oracle & MYSQL databases to MSSQL using SSMA tool.
• Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and to troubleshoot SQL Server related CPU, memory, Disk I/O, & other resource contention.
• Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, Perfmon and DB Engine Tuning Advisor.
• Experience in Monitoring Databases for Deadlock, capturing long running SQL queries, used HINTS for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Implemented efficient Database Design principles; Partitions and compression techniques.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Experience in T- SQL Development skills including stored procedures, Indexed views, User Defined Functions (UDL), Triggers, and Distributed Queries.
• Experience in scheduling Backups and Restore, Log Shipping and Maintenance plans using Native & Third-party tools (LiteSpeed5.0).

TECHNICAL SKILLS

Databases: SQL Server 2000/2005/2008 R2/2012/2014, Oracle 11g/10g, MYSQL, MS Access

SQL Server Tools: Management Studio, Enterprise Manager, Index Tuning Wizard, Database Tuning, Wizard, Profiler, Query Analyzer, Export & Import

Operating system: Windows 2008/2003/2000/ Professional/ NT 4.0 Advanced Server

OLAP Tools: SQL Server Analysis Server 2008, 2005, SSIS (as ETL)

Software Packages: MS Office 97/2000/XP, 2003, 2007, 2013

WEB/APP Servers: IIS 6/7.0/7.5

Industry Domain: Banking and Finance, Sales System, Retail

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr. SQL Server DBA

Environment: MS SQL Server 2005, 2008 R2 & 2012

Responsibilities:

• Experience in creating complex SSIS packages using proper control and data flow elements and deployed the packages and scheduled them.
• Extensive experience with SSIS packages in creating ad-hoc reports using EXCEL and XML files, used as a ETL tool to pull data from SQL server(OLTP) to Teradata (data warehouse), maintenance tasks, providing alerts through email, scheduling tasks and to generate scripts during migration and upgradation.
• Involved in Partitioning Databases and Tables for better Performance.
• Experience in taking Backups and restoring using various 3rd party tools like Lite-speed, VERITAS and created Disaster recovery strategy and automated the tools to perform scheduled backups.
• Configured attunity 2.0 for SSIS packages to transfer 7 million records in 1 minute from Oracle.
• Used SSMA & SSIS packages for transferring data migration for large databases.

Confidential

Sr SQL Server DBA/Architect

Environment: MS SQL Server 2005, 2008 R2, 2012 & 2014

Responsibilities:

• Presented the business solution in Swindon UK at NBS headquarters.
• Import/export data and transform into required format/standard format like XML
• Installation of SQL Server 2008R2, 2012 & 2014.
• Installation & configuration of SSRS, SSAS, SSIS.
• Upgradation of SQL Server environments from 2000, 2005, 2008 to 2012 & 2014.
• Upgradation of SSIS, SSRS & SSAS from SQL 2005 to 2008R2.
• Implemented Always On

Confidential

SQL Server DBA

Environment: MS SQL Server 2005, 2008 & 2008 R2

Responsibilities:

• Worked with table partitioning (SQL Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Used Policy Based Administration feature (SQL Server 2008).
• Prepared Documentation for the Disaster Recovery plan
• Designed Data Integrator jobs with Error Handling and email notifications.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Assisted in Setup and troubleshooting Active/Passive Clustering for SQL Server 2005/2008.
• Resolved the issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk I/O.

Confidential

SQL Server DBA

Environment: MS SQL Server 2000, 2005 & 2008

Responsibilities:

• Configured and administered SQL Clusters (Active/Passive, Active/Active), Database Mirroring, Replication and Log shipping.
• Performed Attach/ Detach, BCP, Import & Exports and Copy Database Wizard.
• Query Optimization and Performance tuning for optimization like maintaining/creating indexes, Create/Update Statistics, Tuning SQL queries.
• Troubleshoot Memory Errors/Query Processing and usage of Memory and resolving errors pertaining to insufficient Memory.
• Using TDP, TSM tools for backup and restore operations.
• Installation, Deploying, scheduling & Troubleshooting of SSRS, SSAS, SSIS.

Confidential

SQL Database Administrator

Environment: MS SQL Server 2000 & 2005

Responsibilities:

• Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1.5Terabytes.
• Involved in Source Data Analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Setup SQL Server 2008 Clustering with SP1