SUMMARY

• Senior MS SQL Server DBA with 7+ years of IT experience in Database Administration, Design, Development, Installing and Support of MS SQL Server 2012/2008/R2/2005/2000 in Production, Testing and Development Environment’s.
• Experience in Data Migration from MS SQL server 2000/ /2008 R2.
• 2+ Years experience in Implementing, Upgrading, Migrating to SQL Server 2012
• Implemented AlwaysOn availability groups and replicas for reporting, backup and performance
• Expert in managing SQL Server in Physical and Virtual Environments
• Experience in implementing different types of Replication topologies involving Snapshot, and Transactional replication.
• Expert in monitoring SQL Server with Diagnostic Manager and FOGLIGHT tools
• Expert in Installing and configuring SQL Server Cluster in Active/Passive and Active/Active environments.
• Implemented Sync and Async MIRRORING for Disaster Recovery Implementation
• Implemented Backup and Restore in SQL Server using Native SQL Backups and also using Third party tools like Veritas NetBackup, Sandpiper, TSM and LITESPEED.
• Expert in using Ticketing and Change Management software.
• Expert in Using extensive SQL Server DMV's for performance tuning and Monitoring
• Experience in Performance Tuning, Query Optimization, Database Consistency Checks using DBCC Utilities, Linked Servers.
• Expert in implementing Full, Differential, Log and Compressed backups
• Experience in using different Transformation tools like DTS Packages, SSIS and also, BCP and BULK INSERT.
• Expert in Creating, Deploying, Scheduling solid ETL Packages in SSIS
• Experience in creating reports in SSRS and deploying in various servers
• Has good knowledge in implementing Log Shipping, Data Mirroring Techniques.
• Experience in Software Development Life Cycle (SDLC) and configuring Alerts using SQL Mail.
• Expertise in planning and implementing MS SQL server Security and database Permissions.
• Well aware of SOX compliance, SQL Server change control management and Reporting Services.
• Expert in T - SQL writing and developing Database Objects, Triggers, stored procedures, Functions and Views.
• Sound experience of writing POWERSHELL scripts
• Extensively involved in writing SQL queries (Sub queries and Join conditions), T-SQL programming and Query Level Performance tuning
• Experienced in Loading data into multiple tables using DB Management Tool like SQL*LOADER, Import /Export.
• Experienced in providing quality operational Support for Production Environments
• Provided 24/7 database maintenance and production support.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2012/2008 R2/2005/2000 Oracle (9i, 10g), MYSQL

Virtualization / SAN Technology: VMware, Hyper-V

Version Control / Change Management: Visual Source Safe, Team Foundation Server

Languages: C, C++, Shell Script, T-SQL and PL/SQL POWERSHELL

Reporting Tools: SSRS, Crystal Reports 8.5 and VB, Business Objects

Operating Systems: UNIX, Ms-Dos, Ms-Windows (98, 2000 and XP), Windows NT 2000 Advanced Server, Windows Server 2000/2003/2008 R2, Solaris and AIX.

ETL/Data Modeling: DTS, SSIS and Informatica, erwin

Other Tools: IDEARA Diagnostic Manager, Foglight, Red Gate SQL Compare, Toad, SQL Profiler, Query Analyzer, SSIS, ERWIN,VERITAS NetBackup, LiteSpeed, JDBC, TSM, and Sharepoint.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Senior SQL SERVER DBA

Responsibilities:

• Production support for SQL server environment.
• Managed SQL Servers in HA and DR environments
• Installing and configuring of SQL Server 2012 and 2008R2.
• Performed upgrade and Migration of lower version SQL Servers to SQL 2012
• Installed/Configured SQL Server 2012 AlwaysON availability groups for high availability
• Configured and maintained database mirroring for high availability.
• Implemented different types of Replication Models like Snapshot and Transactional.
• Extensively worked on Dynamic Management Views (DMV’s).
• Migrated SQL Server 2000 to SQL Server 2008/2008R2 and SQL Server 2005 to SQL Server 2008/2008R2 which include installing of SQL Server.
• Patched server with latest SQL Server service packs and Cumulative updates.
• Managed Microsoft Active\Active and Active\Passive Clustered SQL Server 2000, 2005 and 2008/R2 environments.
• Installed and Implemented Async and Sync Mirroring / Log Shipping for Disaster Recovery
• Performed DBCC utilities and fixed data corruption in User databases.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Created and managed schema objects such as tables, views, indexes, procedures, and triggers & maintained Referential Integrity.
• Implemented POWERSHELL Scripts for Database Administration
• Performed Server & Application fine-tuning & troubleshooting.
• Monitored MS SQL Server performance and network issues.
• Expertise in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Developed, deployed and monitored SSIS Packages tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application including upgrading DTS to SSIS.
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
• Monitored Databases for lock escalation, dead Lock, resource utilization by sessions, package caching, buffer pool hit-ratios, Captured long running SQL/runaway queries.
• Maintained Log Shipping, Mirroring and SRDF for disaster recovery.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• Controlled user access rights, and managed data security.
• Involved in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using DMV’s, Wizards and SQL Profiler.
• Implemented Backup and Restore in SQL Server using Third party tool VERITAS Net Backup, SRDF, TSM and LITESPEED.
• Involved in 24x7 on call support.

Environment: MS SQL Server 2000/20 R2/2012, Windows 2000/2003/2008 R2, VERITAS Net Backup, TSQL, Litespeed, SQL Job Manager, TSM, EG Monitoring.

Confidential, Abbott Park, IL

