SUMMARY

• Over 8 years of experience as SQL server 2012/2008R2/2005/2000 Wif Telecom, Banking and Health Care sectors.
• Experience in supporting Very Large databases (VLDB) and troubleshooting teh problems.
• Experience in writing Stored Procedures, User Defined Functions, Cursors and Triggers.
• Experience in extracting and transforming data using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
• Experience in maintaining teh security for databases (creating logins for users, roles, and assigning permissions to them).
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Expert in performance tuning and handling blocking situation and dead lock situations.
• Used third party Quest tools like spot light and fog light and Lite speed for backing up large databases.
• Experience in Migrating SQL Server 2000 to SQL Server 2005 and 2008 to 2012.
• Experience wif concepts like data partitioning, online indexing, DDL triggers, DMV, DMF, DTA, SSIS and performance dash board.
• Experience in creating jobs, alerts and automating them.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC utilities and Index Tuning Wizard.
• Intensive experience in monitoring database performance using SQL Profiler and Windows Performance Monitor.
• Expertise and Interest include Administration, Development, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
• Performed Log Shipping and implemented Transactional and Snapshot Replication as high availability techniques.
• Experience in Database Mirroring as disaster recovery solution.
• Good experience wif Integration, Reporting and Analysis Services.
• Experience in developing ASP.NET websites using VB.NET, C#.
• Experience in Data Modeling (logical modeling and physical modeling) using Erwin.
• Excellent communication, analytical and inter personal skills and ability to learn new concepts.

TECHNICAL SKILLS

Languages: C# ASP. NET, T - SQL, My SQL, VB.NET, HTML, XML, C/C++, CSS, DHTML, Java Script

Operating Systems: Windows 95/2000/2003/2008/XP/VISTA/7, Sun Solaris 9, LINUX, VMware ESX servers

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

ETL & Reporting Tools: DTS, SSIS, SSRS, SSAS, Crystal Reports

DB Utilities: SQL Server Management Utility, Query Analyzer

Application Software: Visual Studio 2005/2008, Visual Source Safe, TFS, MS Office Suite

Tools: SQL DB Access, Performance Monitor, Backup Utility, SQL LiteSpeed, Visio 2000, Red Gate, Fog Lite.

PROFESSIONAL EXPERIENCE

Confidential

SQL Server DBA

Responsibilities:

• Worked extensively on installation and configuration of MS SQL Server 2005 /2008 /2008 R2 / 2012 on standalone and clustered Environments.
• Involved in migration of MS SQL Server 2005/2008 to MS SQL Server 2012.
• Handled clustering between two Production Servers and performed daily backups and developed recovery procedures.
• Experience in teh field of Unit Testing, has tested codes of T-SQL and SSIS packages in teh testing environment.
• Configured DB mail for sending automatic mails to respective people when SSIS process fails.
• Migrated DTS packages to SSIS 2005 packages.
• Administered teh MS SQL Server by creating User Logins wif appropriate Roles, dropping and locking teh logins, monitoring teh User Accounts, granting and privileges to users.
• Scheduled teh Backups for Databases and performed Restoration operations.
• Created, built and deployed successfully SSIS packages by using BIDS.
• Created SSIS packages to validate, extract, transform and load data from Oracle into SQL Server database.
• Implemented and Maintaining Replication.
• Generate every day morning Replication reports from branch SQL Servers and Resolve Issues.
• Created jobs and scheduled jobs according to Requirements.
• Assisted in Deploying 2 NODE failover clustering.
• Implemented Transactional Replication between Primary and Secondary Servers.
• Created Databases, Tables, Indexes and Views.
• Created Linked Server between SQL Servers.
• Implemented SQL Server Clustering on VM Ware.
• Configured Mirroring and Transactional Log Shipping between Primary and Secondary Servers depending on teh business requirements.
• Worked wif SQL Server Profiler to Generate Traces.
• Developed documentation that sufficiently describes technical deliverable as required for internal controls so that teh maintenance responsibility can be passed on to production support team.
• Continuous monitoring server health wif Idera.

Environment: MS SQL Server 2008/2005/2000, Windows 2000/2003/2005/2008/2012, SSRS, SSIS, MS Access, MS Excel VMware, MS Access, SQL Server Reporting Services and Integration Services.

Confidential, Pittsburg, PA

SQL Server DBA

Responsibilities:

