SUMMARY

• 7+ Years of experience as SQL Server DBA (2014, 2012, 2008, 2005, 2000) in Production, Development and Staging Environment.
• Hands - on experience with Installation/Troubleshooting, Managing and Configuration of MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 on Windows Server 2012/2008/2003.
• Maintained databases with sizes ranging from Large to Very Large Databases (terabytes).
• Experience in implementing high availability solutions like SQL Server Always ON, Log shipping, Clustering and Mirroring using different modes.
• Created Database maintenance plans for compressed full DB backup and transaction log backup.
• Experience with data Migration and SQL Server Upgradation from MS SQL server, and .
• Setting up and monitored Disaster recovery environments like Database mirroring with in the primary Data center servers and Log Shipping between primary and secondary Data center servers including Mirroring conjunction with Log Shipping.
• Excellent Experience in Managing Security through Logins, Users, Permissions, Certificates, Credentials, Encryption Schemes per Company’s Security Policies.
• Created Database Snapshots on Mirror databases for generating the reports for business crew members and worked with linked servers.
• Configured, monitored Transactional Replication for different clients for Reporting purpose
• Troubleshooting Mirror, Log shipping and Transactional replication synchronization issues.
• Troubleshooting Application and Backup jobs failed issues.
• Involved in migration of SSIS Packages.
• Working noledge in Reporting Services(SSRS)
• Good noledge in using DMVs and DMFs in resolving Performance Issue, Data modeling concepts.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Query Optimization, Database Consistency Checks using DBCC Utilities, analyzing the execution plan and index management for better Query Optimization.
• Working noledge of PowerShell, and other scripting languages to automate the build process.
• Experience in server virtualization using VMware & Hyper V
• 24/7 Database operation support forSQLserver 2014/2012/08/05 databases in clustered and stand-alone server environment.
• Experience in scheduling Backups and Restore and Maintenance plans using Native & Third-party tools (LiteSpeed5.0 and Red Gate SQL Backup).
• Experience in T-SQL Development skills including stored procedures, Indexed views, User Defined Functions (UDL), Triggers, and Distributed Queries.
• Documented Database environment, Escalation procedures, issues, Installation procedures, Disaster recovery procedures In Database Management Prod Guide.

TECHNICAL SKILLS

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

Languages: T-SQL, SQLCLR

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

Backup Tools: SQL Native, CommVault.

Performance Tools: Perfmon, SQL Profiler.

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

Software Packages: MS Office 2003, 2007, Visio.

Monitoring Tools: SQL Sentry.

PROFESSIONAL EXPERIENCE

Confidential, Watertown, MA

SQL Server DBA

Responsibilities:

• Build new SQL Servers and updated with latest service packs and cumulative patches (hot fixes) forSQLServer 2008/2008R 2/2012/2014.
• Environment consisted of 3500+ databases across 340+ SQL Server Instances with sizes ranging from Few GB to 7 TB OLAP & 13 TB OLTP databases. And 2.5M txn’s/day and 6000 users daily.
• Migrated SQL Server 2008R2 databases to SQL server 2014 by using Backup-Restore, Detach-Attach, 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 for SQL Server 2012.
• Configured\Monitored\Supported and Troubleshooting of Database Mirroring and Log Shipping for multiple databases on Geo-graphically separated cluster environments to provide High Availability and Disaster Recovery
• Prepared Documentation for the Disaster Recovery plan.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and Troubleshooting failed Jobs.
• Created complex stored Procedures, Triggers, Tables using T-SQL.
• Troubleshoot Performance issues causing Application slow.
• Monitor Database consistency and heath 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.
• 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.
• Managing Security of SQL Server Databases by creating Server Logins, Database Users, Roles and assigning permissions in compliance with standards and resolving Account Locking issues by coordinating with Active directory Group.
• Provided 24x7DBAProduction support for more than 3500SQLServer Databases in Production on Clustered and standalone Servers to achieve Optimum Performance.

Environment: MS SQL Server 2014/2012/2008 R2/2008/2005, T-SQL, SSIS, SSRS, Powershell,SQL Agent, SQL Profiler, Windows 2012/2008/2003 server, Visual Studio 2008/2012, MS Visual Studio 2012.

Confidential, Richardson, TX

SQL Server DBA

Responsibilities:

• Installed, configured, applied latest service packs and cumulative patches (hot fixes) inSQLServer 2008/2008R2/2012.
• Ensured the integrity and security of productionSQLServers.
• Worked on very large databases having terabytes of data.
• Implemented Transactional Replication and Merge Replication, monitored and troubleshooting it.
• Automating routine health checks using T-SQL and VB Scripting.
• MigratedSQLServer 2000/2005 & .
• Tracking the problems and updating the KEDB (Known Error Database) periodically.
• Created Maintenance plan for Back-ups, re-indexing, integrity checking and database shrinking.
• Implemented Log Shipping inSQL2005 from Primary Server to Secondary Server to support disaster recovery solution.
• Worked on Database Recovery Plans and Implementation of the Mirroring inSQLServer 2008R2.
• Responsible for creating, maintaining and monitoring mirrored servers.
• MonitoredSQLServer Performance on regular basis and gather data for trending analysis.
• Used Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• UsedSQLprofiler, system monitor and query analyzer for, monitoring, Optimization, Tuning ofSQLServer, Long running Queries and Indexes.
• Responsible for regular database maintenance process and disk defrag procedures in Production environment.
• Managed capacity planning and implement database security for multiple instances of development, QA, Demo, Integration and ProductionSQLServer databases.
• Captured and analyzed the long running Stored Procedures usingSQLServer Profiler and tuned the same to optimize application and system performance.
• Maintained a stable process of database refresh from production to QA/Dev environments.
• Provided 24x7DBAProduction support for more than 2000SQLServer Databases in Production on Clustered and standalone Servers to achieve Optimum Performance.

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

