SUMMARY:

• Over 8 years of experience in SQL Database Administration, Development, System Analysis, Design and support of MS SQL Servers 2012,2008R2,2008,2005,2000 in production, QA, Development environments.
• Highly experienced in installing, configuring and administering the SQL Server 2012/2008/2005/2000 in both standalone and clustered environment.
• Extensive knowledge in architecting, designing and administrating in multi node clustering with Active/Active, Active/Passive Architecture.
• Extensive experience in space allocation, database migrations, upgrade and database security.
• Extensive experience with SQL Server High Availability and Disaster Recovery strategies.
• Experienced in Configuring, Implementing and Maintaining Database Mirroring in both synchronous and asynchronous modes.
• Good Knowledge in implementing different Replication Models using snapshot, transaction and merge replication with different topologies.
• Experienced in Configuring, Implementation and Maintenance of Log Shipping for disaster recovery.
• Extensive experience with backup and Restore methodologies using Native and third party tools (LITE SPEED, NetBackup, and Red Gate).
• Extracted, transformed and loaded data from various heterogeneous data sources like Access, Excel, CSV, Oracle, flat file, Text Format Data using DTS & SSIS packages.
• Experienced with administration and development in BI environment in MS SQL Server 2005/2008/2012 in SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS).
• Experience in performance tuning and troubleshooting performance issues using native third party tools like Foglight.
• Strong in 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 monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Tuned SQL Queries by examining execution plans, creating plan guides, adding hint words, tuning indexes.
• Developing SQL Scripts for maintaining administration tasks.
• Expert in Database Design activities including Data Files and File group organization, Capacity Planning, Data partitioning and Data Normalization.
• Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Created Linked Servers between SQL Server, Oracle and other OLEDB data sources.
• Documented Disaster Recovery Plans and Participated In Disaster Recovery Drills.
• Experienced in creating Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail.
• Good knowledge and working exposure in Storage Concepts of RAID levels and SAN environment and NAS.
• Well experienced in virtualized environment.

TECHNICAL SKILLS:

Databases: SQL server 2012/2008/2005/2000, Oracle 9i, 8i, 10g MS Access

O/S: Windows 2003 server 32 - bit/64-bit.Windows 2008/2012 Server 64-bit, Linux

Languages: SQL, PL/SQL, VB.NET, VB Script, Java1.2, Java script

Web Technologies: ASP.NET, HTML, DHTML, XML, IIS 6.0

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

SQL server DBA/Developer

Responsibilities:

• Installing and configuring SQL server 2012 on Windows servers in Clustered and Standalone environments.
• Implementing high availability with AlwaysOn Availability groups and failover clustering.
• Designing and implementing Disaster Recovery using Log Shipping and maintaining DR servers
• Involved in setting up transactional replication and snapshot replication.
• Configuring and maintaining Server-Level/User-Level Security Strategy, Authentication Modes, configure database Logins/Users across various environments.
• Contributed to automation of many daily administrative activities like backups, restores, thresholds, monitoring server resources and proactive problem diagnosis.
• Worked extensively on TFS databases and red gate source control.
• Automating and maintaining data base object deployments and monthly releases.
• Refactoring and performance tuning of slow stored procedures.
• Developing stored procedures for monitoring various server instances like disk space monitor.
• Developed database backups and restore scripts and automated the process.
• Creating and designing new Database structures and tables.
• Worked extensively on SSDT jobs.
• Scripting the Database Consistency Checks, and scheduling them to run on daily and weekly basis.
• Creating and maintaining various SQL agent jobs.
• Working on various data transformations, data import and exports using ETL, SSIS Packages.
• Developed SSIS packages to export data from OLTP database to OLAP database.
• Worked extensively on tools like SQL Delta
• Worked on automating source control builds
• Worked on migrating and upgrading SQL servers from .
• Provided Level 3 support.
• Monitored database quality including database consistency check with DBCC, Defrag, and Index tuning and monitored error logs.
• Worked extensively on data maintenance like re-indexing, integrity checking, and database shrinking.
• SQL Query Performance Tuning, system Performance Analysis, analyzing the Query Execution Plans, Used SQL Profiler for optimizing the store procedure.
• Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction
• Worked with storage and network administrators to plan and estimate drive space and storage needs throughout the environment.

Environment: Windows Server2008/2012, SQL Server 2012/2008 SSRS, SSIS, IIS, CSS, HTML,.Net Framework 2.0, VB.Net, C#, ASP.Net, ADO.Net, Quest LITE Speed, SQL Delta, Red Gate Source Control.

Confidential, Columbus, OH

SQL server DBA

Responsibilities:

• Installed and configured SQL Server 2008/2012 on WINDOWS 2008 servers, applied service packs and security fixes in Clustered and Standalone environments.
• Implemented high availability solutions for mission critical SQL Server databases with clustering and Mirroring.
• Configured Snapshot and Transaction Replication from Production to DR Servers and Reporting Server with Multiple subscribers.
• Maintaining servers in data centres.
• Supported production servers in Fail over cluster environment.
• Monitored database quality including database consistency check with DBCC, Defrag, and Index tuning and monitored error logs.
• 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.
• Verified 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.
• Designed and implemented Disaster Recovery site using SQL SERVER Log Shipping.
• Used 3rd party tools like Quest LiteSpeed in taking the backups to optimize performance and restoring.
• Involved in maintenance and configuration of Database Servers to connect with SAN Storage Environment.
• 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, Informatica.
• SQL Query Performance Tuning, system Performance Analysis, analyzing the Query Execution Plans, Used SQL Profiler for optimizing the store procedure.
• Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction
• Monitor and tune both server and databases using DBCC, Server configurations options (sp configure) and Database options (sp dboption). Contributed to automation of many daily administrative activities like backups, thresholds, monitoring server resources and proactive problem diagnosis.
• Developed SSIS packages to export data from OLTP database to OLAP database.
• Responsible for Physical Storage Structures and Index Design and Tuning.
• Configuring Server-Level/User-Level Security Strategy, Authentication Modes, configure database Logins/Users.

