SUMMARY

• Over 6+ years of extensive experience in database design, development and administration with MS SQL Server 2012(with always on high availability)/ 2008/2005/2000 using SSIS, SSAS, SSRS.
• Highly experienced in Database Designing, Implementation and System Administration using Microsoft SQL Server as well as Windows 2003, 2008& 2012
• Experience using Performance Monitor/Profiler to solve Dead Locks, long running queries.
• Extensively used the native tools like Index Tuning Wizard, Database Tuning Advisor, Profiler, Performance Monitor, Activity Monitor, and Event Viewer for performance analysis.
• Experience in Data Migration by using side - by-side upgrade process Management.
• Experience in implementing SQL Server security and Object permissions.
• Experience in creating and managing database objects like tables, views, stored procedures, Triggers, user defined data types and functions.
• Expertise in implementing and maintaining efficient Disaster Recovery Strategies and High availability like Replication (Snapshot and Transactional with updatable subscriptions), Log shipping, Clustering (Active-Active and Active Passive)
• Good experience in planning and implementing different types of Replication Methods like Snapshot, Transactional and Merge replication.
• Experience with Database consistency checks using DBCC & Dynamic Management Views using DMV’s
• Good experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC.
• Experience in troubleshooting SQL issues by using SQL Tools Execution plan, Trace, DTA.
• Have experience in Performance Tuning, T-SQL Query Optimization and Solving Blocking issues.
• Expertise in Identifying the Bottlenecks caused by complex queries using Activity Monitor/SQL Profiler and handling them by implementing better Query Execution plans.
• Extensive experience in T-SQL for developing complex Scripts, Batches, Stored Procedures, Cursor, Triggers, Tables, Views, User Defined Functions, Data Integrity, and SQL joins.
• Experience in ETL between Homogenous and Heterogeneous System (Oracle/DB2/Access/Excel/CSV/XML) using SQL tools (SSIS, DTS, Bulk Insert, BCP) and providing a definite solution.
• Experience in creating several Master-Child report (drill-down, matrix, tabular, linked, sub-report) model for Monthly/Quarterly client reporting system on SSRS Crystal reports.
• Knowledge of SQL Server Database Administration tasks such as planning, scheduling jobs, backup and recovery strategies, index tuning and performance tuning, and archiving data.
• Experience in monitoring SQL server, capturing performance problem and improve performance by tuning Databases.
• Experience in creating and maintaining Backup and Restore, Mirroring and Log-Shipping strategy as a part of Disaster recovery.
• Excellent in Capacity Planning and storage management.
• Excellent analytical and communication skills with 24/7 rotated support experience.

TECHNICAL SKILLS

Database: MS SQL Server 2000/2005/2008/2012.

Language: T-SQL, PL/SQL, ASP.Net, Java.

Server: Windows Server 2000/2003/2008/2012 , Unix, Linux

DB Tools: LiteSpeed (Backup Tools), SQL native Monitoring tools, NT Performance monitor/System monitor, TSQL, SQL Profiler and SQL Query Analyzer

Reporting Tools: Crystal Reports, BID, SQL Server Report Builder, Visual Studio

Data Migration: MSDTS, SSIS, ETL, BCP, Data Migration, Import/Export Wizard, SSMA

PROFESSIONAL EXPERIENCE

Confidential, NJ

SQL server DBA

Responsibilities:

• Create and maintain various databases for Production, Development and Testing Servers using MS SQL Server2005, 2008 and 2012 with always on high availability groups.
• Extract, Transform, and Load data(ETL) from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Responsible for Database and Log Backup & Restoration Process, Backup Strategies and Scheduling Backups.
• Responsible for Security Administration- creating users and assigning them roles and privileges.
• Migrating contents from SQL server 2005/2008 to SQL Server 2008 R2 using migration wizard.
• Performance tuning of Queries and Stored Procedures using graphical execution plan, Query analyzer, monitor performance using SQL Server Profiler and Database Engine Tuning Advisor.
• Implemented transactional replication between Primary Server and Read Only servers.
• Experience in configuration of Report Server, Report Manager, Report scheduling, give permissions to different level of users in SSRS 2008/2008R2/2005.
• Use of DBCC Utilities to maintain the consistency and integrity of each database in the production server.
• Conducted root cause analysis of application availability and narrow down the issues related to coding practices, Database Bottlenecks, or Network Latency.
• Used SSIS to create ETL packages (dtsx files) to validate, extract, transform and load data to data warehouse databases and process SSAS cubes.
• Experience in table/index partitioning and full text search and tuning the Production server to get the performance improvement.
• Maintaining both DEV/QA/Test and PRODUCTION Servers in sync. Installed and reviewed SQL server patches as well as service packs.
• Creating Backup strategies and scheduling using third party tool like Lite Speed, as a part of database maintenance plans.
• Created the MS SSIS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Design and configure Database, tables, indexes, store procedures, functions and triggers
• Troubleshot database status, performance, Replication, Log-shipping as well as various errors on production, development and UAT servers.
• Experienced in Point-in-time restoring databases in production and development servers.
• Migrate DTS and SSIS to import and export the data from SQL Servers.
• Monitoring SQL servers for performance ad-hoc and pro-actively.
• Design and implement T-SQL Scripts and Stored Procedures and tune up them.
• Providing 24/7 supports to SQL application developers in implementing the applications on production server.

