SUMMARY

• Hands - On experience as SQL Server DBA (2016, 2014, 2012, 2008, 2005) in Production, Development, Staging, Data Warehouse environments.
• Hands-on experience wif Installation/Configuration, Managing and Troubleshooting of MS SQL Server 2016/2014/2012/2008 R2/2008/2005 on Windows Server 2012 R 2/2008/2003.
• Hand-On experience of Multiple Nodes on Cluster Environments.
• Setting up and monitored Disaster Recovery environments like Database Mirroring wif in teh Primary Data center servers and Log Shipping between primary and secondary Data center servers including Mirroring conjunction wif Log Shipping.
• Successfully performed MS SQL Server upgrades from 2008 R2 to 2012 Always-On
• Performed Data Transfer/Migration using Export/Import and Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Created Database Snapshots on Mirror Databases for generating teh reports for business crew members and worked wif Linked Servers.
• Data Migration between different environments and third party databases.
• Configured and monitored Replication for Reporting purpose.
• Troubleshooting Mirroring, Log shipping and replication synchronization issues.
• Troubleshooting Application and Backup jobs.
• Create and maintain SQL Agent Jobs.
• Hands-On Upgrade of SSIS Packages.
• Experience on installation of SSRS & SSAS Services.
• Working noledge in Reporting Services (SSRS).
• Experience on Database Encryption TDE
• Good noledge in using DMVs and DMFs in resolving Performance Issues.
• Experience in providing Logging by using Event Handler for SSIS Packages.
• Experience in Query Optimization, Database Consistency Checks using DBCC Utilities, analyzing teh Execution Plan and Index Management for better Query Optimization.
• Experienced working on SQL Servers Virtual Environments.
• Experience in scheduling Backups and Restore and Maintenance plans using Native & Third-party tools.
• Experience in T-SQL Development skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Queries.
• Documented Database environment, Escalation procedures, issues, Installation procedures, Disaster Recovery Procedures in Database Management Prod Guide.
• Daily routine DBA tasks like handling user’s permissions and space issues on production and semi production Server’s and handling maintenance jobs.
• Good at SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Closely worked wif development team to assist them in various problems solving and troubleshooting web-based applications, which calls various Database objects.

TECHNICAL SKILLS

Databases: MS-SQL Server 2016/2014/ 2012/2008/2005.

Languages: T-SQL.

SQL Server Tools: Index Tuning Wizard, Database Tuning Wizard, Export & Import.

Backup Tools: SQL Native, CommVault, Red Gate.

Performance Tools: Perfmon, SQL Profiler.

Operating systems: Windows Server 2012R 2/ 2008/2003/2000, UNIX.

Software Packages: MS Office 2003, 2007, Visio.

Monitoring Tools: SQL Sentry, Red Gate, Idera.

PROFESSIONAL EXPERIENCE

Confidential, Redwood city, CA

SQL DBA

Responsibilities:

