SUMMARY:

• Over 8 years of IT experience as SQL Server Database Administrator in DEV,STG and PROD environments in SQL server 2012/2008R2/2008/2005/2000.
• Highly experienced in installing, configuring and administering SQL Server 2012/2008/2005/2000.
• Upgraded and migrated several servers and databases from SQL Server 2000/2005/2008 to SQL Server 2005/2008/2008R2 and 2012.
• 24/7 On Call Support for Production servers.
• Extensive experience in Installation, Configuration and Administration for SQL Server in a Clustered and Non-Clustered environments.
• Extensive knowledge in architecting, designing and administrating in multi node clustering with Active/Active, Active/Passive Architecture.
• Experienced in Configuring, Implementing and Maintaining Database Mirroring.
• Good Knowledge in implementing Replication using different Replication Models Snapshot, Merge and Transactional with different topologies.
• Highly experienced in Configuration, Implementation, Maintenance and monitoring of Log Shipping.
• Good experience with Microsoft Team Foundation Server TFS .
• Highly experienced with Business Intelligence in MS SQL Server 2005/2008/2012 in SQL Server Reporting Services, SQL Server Analysis Services and SQL Server Integration Services.
• Expert in Database Design activities including Data Files and File group organization, Capacity Planning, Data partitioning and Data Normalization.
• Expertise in upgrading SQL servers using in place and side by side.
• Experience in capacity planning, performance tuning, and disaster recovery and troubleshot performance issues.
• Good knowledge and working experience in Storage Concepts of RAID levels, SAN and SRDF technologies.
• Experienced in Extraction, Transformation and Loading ETL process using DTS, SSIS.
• Highly experienced in migration of data using BCP Utility, Bulk Insert commands, SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard.
• Created Linked Servers for OLEDB Data Source and Native Data Sources.
• Experience in developing management reports using SSRS and Crystal Reports.
• Documented Disaster Recovery Plans and Participated In Disaster Recovery Drills.
• Tuned SQL Queries by examining execution plans, creating plan guides, adding hint words, tuning indexes.
• Highly experienced in creating Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail.
• Experienced in programming tasks - Stored Procedures, Triggers, and Cursors for SQL Server 2000/2005/2008.
• Strong in creating, monitoring and optimizing the performance of the Queries and Indexes using SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor and DBCC commands and Dynamic Management Views.
• Strong in analyzing Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Excellent problem solving, analytical, technical, interpersonal and communication skills with strong leadership abilities. Extremely diligent strong team player with an ability to take new roles.

TECHNICAL SKILLS:

• Platforms: Windows Me/XP/NT/2000 server/XP/2003/2005/2008 server/Vista
• Databases: SQL SERVER 2000/2005/2008/2012, MS-Access, Oracle,
• Programming Languages: SQL, PL/SQL, VB 6.0, VB.Net, C, C , VBScript
• Web Technologies: Asp.Net, HTML, DHTML, XML, IIS 6.0, Java Script
• Security Tools: Microsoft Baseline Security Analyzer MBSA , NGSSQuirreL for SQL
• Server, Scuba by Imperva
• Tools: SQL Server Management Studio / Enterprise Manager, SQL Navigator,
• SSRS, SSAS, SSIS, Enterprise Manager, SCCM, SSMS, Toad, Visual Studio 2005/2008, VERITAS, Quest Lite Speed, Red Gate, Excel Macro 2007/2003, SQL Assistant.

PROFESSIONAL EXPEREINCE

Confidential

Role: SQL server DBA

Responsibilities:

• Experience configuring and working MS SQL Server 2008 and MS SQL Server 2005 on VMware Environment.