Senior SQL SERVER DBA

Responsibilities:

• Production support for SQL server environment.
• Configured and maintained database mirroring and Log shipping for high availability.
• Implemented different types of Replication Models like Snapshot, Transactional and Merge.
• Extensively worked on Dynamic Management Views (DMV’s).
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Expertise in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.
• Migrated SQL Server 2000 to SQL Server 2005\2008 and SQL Server 2005 to SQL Server 2008.
• Applied SQL Server service packs and Cumulative updates based on the errors and flaws that are found in the application.
• Managed Microsoft Active\Active and Active\Passive Clustered SQL Server 2000, 2005 and 2008 environments.
• Managed the use of disk space, memory and connections.
• Performed DBCC utilities and fixed data corruption in application databases.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Created and managed schema objects such as tables, views, indexes, procedures, triggers & maintained Referential Integrity.
• Performed Server & Application fine-tuning & troubleshooting.
• Monitored MS SQL Server performance and network issues.
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
• Maintained log shipping for disaster recovery.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• Controlled user access rights, and managed data security.
• Involved in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using DMV’s, Wizards and SQL Profiler.
• Implemented Backup and Restore in SQL Server using Third party tools like Veritas NetBackup, LITESPEED and Sandpiper.
• Maintained multiple instances SQL Servers with maximum availability.
• Involved in 24x7 on call support.

Environment: MS SQL Server 2000/2005/2008 , Windows 2000/2003/2008 , IIS 6.0, VERITAS Net Backup, TSQL,VB.NET, Sandpiper, IBM TSM, Litespeed, SQL Job Manager, BMC Patrol.

Confidential, ST Louis, MO

SQL SERVER DBA

Responsibilities:

• Production support for SQL server environment.
• Responsible for Query optimization and Performance tuning.
• Rebuilding of indexes to improve data retrieval performance
• Managed Microsoft Clustered SQL Server 2005 and 2008 environments.
• Involved in Migration from SQL 2005 to SQL 2008.
• Managing server logins, database users and permissions.
• Created Clustered Indices and Non-Clustered Indices to increase the performance of database.
• Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps.
• Worked on Data Partitioning and Snapshot Isolation in SQL Server 2008.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.
• Used the SQL server integration services (SSIS) as a part top transfer logins from SQL server and to move data from one server to another server.
• Configuration and Administration of IIS 6.0, Windows 2003 server.
• Used DBCC commands to check physical and logical consistency of the databases
• Involved in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using Wizards and SQL Profiler
• Involved in coding complex stored procedures and debugging for optimum performance
• Implemented Backup and restore in SQL Server using Third party tool Idera SQL safe.
• Maintained multiple instances SQL Servers with maximum availability.
• Involved in 24x7 on call support.

Environment: MS SQL Server 2005/2008,Windows 2005/2008,Siebel,IIS 6.0, Data Warehousing, SQL SAFE, TSQL,VB.NET, Snap Manager, SQL Job Manager.

Confidential, New York, NY

SQL Server DBA

Responsibilities:

• Daily responsibilities include administration and monitoring of Database servers.
• Fine tuned and Monitored SQL Servers in Web based and Transaction intensive environments. Implemented Active/Passive, Active/Active SQL Server Cluster servers.
• Used Activity monitor and SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Created Users and Roles, and managed security and permission of database
• Involved in Migration from SQL 2000 to SQL 2005.
• Implemented and Monitored Transactional Replication in SQL Server 2005
• Tuning database and SQL statements for optimal performance.
• Created SQL Server Jobs to automate the running of routine tasks such as backups, restores.
• Monitored Databases for lock escalation, dead Lock, resource utilization by sessions, package caching, buffer pool hit-ratios, Captured long running SQL/runaway queries.
• Maintained log shipping for disaster recovery.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• Transferred logins and passwords between instances of SQL Server 2005.
• Monitoring the event logs and Server error logs for troubleshooting purposes.
• Created various maintenance plans for the regular databases maintenance jobs in the SQL server.
• Used different kinds of SSIS packages in order to move the data from one server to another.
• Providing Mentoring and guidance to the other staff personnel and help desk on database related issues.

Environment: MS SQL Server 2000/2005, Windows 2000/2003 servers, IIS 5.0,VB.Net,T-SQL, Replication, Outlook Express, MS Access.

Confidential

SQL Server DBA

Responsibilities:

• Responsible for Query optimization and Performance tuning.
• Involved in Data Migration from SQL 2000 to SQL 2005.
• Implemented database mirroring as a part of disaster recovery plan.
• Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database.
• Used DBCC commands to check physical and logical consistency of the databases and to rebuild indexes.
• Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps.
• Used DTS and SQL server integration services as part of creating the jobs on the server.
• Configuration and Administration of Windows 2000 and Windows 2003 server.
• Used DBCC commands to check physical and logical consistency of the databases.
• Involved in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using Wizards and SQL Profiler.
• Managed the use of disk space, memory and connections.
• Performed DBCC utilities and fixed data corruption in application databases.
• Involved in coding complex stored procedures and debugging for optimum performance
• Involved with the integration of SQL Server on a Storage Area Network (SAN) platform.
• Managed replication issues during DDL changes over data in Production\development servers.
• Implemented transactional replication model and involved in maintenance of the replication.
• Implemented Backup and restore in SQL Server 2005.
• Maintained multiple instances SQL Servers with maximum availability.

Environment: MS SQL Server 2000/2005, Windows 2000/2003, IIS 5.0, SAN, .NET, Excel, TSQL, Replication, SSIS.