Environment: Windows Server 2003, Windows Server2008, SQL Server 2012/2008/2005/2000, SSRS, SSIS, Internet Information Server 6, Java, CSS, HTML,.Net Framework 2.0, VB.Net, C#, ASP.Net, ADO.Net, Quest LITE Speed, Informatica, Cognos 8.4.

Confidential, Lake Success, NY

MS SQL DBA/Developer

Responsibilities:

• Upgraded several databases from SQL Server 2005 environment to SQL Server 2008.
• Configured Policy-based Management to enforce policies across SQL Server Enterprise.
• Performed Back-up, Restoration of Databases in Full Recovery &Bulk-Logged modes.
• Configured Database mirroring, multi-instance SQL Server clusters as part of high availability solutions for mission critical database Servers.
• Monitored 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.
• Implemented table and index partitioning to resolve performance issues.
• Verified 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.
• Performance Tuning of the SQL Server (in OLTP, Web based, Production and Development environments) including the usage of Performance Monitor and Profiler Trace to monitor the Memory, CPU and Disk usage.
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency.
• Using Views, Triggers, and Stored Procedures for updating and cleaning the existing data and also the new data.
• Created and deployed and scheduled report using SSRS.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Established relationships and worked closely with application development teams.
• 24 X 7 Production Database On Call Support.

Environment: MS SQL Server 2008/2005,PL/SQL, SSIS, SSRS, SQL Profiler, SQL Server Agent MS Excel,6.0, .Net, Java, Tivoli, Foglight, SQL Litespeed and Crystal Reports.

Confidential, NYC, NY

MS SQL DBA

Responsibilities:

• Installing, configuring and deploying SQL Server 2005 and 2008 in Clustered and non-clustered environment.
• Migrated from SQL Server 2000/2005 to SQL Server 2005/2008.
• 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 Lite Speed in taking the backups to optimize performance and restoring.
• 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 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.
• Used SQL Profiler to find badly performing queries and deadlocks.
• Developed SSIS packages to export data from OLTP database to OLAP database.
• Configured and worked on SSRS.
• Created Indexes to speed up the queries and Performed Database Normalization.

Environment: MS SQL Server 2000/2005/2008, Windows Enterprises 2003/2008 servers, IIS Web server, Toad for SQL Server, Lite Speed, JavaScript, CSS,HTML, SSIS, SSRS, NetBackup,SYBASE,C#,VB.Net, ASP.Net.

Confidential

MS SQL DBA

Responsibilities:

• Installed SQL server 2008 based on the Requirements.
• Migrated databases from SQL server 2005 to SQL server 2008.
• Installed SQL Server (Active/Active, Active/Passive) in Clustered and non-clustered environment with multiple instances.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Performed Back-up, Restoration of Databases in Full Recovery &Bulk-Logged modes.
• Creating Replication, Log shipping and mirroring for different Applications.
• Performance Monitoring & Tuning is done and identified the Reasons for Slow-Running of the System. Ran Trace.
• Done the Troubleshooting work and rectified the bottlenecks to achieve High Availability.
• Monitor and tune both server and databases using DBCC, Server configurations options (sp configure) and Database options (sp dboption). Contributed to automation of many daily administrative activities like backups, thresholds, monitoring server resources and proactive problem diagnosis.
• Resolved blocking issues in databases.
• Created indexes, updated index statistics and rebuild indexes.
• Created SSIS packages to transfer the data from development to testing and production.
• Migrated from DTS packages to SSIS packages.
• Reporting Services are performed using SSRS as and when required by the Company.
• Created Linked Servers between SQL Server 2005 and Oracle 9i.
• Extensively worked on PL/SQL programming to develop database triggers, stored procedures to populate tables into one of the Oracle databases
• Created maintenance plans for user and system databases.
• Designed and implemented capacity planning module to make future projections in terms of system resources
• Supported on call 24/7 on rotational basis

Environment: MS SQL Server 2005/2008, Windows Enterprises 2008 servers, Toad for SQL Server, SSIS,SSRS, Oracle 9i.

Confidential

MS SQL DBA

Responsibilities:

• Installing and configuring SQL Server 2000 and 2005.
• Created and scheduled jobs to setup log shipping between production servers.
• Creating databases and logins with permissions in SQL Server 2005 as per the developer’s request.
• Created Linked Servers between SQL server 2000 and 2005 servers.
• Involved in Migration from SQL Server .
• Restore Development and Staging databases from production backups as per the requirement.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL server, locks and indexes configurations, administering SQL server security.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Prepare daily report on the job failures, backup failures and disk space.
• Monitoring disk space and system performance monitor daily for the best performance of the servers.
• Involved in resolving dead lock issues and performance issues.

Environment: MS SQL Server 2000/2005, Windows 2000/2003 servers, Outlook Express, .NET, MS Access, Crystal Reports.