Object: Senior SQL Server DBA with 9 plus years of experience in SQL Server administration, implementation and support. Hands-on in supporting SQL Servers 2000/2005/2008/2008 R2/2012 in investment banking, Insurance, ecommerce, andproperty preservationindustries. Offering solid track record based on professionalism, thoroughness, and dedication.Able to work both independently and as a team player and excellent communication, presentation and interpersonal skills.

Summary:

• Experience in configuring, and maintaining AlwaysOnAvailability Group and Failover cluster.
• Experience in PerformanceTuning, Backup and Recovery, Query Optimization and Security.
• Experience inUpgrade/Migration of MS SQL Server 2000/2005 to MSSQL Server 2008r2, 2012.
• Experience in monitoring the health and performance of everything from servers to individual applications using System Center Operations Manager.
• Experience in consolidate the package and the parameters for the project using ISPAC.
• Strong hands on T-SQL, stored procedures, tables, views, functions, triggers and indexes.
• Experience in creating and maintaining ETL routines as well as assisting with reporting needs.
• Experienced in installation of SCOM 2012 SQL and knowledgeable on all the new features.
• Strong hands on DTS packagesandconverting them to SSIS packages
• Experience with developing and maintaining complex SSIS, SSRS and SSAS Packages
• Experience in FDA Validation procedures required for Pharmaceutical Industry.
• Work with Financial, pharmaceutical and communication Industries.
• Acted as a production and developmentDBA.
• Experience in Using Performance Monitor/Profiler to resolve Dead Locksand Slow running Queries.
• Responsible for securingSQL Server,user management, assigning permissions and roles.
• Strong knowledge ofDatabase Mirroring, Hardware/Software Clustering and SAN technology.
• Acted as a system administrator of various Windows operating systems.
• Hands on experience on high availability SQL Server solutions, Replication and LogShipping.
• Hands on experience ofMicrosoft SharePoint 2007 and Microsoft SharePoint 2010.
• Installed, configured and maintained Microsoft Project server 2007 and 2010
• Experience in creating standard documentation for technical documentations.
• Excellent experience in working independently as well as in team-oriented environments.
• Involved in problem solving and conflict resolutions.
• Experience in supporting and maintaining huge databases and troubleshooting their problems.
• Excellent analytical, communication and interpersonal skills.

Technical Skills

Languages: T-SQL, PL/SQL, HTML, VB, .NET, C#, C++, and Java

ETL Tools: SSIS and Remedy MDM.

Data Model: Darwin 2.0, Erwin, and SSAS.

Reporting Tools: SSRS, Cognos, and Business Objects XI.

Backup Software: Litespeed, Redgate, SQLBackup, FTP, EMC, and TSM.

RDBMS & Tools: SQL Server 2000/2005/2008/2008 r2 and 2012, MS Access 2003/2007/2010 , Oracle 9.x, MySQL 5.0, Sybase, SQL Loader And Export/Import.

Operating System: Windows 95/98/XP/Vista and 7, MS-DOS,Windows NT/ 2000/2003/2008 and 2008r2 servers and UNIX.

Third Party Tools: DB Artisan, RedGate, Spotlight, and Idera.

DB Query Tools: MS SQL Server Query Analyzer, SQL Profiler, ETL,SQL Server Management Studio & Enterprise Manager, Alwayson.

PROFESSIONAL EXPERIENCE:

Confidential

Senior SQL Server DBA, Cleveland, OH

• Responsible for installing, configuring, and maintaining AlwaysOnAvailability Group and Failover cluster.
• Providing 24x7 dedicated production support for SQL Server problem resolution and server outages.
• Installed and configured MS SQL Server2005, 2008, 2008r2 and 2012 on Windows 2003, Windows 2008, and Windows Server 2008 R2 SP1and also applied service packs and security fixes on this MS SQL Servers.
• Responsible for a large scale of database migration from SQL server 2005 to SQL server 2008 r2 and 2012r2.
• Experience in automate common operations and design practices during the database lifecycles Using DacPac.
• Experience in consolidate the package and the parameters for the project using ISPAC.
• Experience in monitoring the health and performance of everything from servers to individual applications using System Center Operations Manager SCOM.
• Experienced in installation of SCOM 2012 SQL and knowledgeable on all the new features.
• Responsible for Creating T-SQL,stored procedures, tables, views, functions, triggers and indexes.
• Involved in database and log backups and restoration, planning backup strategies, and scheduling.
• Backing up master & system databases and restoring them when necessary.
• Rebuilding the Indexes at regular intervals for better performance.
• Verify backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary to work with technicians from other departments.
• Responsible for Installing, configuring and maintainingSQL Fail over clustering for two production environments.
• Involved in creating Logical & Physical Database Design using data model tool Erwin.
• Responsible for configuring andmaintaining Transactional, Snapshot and Merge replication inproduction environments.
• Installed, configured and deployed MS SharePoint server 2007 with SQL server 2005.
• Involve in ChangeManagement/Incident Management Process and using Remedy tool notifyrequests and open new requestsand update all records in work history.
• Using third party tool Red Gate,ensuring all the databases arebackingup on the regular basis and then restoring this databases on requests.
• Involved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
• Usingthird party tool Idera, monitor all the servers and their jobs in a singleManagement Console.
• Working with installation,configuration and creation of SSRS.
• Responsible forsecuringSQL Server,user management, and taking care of permissionsand roles.
• Working with DTS package to import and export operations in and out of the SQL Servers.
• Scheduling jobs and alerts using SQL Server Agent. Administrating Microsoft Operation Manager (MOM) 2005 in an existing IT infrastructure.