• Installation and Maintenance of SQL Server 2008 R2 on Test, Development and Production Environments.
• Usage of new compression Techniques in SQL Server 2008 R2 for backup and restore jobs.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
• Creating Logins and Roles wif appropriate permissions.
• Creating and Maintaining Database Maintenance Plans.
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Tune slow running queries using SQL Server Profiler.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Plan, analyze and develop Ad-hoc Reports using SQL Server Reporting Services (SSRS) and Report Manager to support various user requirements.
• Create and manage database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to implement Business Logic.
• Create Clustered and Non-Clustered Indexes to improve teh performance of database access.
• Create and manage databases across Development and Production instances using SQL Server Management Studio.
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• Involved in Logical and Physical Data Modeling process using MS Visio.
• Use MS Visual Source Safe as a Version Control System.
• Involved in Change Data Capture process.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.

Environment: TSQL,MS SQL SERVER 2000/2005/2008,SSRS, QUERY ANALYSER, VISUAL STUDIO 2005, VB.NET, C#, WINOWS SERVER 2008, IIS, SSAS.

Confidential, Pittsburg, PA

SQL Server DBA

Responsibilities:

• Managed and Administrated theSQL Server 2008/2005/2000 production and Non-production servers.
• Installation ofSQL Server 2008/05onWindows Server Clustered environment.
• Migrated SQL Server 2000 databasestoSQL Server 2005 databasesincludingDTS to SSIS packages.
• Extensively workedon Profiler, Perfmon, DMVs, DMFs and DTAto tune teh databases, servers and query tuning.
• Managed Security usingSQL Logins, Roles and Security Modesfor various users.
• Rebuilding teh indexes on regular intervals and placing teh huge table/non-clustered indexon theseparate file group to improve teh performance.
• Optimized teh query performance wif modification inTSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins,creating usefulclustered indexandnon-clustered indexes.
• Developed and created teh new database objects including tables,views, index, stored procedures and functions, advanced queriesand also updated statistics using Query Analyzer and Enterprise Manager on teh existing servers.
• Analyze execution plans and generate suggestions for improvement.
• To set upSQL Server configuration settingsto resolve various resource allocation & memory issues for SQL Server databases and to setupideal memory, min/max server options.
• Configureddata partitioning/table partitioningon huge tables containing millions of rows for better performance.
• Used Change-data-capture (CDC) for capture changes on a daily basis.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas
• Supported24 X 7 Production environment

Environment: MS SQL Server 2008R2/2008/05/00, Windows 2008/2003 Server, C#.net, VB and ASP.NET, MS Visio, Microsoft Visual Studio 2008/2005, MS Business Intelligence Development Studio 2008, MS Access.

Confidential

SQL Server DBA

Responsibilities:

• Installation of SQL Server 2005, service packs, hot fixes, security patches.
• Worked on teh migration of SQL Server 2000 to SQL Server 2005.
• Used Data Partitioning, Snapshot Isolation in SQL Server 2005.
• Update statistics, database integrity check and Backup operations
• Generated reports from Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages.
• Designed and implemented comprehensive Backup plan and disaster recovery model.
• Worked extensively in Query Analyzer and Profiler for tuning queries using variable for characteristics and query costs.
• Created and modified Stored Procedures and Functions to generate reports.
• Used log shipping for synchronization of database.
• Configuring Perfmon, blocking analysis, enabling of AWE and PAE, Max degree Parallelism.
• Practical experience in managing teh internal and external MS SQL database security.

Environment: SQL Server 2005/2000 wif Clustering, Replication, T-SQL, Windows Server 2003 64-bit, Profiler, TFS.

Confidential

SQL Server DBA/Developer.

Responsibilities:

• Created Database tables wif constraints and relationships between multiple tables.
• Created Views, User Defined Functions and Triggers.
• Extensively used teh VB coding and HTML usage.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Administered teh MS SQL Server by creating user logins wif appropriate roles, dropping and locking teh logins, monitoring teh user accounts, creation of groups, granting teh privileges to users and groups.
• Responsible for creating Stored Procedures and Scheduled to run them by creating SQL Agent Jobs.
• Performed various data transfers between various servers using BCP and DTS.
• Supported team in resolving in DTS and T-SQL related issues.
• Involved in performance tuning and query optimization.
• Performed Database and Performance testing for teh database objects.
• Created backup/restore and disaster recovery plans for production servers.
• Backing and Restoring of Databases on Scheduled basis.
• Involved in documenting teh entire technical process.
• Supported technical teams involved wif MS SQL issues and operations.
• Involved in teh maintenance of teh database.

Environment: SQL Server 2000, Oracle 8i, VB 6.0, Windows 2000, Erwin, IIS 5.0, Crystal Reports 9.0 and Microsoft Reporting services 2.0.