Confidential, Charlotte, NC

SQL Server DBA

Responsibilities:

• Troubleshooting member firms issues related to Audit application.
• Automating regular tasks and inventory auditing using VB Scripting.
• Responsible for supporting over 150 SQL instances which include SQL / 08 / R2 & 2012.
• Migrated from a 12 box system to 36 box system with pairs of 2 (DEV, UAT, Production, Disaster Recovery)
• Migrated Databases from SQL Server 2005 to SQL Server 2008R2/2012 in Production and test Environments.
• Performing the BCP tests of SQL servers as a backup plan strategy as per the requirement.
• Performing the Server QA on SQL Server and configuring the SQL Server as per the standards.
• Designed and implemented backup plans as per the data- retention policy outlined in the 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 the activity.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity and converting them into technical specifications.
• Creating databases and logins and users with permissions in SQL server 2005/2008.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
• 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 the databases, servers and query tuning.
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring and SQL Server clustering.
• Creating new Databases and Migrated SQL Server 2005 databases to SQL server 2008R2 by using Backup-Restore, Detach-Attach, and Management Studio Wizards and custom scripts.
• Moved databases from SQL Server 2005/2008 to SQL Server 2000.
• 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.
• Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).
• Monitored the Performance of the SQL Server by using Performance Monitor, SQL Profiler, Performance Analysis and Spotlight.
• Managing Security of SQL Server Databases by creating Server Logins, Database Users, Roles and assigning permissions in compliance with standards and resolving Account Locking issues by coordinating with Active directory Group.
• Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases.
• 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, Windows 2008/2003/2000 server, Visual Studio 2008/2012, MS Visual Studio 2012.

Confidential, Wilmington, DE

SQL Server DBA

Responsibilities:

• Handled environment consisted of 2000+ databases across 400+ SQL Server Instances with sizes ranging from Few GB to 3 TB.
• Performing deployments as per the change management on UAT and Prod using Octopus tool.
• Prepared the game plan and backup plan for the deployment.
• Installed and Upgraded SQL Server 2005 to SQL server 2008 on Production Servers.
• Created new database objects Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support via ACTIVE DIRECTORY.
• Extensively worked on Profiler, Perfmon Counters, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
• Setting up and Monitoredtransactional replication, Database mirroring on Production and QA servers.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Implementation and management of operating systems (Windows), and virtualization (VMware/Hyper V)
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Expert in Performance Tuning of the Stored Procedures.
• Checking Database Health by using DBCC Commands and DMVS.
• Monitored and Tuned Performance for the queries using execution plans and Index tuning.
• Created Dynamic SSIS packages, to load Stage tables from text files.
• Prepared Documentation for the Disaster Recovery plan.
• Designed Data Integrator jobs with Error Handling and email notifications.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Responsible routine DBA jobs like Backups and Restores.
• Writing Stored Procedures, Functions and triggers based on the requirement.’
• Creating jobs/maintenance plans for Database.

Environment: MS SQL Server 2008R2/2005, T-SQL, BCP, VB Scripting, SQL Profiler, Log Shipping, Replication, Mirroring, Clustering, Windows XP/2000, MS Visual Studio 2008, Windows 2003 Server.

Confidential 

SQL Server DBA

Responsibilities:

• Installed SQL server 2008 on windows 2003/2008R2 advanced servers, applied security fixes.
• Installed and Configured MS SQL Server 2008 R2, responsible for configuration, tuning and provide support to all Production and development servers.
• Part of Side by side migration of servers from SQL Server .
• Responsible of handling the P1/P2/P3 Incident tickets escalated from L1 (SOC).
• Worked on maintenance tickets and reimaging and installing the SQL Server.
• Maintained database response times in 24X7 Production environments, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats.
• Setting up Automatic/Forced fail over using Database Mirroring for mission critical production databases during patch upgrades, performance troubleshooting, and unexpected disasters.
• Planning and implementation of database backup/restore and disaster recovery.
• Analyzing business requirements and build logical data models that describe all the data and relationships between the data.
• Responsible for defining Check constraints, Business Rules, tuning data, indexes, and queries.
• Configuring and administering Database Mirroring, Log Shipping on SQL Server 2008R 2
• Developing SQL scripts for maintaining administration tasks.
• Designed and implemented a disaster recovery system.
• Worked extensively on Database space management, performance monitoring and alert management.
• Maintain and troubleshoot replication and log shipping as per requirement.
• Setting up of perfmon counters and analyzing them and generating and presenting performance reports.
• Implemented MS SQL Server security policies and granted object level permissions.
• Managing Security of SQL Server Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements
• Planning, Configuration and Monitoring of Log shipping. Performed Role Reversal of Primary and Secondary servers of the log shipped database.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Configured Transactional replication between Primary Server and three Read - Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.
• Performance Monitoring of MS SQL Server 2000/2008.

Environment: SQL Server 2008 with clustering environment that includes Production (24x7), Log shipping, Mirroring, Migration.