• Working as a support lead by managing off-shore team.
• Installed and administered SQL Server 2016/2014/2012.
• Migration SQL 2008R2 to 2016.
• Involved in Capacity Management and Analysis at hardware of teh SQL Server including CPU, Memory and Storage.
• Implemented High Availability strategies like Always-On, Database Mirroring, Clustering Replication and Log Shipping.
• Managed Cluster environment in both Active/Active and Active/Passive.
• Performed routine maintenance activity, performance tuning.
• Creating database loads to be uploaded into teh system.
• Implemented Secure Operation like Backup Policy, Strong Passwords, cross database ownership changing, disabling XP CMDSHELL etc.
• Backup and restoring databases from production to Development for testing.
• Involved in performance tuning wif stored procedure and T-SQL having high response time.
• Designed and implemented comprehensive Backup plans and disaster recovery strategies.
• Applying patched and hot fixes.
• Used SQL Profiler to capture teh activities of teh databases and used teh trace file as workload file to teh Database Tuning Advisor for index recommendations.
• Involved in SourceData Analysis, analysis and designing mappings for data extractionalso responsible forDesign and Development of SSIS Packagesto load teh Data from various Databases and Files.
• Worked onDTS, Import and Exportutility, for transferring data.
• Worked wifApplication Developersto design databases and tables to supportDevelopment activitiesand achieveoptimal efficiency.
• Suggested better way to recover databases from disaster me.e. disaster recovery.
• ConfiguredSQL Server settingsusing configuration manager.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas
• Involved wif development team and developed functions, procedures and packages performed Logical Backups byExportandImportutilities.
• Handled numerous change management requests on production servers
• Data stage jobs scheduling and troubleshooting.
• Configured lock pages in memory for resolving Memory bottlenecks.
• Did troubleshooting, performance tuning and query optimization using DMVs, profiler and performance monitor.
• Created jobs to monitor errors of last 24 hours and send emails to teh DBA team.
• Created maintenance plans for backups, Index rebuild or reorganize and Update Stats.
• Experience in troubleshooting queries running on 10TB databases.
• Worked wif developers and application teams to assign permissions and fixing security problems.
• Identifying CPU, Memory and me/O bottlenecks and teh queries causing it.
• Very good understanding of data and log files configuration.
• Configured and troubleshooting Merge replication, transactional and snapshot replication.
• Monitoring DB Servers, Instances and Clusters wif custom scripts\ jobs.
• Responsible for securing SQL Server, user management, and taking care of permissions and roles
• Automated operational metrics processes using SQL Server jobs.
• Work wif installation, configuration and creation of SSRS.

Environment: MS SQL Server 2016/2014/2012/2008 R2/2008, T-SQL, SSIS, SSRS, Power Shell, SQL Agent, SQL Profiler, Azure, Red Gate, Windows 2012 R2/2008/2003 server, Visual Studio 2008/2012, MS Visual Studio 2012, SQL Sentry.

Confidential, Watertown, MA

SQL Server DBA

Responsibilities:

• Build new SQL Servers and updated wif latest service packs and cumulative patches (hot fixes) forSQLServer 2016/2014/2012/2008.
• Buildingnew SQLServers in multi node cluster environments VMware/ Physical environments.
• Troubleshooting teh Disk failures in a Cluster Environment.
• Configured and Managing Always-On High Availability on 5 node cluster environments.
• Migrated SQL Server 2008R2 databases to SQL server 2014 by using Backup-Restore and Management Studio Wizards and custom scripts.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment.
• Upgrade/Migration SQL SERVERS 2008R2 to 2016.
• Prepared Documentation for teh Disaster Recovery plan.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Created complex stored Procedures, Triggers, Tables using T-SQL.
• Troubleshoot Performance issues causing Application slow.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source Excel Spreadsheet to SQL Server.
• Created SSISjobs and scheduled Packages usingSQL Server Management Studio.
• Hands-On monitoring SQL Servers using SQL Sentry.
• Monitor Database consistency and health using DBCC Commands and DMVS.
• Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).
• Created Linked servers for distributed queries.
• Hands-On Replication set-up and troubleshooting.
• Created and deployed reports using SQL Server Reporting Services (SSRS).
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to import data from other sources to SQL databases.

Environment: MS SQL Server 2016/2014/2012/2008 R2/2008/2005, T-SQL, SSIS, SSRS, Power Shell, SQL Agent, MS Azure, SQL Profiler, Red Gate, Windows 2012 R2/2008/2003 server, Visual Studio 2008/2012, MS Visual Studio 2012, SQL Sentry.

Confidential

SQL Server DBA

Responsibilities:

• Troubleshooting member firm’s issues related to Audit application.
• Responsible for supporting over 150 SQL instances which include SQL 2012/2008/2005.
• Migrated Databases from SQL Server 2005 to Server 2012 in Production and test Environments.
• Performing teh BCP tests of SQL servers as a backup plan strategy as per teh requirement.
• Performing teh Server QA on SQL Server and configuring teh SQL Server as per teh standards.
• Designed and implemented backup plans as per teh data- retention policy outlined in teh BRD (Business Requirement Document).
• Supported Load Testing activity by setting up and scheduling Performance Monitor (Data Collector Sets) and SQL Server Profiler Trace and monitoring them during teh activity.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance teh performance of database servers.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity and converting them into technical specifications.
• Used DBCC commands to check physical and logical consistency of teh databases and rebuild indexes.
• Expertise in enhancing and deploying teh SSIS Packages from development server to production server.
• Created Maintenance Plans to checking database integrity, rebuilding indexes and updating statistics
• Backup and Recovery of Production Databases and Tuning them for better Performance.
• Extensively worked on Profiler, Perfmon Counters, DMVs, DMFs and DTA to tune teh databases, servers and query tuning.
• Used SQL Sentry to check teh blockings, TOP SQL, and memory issues and DISK me/O issues.
• Worked on high availability SQL Server solutions using Mirroring and Log shipping.
• Upgrade databases from SQL Server 2005/2008R2.
• Created Linked servers for distributed queries.
• Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.
• Configured database mail to inform corresponding DBA basis on each Job Status.
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Monitored teh Performance of teh SQL Server by using Performance Monitor, SQL Profiler, and Performance Analysis.
• Managing Security of SQL Server Databases by creating Server Logins, Database Users, Roles and assigning permissions in compliance wif standards and resolving Account Locking issues by coordinating wif Active Directory Group.
• Performed Backup and recovery & Automation of Backups using maintenance plans.
• Involved in troubleshooting front end applications designed in ASP.NET for connectivity issues and backend performance issues.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to import data from other sources to SQL databases.

Environment: MS SQL Server 2012/2008 R 2/ 2008/2005/2000, T-SQL, SSIS, SQL Agent, SQL Profiler, Sentry, Windows 2008/2003/2000 server, Visual Studio 2008/2012, Red Gate, MS Visual Studio 2012.

Confidential

SQL Server DBA

Responsibilities:

• SQL SERVER 2008/2005/2000 Production Environment.
• Fixed teh failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and at teh SQL SERVER LEVEL.
• Implemented SIDE BY SIDE Migration of databases from SQL Server 2000 to SQL Server 2005
• Involved in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
• Worked wif SQL Server 2008 new MERGE statement.
• Handling Memory configurations for SQL Server 2000 and SQL Server 2005/2008 on Windows 2003
• Implemented teh new SQL Server 2005 concepts like Data partitioning, Snapshot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA, SQLCMD and dedicated admin connection and Compressed Backups.
• Created Documentation for steps need to be taken while upgrading teh SQL server 2000 to SQL server 2005.
• Work based on Business Intelligence (BI) and Data Warehousing in SQL Server 2005
• Implemented new T-SQL features added in SQL Server 2005 dat are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Configured more than 2 GB ram on 32-bit Environment
• Migrated DTS packages to SSIS packages and maintained teh archival data
• Checking Database Health by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning
• Recovered teh System and User databases from suspect mode, Expert in sizing Temp database.
• Prepared Documentation for teh Disaster Recovery plan, Worked in Active passive cluster environment
• Implemented new topics like CLR integration on Development Server
• Wrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements
• Extensively worked on trouble shooting and fine-tuning of databases for its performance, Rebuilding indexes wif different fill factors and update statistics manually
• Designed and implemented comprehensive Backup plan and disaster recovery
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and handling maintenance Jobs including backups and restores.
• Did Performance Tuning of teh Stored Procedures.
• Hands on experience in trouble shooting database issues. Update statistics, database integrity check and Backup operations
• Extensively used lite speed backup wif MS SQL SERVER 2005/2008.
• Expertise in SQL server Reporting Services(SSRS) and SharePoint
• Monitoring SQL server performance using profiler to find teh performance and dead locks.
• Worked on call 24/7 Support on weekly basis

Environment: MS SQL Server 2008/2005/2000, T-SQL, SSIS, SQL Agent, SQL Profiler, Sentry, Windows 2008/2003/2000 server, Visual Studio 2008/2012, Red Gate.