• Installed SQL Server in stand-alone and clustered environments using SQL Server 2012 and SQL Server 2008R2 on 64 bit systems.
• Migrated SQL Server 2005 databases to SQL Server 2008R2 and SQL Server 2012 databases.
• Managed and administrated SQL Server 2012/2008R2 on production and non-production servers.
• Implemented and maintained Log Shipping as Disaster Recovery solution.
• Performed analysis for setting up a comprehensive Backup and Recovery strategy for SQL Servers using Native and Third party tools Litespeed .
• Performed day-to-day activities including full, differential and log backups scheduled backup jobs .
• Worked on point in time recovery and point of failure recovery.
• Implemented Partitioning on large tables to improve the performance.
• Involved in implementation of Always-On Availability Group as a High Availability solution on SQL Server 2012.
• Participated in a Failover drill to check the High Availability solution.
• Created Logins, Users and Proxy accounts with appropriate permissions and performed security management.
• Monitored database status including CPU, memory, I/O, space, and dead lock issues using SQL Server Utilities.
• Analyzed missing indexes on tables by using DMVs, Sp Blitz and Database Tuning advisor.
• Resolved Locks and Deadlocks by using DMVs, table hints and Activity Monitor to improve the performance.
• Developed and created the database objects including tables, views, indexes, stored procedures using T-SQL.
• Modified Stored Procedures and complex T-SQL queries to improve query execution.
• Participated in Optimizing, Tuning and identifying long queries using DMVs, Extended events and alert notifications.
• Created maintenance jobs for performance of SQL Server which includes updating statistics, database integrity checks and Index Rebuild.
• Experience in Database design, Performance Analysis, Production Support for VLDB and Complex Databases.
• Extensively used the native tools SQL Server Profiler, Activity Monitor, Index Tuning Wizard, Database Tuning Advisor and Event Viewer for performance analysis.

Confidential

Role: SQL Server DBA

Responsibilities:

• Implemented high availability solutions for mission critical SQL Server databases with clustering and Mirroring.
• SQL Server 2012 Always on Experience with high availability.
• Installed and configured SQL Server 2005, 2008 on Standalone and Clustered Environments
• Hands on experience with Clustering, Mirroring and Replication.
• Applied patches and service packs to keep the database at current patch level.
• Moved system databases from one location to another.
• Created Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail
• Involved in Administering the servers by creating User logins with appropriate roles, logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups
• Created list of SQL Server Agent jobs that are running on all SQL Servers and determine stored procedures, remote procedure call and SQL statements executed, in order to establish a strategy for improving current SQL Server performance.
• Created monitoring and optimizing the performance of the Queries and Indexes using SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor and DBCC commands and Dynamic Management Views.
• Configured Merge and Transaction Replication from Production to DR Servers and Reporting Server with Multiple subscribers on SQL server 2012
• Provide input into overall development/implementation plan and document database builds and changes, perform SQL DBs designs, table designs, and stored procedures work
• Lead data requirements, architecture review, and modeling sessions
• Set up new SQL Servers and configure required users and fixed orphan users with rev login
• Truncated/shrank transaction logs, Checked data allocation errors and any data inconsistencies and updating database statistics
• Wrote Job and SSIS Packages to transform data from SQL to Oracle and Oracle to SQL
• Performed Migration of SQL Server2005 to SQL Server 2008, SQL Server 2008 to SQL Server 2008R2
• Developed documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team
• Installed, Configure SSRS and Created and Deployed SSRS Packages
• Tested code in T-SQL and SSIS Packages in the testing environment
• Hands on experience with Quest LiteSpeed
• Hands on experience with Performance Tuning.
• Actively participated in gathering User Requirement and System Specification
• Data transfers between various servers using BCP and DTS
• Wrote stored procedures, views, triggers and functions

Environment: Windows Server 2003, Windows Server2008, Windows Server2008 R2, IIS, SQL Server 2008R2/2008/2005, SSRS, SSIS.

Confidential

Role: SQL DBA

Responsibilities:

• Involved in Administering the servers by creating User logins with appropriate roles, logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups
• Installed, Configure SSRS and Created and Deployed SSRS Packages
• Developed Tables, Graphs, Data sets and Visualization reports
• Wrote Job and SSIS Packages to transform data from SQL to Oracle and Oracle to SQL
• Installed and configured SQL Server 2008 on WINDOWS 2008 servers
• Created list of SQL Server Agent jobs that are running on all SQL Servers and determine stored procedures, remote procedure call and SQL statements executed, in order to establish a strategy for improving current SQL Server performance
• Implemented high availability solutions for mission critical SQL Server databases with clustering and Mirroring on SQL server 2012
• Configured Merge and Transaction Replication from Production to DR Servers and Reporting Server with Multiple subscribers on SQL server 2012
• Created policies in SQL 2008 R2
• Hands on experience with log shipping
• Implemented Snapshots Replication
• Worked on Power Pivot for fast manipulation of large data sets
• Set up new SQL Servers and configure required users and fixed orphan users with rev login
• Truncated/shrank transaction logs, Checked data allocation errors and any data inconsistencies and updating database statistics
• Developed documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team
• Tested code in T-SQL and SSIS Packages in the testing environment
• Actively participated in gathering User Requirement and System Specification
• Created, built and deployed SSIS Packages by using BIDS, and Migrated DTS Packages to SSIS 2005/2008 packages.
• Worked on Power View for interactive data exploration, visualization, and presentation
• Experienced in transparent data encryption TDE .
• Data transfers between various servers using BCP and DTS
• Wrote stored procedures, views, triggers and functions
• Installed and configured SQL Server 2005, 2008 on Standalone and Clustered Environments
• Created crystal reports for various township
• Develop web sites for various clients of Guidance using various technologies such as ASP.NET, HTML, XML/XSLT, CSS, JavaScript, Microsoft Commerce Server and SQL Server.
• Developed Website for Custom Fabric Flowers New York

Environment: Windows Server 2003, Windows Server2008, IIS, Microsoft Commerce Server, SQL Server 2012/2008R2/2008/2005, SSRS, Power Pivot, SSIS, SCCM, Red Gate, TFS, Internet Information Server 6,.Net Framework 2.0, VB.Net, C , ASP.Net, ADO.Net, Crystal Report.

Confidential

Role: SQL Server DBA / Developer

Responsibilities:

• Installed and configured SQL Server 2005, SQL Server 2008 on WINDOWS 2003/2008 servers, applied service packs and security fixes in Clustered and Standalone environments.
• Installed and configured SQL Server 2008R2 WINDOWS 2008 servers.
• Experienced in transparent data encryption TDE .
• Performed backup using backup compression and Data compression in SQL Server 2008
• Worked extensively on installation, upgrade and configuration of MS SQL Server 2008/2005 and 32/64 bit SQL Server Cluster for SQL 2008 and SQL 2005.
• Implemented high availability solutions for mission critical SQL Server databases with clustering and Mirroring.
• Responsible for defining the complete data warehouse architecture e.g. ODS, ETL process, Data Marts, EDW .
• Data warehouse technologies such as Data Quality, ETL, BI and DBMS.
• Direct and design the ETL process involving data quality and testing.
• Worked as a Data Analyst.
• Configured Merge and Transaction Replication from Production to DR Servers and Reporting Server with Multiple subscribers.
• Supported production servers in Fail over cluster environment.
• Hands on experience with log shipping
• Implemented Snapshots Replication
• Monitored database quality including g database consistency check with DBCC, Defrag, and Index tuning and monitored error logs.
• Hands on experience with Redgate SQL Backup
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Designed and populated reporting tables, views and stored procedures.
• Worked extensively on data maintenance like re-indexing, integrity checking, and database shrinking.
• Good experience with Microsoft Team Foundation Server.
• Worked on DB2 environment
• Good experience with DMV's
• Verify backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
• Respond to trouble tickets assigned to me and fix any database issues promptly.
• Designed and implemented Disaster Recovery site using SQL SERVER Log Shipping.
• Test Backup and Recovery Strategies by simulating various recovery scenarios like loss of data files, Transaction logs, read only table spaces, Point-in-time recovery through RESETLOGS.
• Used 3rd party tools like Quest LiteSpeed in taking the backups to optimize performance and restoring.
• Evaluate the peak and no peak usage pattern of the application effectively distribute database administration activities, such as full database backup and database defragmentation during no peak hours.
• Wrote Job and SSIS Packages to transform data from SQL to Oracle and Oracle to SQL
• Worked with Oracle development tool Red Gate
• Involved in maintenance and configuration of Database Servers to connect with SAN Storage Environment.
• Installed, Configure SSRS and Created and Deployed SSRS Packages
• Worked on Power Pivot for fast manipulation of large data sets
• Developed Tables, Graphs, Data sets and Visualization reports
• Created ETL packages with different data sources SQL Server, Flat Files, Excel source files, XML files etc and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Extensive experience in Deploying and maintaining SSIS Packages and SSRS Reports
• SQL Query Performance Tuning, system Performance Analysis, analyzing the Query Execution Plans, Used SQL Profiler for optimizing the store procedure.
• Developed SSIS packages to export data from OLTP database to OLAP database.
• Created, Built and deployed SSIS Packages by using BIDS, and Migrated DTS Packages to SSIS 2005/2008 packages
• Responsible for Physical Storage Structures and Index Design and Tuning.
• Worked with storage and network administrators to plan and estimate drive space and storage needs throughout the environment.
• Configuring Server-Level/User-Level Security Strategy, Authentication Modes, configure database Logins/Users.
• Created a role in Share point site for security purpose. Created various roles according to the user.