Confidential

Lead DBA, New York, NY

Responsibilities:

• Responsible for Installing and configuringSQL Server 2000, 2005 and 2008 on Windows 2000, 2003 and 2008 servers.
• Worked with SQL DBA team andSQL Developers to optimize the SQL queries and stored procedures.
• Installed and configured SQL server 2005 Reporting Services (SSRS),created user roles, managed security built reports and deployed them to production. Worked with configured SSRS to monitor all jobs on daily basis, fixed the failed jobs and re-ran them.
• Provided 24 X 7 dedicated supports to hundred and eight Production, development and clustered servers.
• Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.
• Created standard operation procedures (SOP) for initial database shell creations for specific customer package builds.
• Developed the metrics and trending processes for SQL database sizing and growth.
• Daily monitoring of two-node active-passive SQL cluster in a host environment.
• Applied service packs and security fixes for all SQL Servers, and provided database administration support.
• Involved in upgrading from SQL Server 2000 to SQL Server 2005 and from SQL Server 2005 to SQL Server 2008.
• Experience in automate common operations and design practices during the database lifecycles Using DacPac.
• Experience in consolidate the package and the parameters for the project using ISPAC.
• Performed the database backups for production, test and development environments.
• Created the backup and restore strategy for the all three environments.
• Worked with the database optimization, Performance tuning and index tuning for optimization of queries.
• Experience in monitoring the health and performance of everything from servers to individual applications using System Center Operations Manager SCOM.

Confidential

SQL server DBA, New York, MA

Responsibilities:

• Responsible for MS SQL Server and database administration.
• 24* 7 Critical production supports for hundred and ten SQL Servers out of which 75 were mission critical production support.
• Created database maintenance plan for SQL Server backups, optimization, integrity check and transaction log backups.
• Created checklistsfor proper install of SQL Server, applied service packs and security fix.
• Involved in validating SQL Servers, which was installed on validated environments.
• Configured and maintained transactional and Snapshot replication for 3 environments.
• Worked with SQL Disaster Recovery processes and documented those processes.
• Worked with capacity planning, database sizing and monitoring.
• Createddatabases, tables, indexes, stored procedures and triggers.
• Involved in creating DTS Packages to import and export operations in and out of SQL Servers.
• Improved SQL Server performance using the Windows performance monitor.
• Worked onuser administration and responsible for upgrading project from SQL Server 7and 2000 to SQL server 2005.
• Applied monthly patches and hot fixes
• Worked with application team to test the successful upgrade.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
• Created the Standards for SQL Server environment.
• Installed and configured SQL Server Analysis services(SSAS) for data warehousing projects.

Confidential

Database Admin, Columbus, Ohio

Responsibilities:

• Responsible for Logical & Physical database designing, implementing and Data Modeling.
• Involved in upgrading from SQL Server 7 to SQL Server 2000 and from SQL Server 2000 to SQL server 2005.
• Worked on database user administration and granted required privileges to users.
• Tuned Stored Procedures and SQL Queries.
• Performed performance analysis using CPU, I/O and memory counters using performance monitors.
• Experienced with converting Access database to the MS SQL Server environment.
• Configured and maintained the Transactional replication between the production environments.
• Scheduled database maintenance tasks to improve the database performance.
• Experienced in database backup and restore operations.
• Involved in maintaining database with maximum database availability, resolve any database issues.
• Created the BCP scripts file to export the data from text files to SQL Servers.
• Administered the Windows NT 4.0 Servers and local area networks.
• Worked with tuning and configuration of production and development database servers.
• Created the stored procedures, views and scripts for application development.
• Experienced with DBCC commands, to check physical and logical consistency of the databases.

Confidential

Database Administrator, Jersey City, NJ

Responsibilities:

• Installed and configured f SQL Server 2000/2005 and Service Packs on Windows 2000/2003 Servers
• Installed and configured 64 Bit SQL Server 2005 active\active cluster instances.
• Upgrading to SQL Server 2005 Servers from SQL Server 2000
• Database Loading through BCP, DTS and SSIS.
• Loading of large data between the databases
• Worked on Clustering Environment on SAN Environment
• Worked with System Admin team to check to make sure RAID configuration and also SAN configuration are properly done
• Used VPN client to support from home during weekends.
• Worked with Development team to help their issues and modifying the stored procedures and triggers
• Data Loading with SSIS, DTS , BCP and Bulk Insert tools
• Maintenance plan for full, differential, Transactional Backup and database recovery with experience of complex recovery scenarios.
• Used SSIS, SSAS Services in SQL Server 2005. Used Copy Database Wizard and other new features extensively in 2005.
• Responsible in managing Transaction Replication
• Worked with Active/Passive Clustering Environment
• Escalated critical issues regarding production servers to Microsoft
• Scheduling Backups and checking the Backups on regular basis