SUMMARY

• Senior MS SQL Server DBA with 9+ years of IT experience in Database Administration, Design, Development, Installing and Support of MS SQL Server 2012/2008/R 2/2005/2000/7.0 in Production, Testing and Development Environment’s.
• Experience in Data Migration from MS SQL server 2000/ /2008 R2.
• Implemented SQL Server 2012 in Beta/Test Version
• Experience in implementing different types of Replication topologies involving Snapshot, Merge, Transactional and updatable.
• 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 skills in VMware and Virtual environments
• Experience in Performance Tuning, Query Optimization, Database Consistency Checks using DBCC Utilities, Linked Servers.
• 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
• 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.
• Experience in developing and supporting all stages of systems life cycle including Analysis, Development, Testing, Implementation and Product Support using T - SQL, PL/SQL on Unix and Windows environment
• Expert in T-SQL writing and developing Database Objects, Triggers, stored procedures, Functions and Views.
• Expert in Using extensive SQL Server DMV's for performance tuning and Monitoring
• Sound experience of writing POWERSHELL scripts
• Developed Oracle based (SQL and PL/SQL) programs for the creation of ad hoc queries/reports, including requirements gathering, design, coding and unit testing.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), T-SQL programming and Query Level Performance tuning
• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, Triggers, Packages, Stored procedures, roles and granting privileges
• Proficient in Oracle tools such as TOAD and SQL Navigator
• 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).Requirements definition, Systems Analysis and DesignSSAS and Oracle Designer.Business Process ReengineeringSQL*Plus and Visual Studio.

Languages: C, C++, Shell Script, T-SQL and PL/SQL POWERSHELLKnowledge of Corporate Information FactorySSRS, 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.

Other Tools: Toad, SQL Profiler, Query Analyzer, SSIS, ERWIN,VERITAS NetBackup, Sandpiper, MS Office 2000/XP/2003, LiteSpeed, JDBC, TSM, ODBC, OSQL and Shareplex.

PROFESSIONAL EXPERIENCE

Confidential, CT

Senior SQL SERVER DBA

Responsibilities:

• Production support for SQL server environment.
• Installing and configuring of SQL Server 2012 and 2008R2.
• 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.
• Maintained multiple instances SQL Servers with maximum availability.
• 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, Bridgewater, NJ

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.
• 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.
• 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, Los angeles, cA

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, Raleigh, NC

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.

Confidential

Junior SQL Server DBA

Responsibilities:

• Installation and configuration of SQL Server 2000/2005 on Window 2000/NT OS.
• Implementing Backups and Restoring when necessary.
• Used BCP utility to publish table output to text files.
• Developed DTS Packages to transfer the data between SQL Server database and files.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Managing of users including creation/alteration, grant of system/dbroles and permission on various database objects.
• Extensively Developed SQL scripts for maintaining administration tasks.
• Actively participated in gathering of User Requirement and System Specification.
• Filtered bad data using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created reports from database onto excel spread sheet using DTS.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.

Environment: SQL Server 2000/2005, Windows NT server, T-SQL, Enterprise Manager, Windows 2K, SQL Profiler, DTS, BCP