Environment: s: SQL Server 2012(SQL Server Management Studio, Query Analyzer, SQL Profiler, Index Tuning Wizard, SSIS, MSSQL Server 2012 Analysis Server), Microsoft Visual studio 2012 MS-Reporting Services, ADO.NET, XML.

Confidential, OH

SQL Server DBA

Responsibilities:

• Create and maintain various databases for Production, Development and Testing Servers using MS SQL Server 2005. Planning the location of data and Transaction log files on the disk.
• Install and configure SQL Server 2005/ 2008 on the server and client machines.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Experience of DBCC Utilities to maintain the consistency and integrity of each database in the production server.
• Conducted root cause analysis of application availability and narrow down the issues related to coding practices, Database Bottlenecks, or network latency.
• Resolve locking and blocking issues.
• Experience with Database consistency checks using Store Procedure, DBCC & (Dynamic Management Views) DMV’s.
• Experience in table/index partitioning and full text search.
• Tuning the Production server to get the performance improvement.
• Running Index tuning wizard to identify missing indexes.
• Use of Microsoft Diagnostic utilities to take memory dumps and automated traces.
• Implementing and Monitoring SQL Server jobs using custom scripts.
• Monitoring SQL Server LOGS, Application logs and analyzing the logs.
• Connecting SQL Server remotely using Terminal services.
• Providing 24*7 supports to SQL application developers in implementing the applications on production server.
• Maintaining both DEV/QA/Test and PRODUCTION Servers in sync.
• Creating users and assigning appropriate permissions.
• Creating Backup strategies and scheduling using third party tool like LiteSpeed, as a part of database maintenance plans.
• Created the MS SSIS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Involved in Performance Tuning for source databases, target databases.
• Maintained BizTalk Application Servers and BizTalk SQL Servers 2008.

Environment: s: SQL Server (SQL Server Management Studio, Query Analyzer, SQL Profiler, Index Tuning Wizard, SSIS, Visual Studio.

Confidential, NY

NETWORK ADMINITRTOR/SQL SERVER DBA

Responsibilities:

• Install and configure workstation and windows server 2003.
• Installation, Configuration and up gradation of SQL Server 2000/2005/2008 technology, service packs and hot fixes using MS SQL Server 2008.
• MS SQL Server 2005. Planning the location of data and Transaction log files on the disk.
• Responsible and knowledge of high availability SQL Server solutions with SQL Server Failover Clustering, Database Snapshot, Log shipping, and Database Mirroring.
• Responsible for Capacity planning, Performance Tuning, Disaster Recovery, Troubleshooting, backup and restore procedures.
• Solid hands on performance monitoring with Activity monitor, SQL Profiler, Performance monitor, Database Create and maintain various databases for Production, Development and Testing Servers using Tuning Advisor, DMVs and DMFs, SQL Diagnostic Manager.
• Responsible for implementing different types of Replication Models such as Transactional, Snapshot, Merge and Peer to Peer.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (DTS) Packages.
• Implementing DBCC Utilities to maintain the consistency and integrity of each database in the production server.
• Conducted root cause analysis of application availability and narrow down the issues related to coding practices, Database Bottlenecks, or network latency.
• Resolve all locking, blocking and deadlocking issues.
• Experience with Database consistency checks using DBCC & Dynamic Management Views using DMV’s.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• Experience about Desktop/Laptop’s Network connectivity and support to end users.
• All System configuration, update patches, drivers, setup user and administrative accounts, assign permissions and security.
• Provide local and remote help desk support to all staff members, resolving various technical issues.
• Maintain and install applications/devices on Local and Wide Area Network level Server 2003 Windows XP, MS OFFICE LAN/WAN & WLAN connectivity, Network Setup, IP configuration(HTTP,TCP/IP,DNS, DHCP and WINS),Network Printer configuration, share files folders.
• Deployment and manage Exchange Server including server backup, email backup and support end users.
• Create and manage Server 2003 security, such as monitoring system performance, Event Viewer log, Firewall, Virus protection, Windows update, Spyware Protection.

Environment: s:SQL Server (SQL Server Management Studio, Query Analyzer, SQL Profiler, Index Tuning Wizard, SSIS, Visual Studio.