SUMMARY

• Over 7+ years of extensive experience in database design, development and administration with MS SQL Server 2012/2008/2005/2000 using SSIS, SSAS, SSRS in financial, retail, healthcare and banking industries.
• 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, Oracle 10g/11g, My SQL

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

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 Server 2008
• 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. f 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 DBCC & Dynamic Management Views using 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

DBA

Responsibilities:

• Install and configure workstation and windows server 2003.
• Desktop/Laptop, Network connectivity support to end users.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• 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 Win 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