Environment: Windows Server 2003, Windows Server2008, SQL Server 2008R2/2008/2005/2000, SSRS, Power Pivot, SSIS, SCCM, Red Gate, TFS, Internet Information Server 6, JavaScript, CSS, HTML,.Net Framework 2.0, VB.Net, C , ASP.Net, ADO.Net, Quest LITE Speed.

Confidential

Role: SQL Server DBA

Responsibilities:

• Installing, configuring and deploying SQL Server 2005 and 2008 in Clustered and non-clustered environment.
• Created a role in Share point site for security purpose. Created various roles according to the user.
• Worked as a Data Analyst.
• Responsible for defining the complete data warehouse architecture.
• Direct and design the ETL process involving data quality and testing.
• Migrated from SQL Server 2000/2005 to SQL Server 2005/2008.
• Hands on experience with Redgate SQL Backup
• Configured security and access per SOX and PCI standards.
• Created Linked Servers for OLEDB Data Source and Native Sources.
• Responsible for creating, maintaining and monitoring mirrored servers, configured using synchronous and asynchronous updates with witness server.
• Created alerts, notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors, alerts, activity logs, error logs to capture any possible errors.
• Used 3rd party tools like Quest LiteSpeed in taking the backups to optimize performance and restoring.
• Good experience with DMV's
• Analyzed business requirements and build logical and Physical data models that describe all the data and relationships between the data.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity. Monitor database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Used SQL Profiler, Windows Performance Monitor and DB Artisan for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Implemented and Monitor the replication between two sites, support and maintenance of MS SQL Server Transactional Replication.
• Worked on fail over clustering and mirroring.
• Documentation of daily tasks and scripting them.
• Worked in 24X7 production support with a rotation basis.
• Involved in loading the Warehouse databases and performing maintenance tasks on these databases.
• Setup log shipping and troubleshooting log shipping errors when arises.
• Experience in implementing Failover Support for SQL Server with active/Active Cluster configuration.
• Built SSIS Packages to transfer data in and out of the Extract, Stage and Production Servers.
• Updated the multi-dimensional cube data using SSIS- Import/Export wizard.
• Created, Built and deployed SSIS Packages by using BIDS, and Migrated DTS Packages to SSIS 2005/2008 packages
• Used BCP command line utility to replicate a database.
• Used SQL Profiler to find badly performing queries and deadlocks.
• Created Dash board reports using COGNOS report studio.
• Developed SSIS packages to export data from OLTP database to OLAP database.
• Using Views, Triggers, and Stored Procedures for updating and cleaning the existing data and also the new data.
• Configured and worked on SSRS.
• Extensive experience in Deploying and maintaining SSIS Packages and SSRS Reports
• Created Indexes to speed up the queries and Performed Database Normalization.

Environment: MS SQL Server 2000/2005, Windows Enterprises 2003 servers, IIS Web server, Toad for SQL Server, LiteSpeed, Red Gate, JavaScript, CSS,HTML, SSIS, SSRS,VERITAS NetBackup,SYBASE,C ,VB.Net, ASP.Net.