SUMMARY

• 8+ years of experience with the 32bit, 64 - bit environments as Microsoft SQL SERVER DBA in Production, Development and Testing in Clustered and Stand alone Server Environment.
• Experience in installing MS SQL SERVER 201, 2008R2, 2008, 2005, 2000; updating with hot fix and service packs.
• Experience in Analysis, Design, Development, Testing and Maintenance, Capacity Planning, Performance support of application systems of OLTP and OLAP databases in the client-server environments.
• Experience in migrating SQL Server 20 R 2/2012/2014.
• Experience in implementing AlwaysOn Availability Groups in SQL Server 2012.
• Expert in RDBMS S/W installation, applying patches, upgrading, configuring, trouble shooting of SQL SERVER on Windows 98/2000/03/03 R2/08/08R2/2012 servers and Clustered VMware Environments.
• Expertise in installing Slipstreams, rolling patches, rolling upgrades in Clustered Environment.
• Good knowledge on new features Data Compression, Transparent Data Encryption (TDE), Policy Based Management, Backup Compression and Change data capture in SQL SERVER 2008.
• Expert in Disaster Recovery plans by configuring Clustering, Log-shipping, Mirroring and Replication (Snapshot and Transactional).
• Handled up to 2 TB databases in Clustered environment with good Physical storage configuration and Optimizing of SAN with different Raid Levels.
• Hands on experience in configuring Clustering in Active-Active and Active-Passive nodes.
• Experience in configuring Replication and troubleshooting the issues with transactional replication.
• Experience in query optimization and performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Expert in tuning the long running Queries and Store Procedures by examining the execution plans.
• Hands on configuring TempDB with considerable Memory and Raid Levels for better performance.
• Expertise in using Performance Monitor/Profiler /Activity Monitor to resolve Dead Locks, Long Running Queries and Bottlenecks caused by complex Queries.
• Excellent skills in database Back Up, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing indexes, Defragging Tables, Replication, Linked Servers and Database Maintenance Plan.
• Maintained User Permissions, Logins and Security Issues. Monitored Event Viewer s, SQL Error logs and Log Files Viewer for S/W and H/W errors.
• Good knowledge in using DMVs and DMFs to finding and solving Performance Issue.
• Hands on experience in Planning and Scheduling Maintenance Tasks and Scheduling Jobs and Alerts using SQL Mail.
• Documented Disaster recovery plans and participated in Disaster Recovery Drills by implementing Root Cause Analysis (RCA) for troubleshooting and resolving the issues.
• Involved in Change Control Management Process for maintaining the consistency of databases.
• Working knowledge of SOX Compliance for maintaining roles and responsibilities, data integrity and database management.
• Good knowledge with features of SQL Server like Spatial, CDC, Resource Governor, Encryption and File stream Data functionality.
• Expert in Detecting and Resolving Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor.
• Maintaining the Service Level Agreements (SLA’s) according to the clients requirement.
• Very Strong Experience withOLTPandOLAPEnvironment.
• Written Powershell scripts that are customized for a particular dataset - such as a morning health check, which outputs different base information on reporting every morning.
• Expert in creating and debugging Views, Functions, Indexes, Cursors, Store Procedures, Triggers, Optimizing code and improving Efficiency.
• Hands on experience in Batch Processes, Import, Export, Backup, BCP, DTS and SSIS.
• Expert in Creating, Implementing, Configuring and deploying the SSIS Packages from one server to other.
• Expert in migrating the DTS Packages to SSIS Packages by using Package migration Wizard.
• Expert in Deploying, Scheduling and running SSIS jobs by using Proxy Accounts.
• Experience in managing OLAP Database Warehouse by using services like Analysis Services (SSAS), Integration Services (SSIS) and Reporting Services (SSRS).
• Data Modeling Experience including Physical and Logical data modeling using Erwin tool
• Extensively used repositories like Team Foundation Server (TFS), and Visual Source Safe.
• Good Team player, Strong Communication skills and interpersonal with Self-motivation.
• 24/7 on call production support.

TECHNICAL SKILLS

Operating Systems: Windows Server 2016/2012/2008 R2/2008/2003R2/2003/98/XP/Vista/7, Unix (Sun Solar), Linux.

Databases: MS SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000 , MS Office Access 97/2000/2003/2007/2010 , Oracle.

ETL Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data Transformation Services (DTS)

Database Tools: SQL Profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio.

Other Tools: Erwin, Red gate, LiteSpeed, Spot Light, Foglight, Commvault, Idera SQL Safe,SQL Compare, Visio, Powershell

Languages: T-SQL, C/C++, C#, java script, Visual Studio 2005/20, ASP.NET, VB.Net

Applications: Microsoft Office Suite, Adobe Photoshop, Acrobat Reader/Writer.

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

SQL Server DBA

Responsibilities:

• Reviewed and analyzed requirements for New Projects with Application and Business teams.
• Coordinated with SAN Team and involved in Capacity Planning and Storage allocation for Test, Dev, Stage and Prod environments.
• Installed SQL Server 2008R 2/2012/2014/2016 manually and by using HP Server Automation tool.
• Setup SQLserver instances on virtual (VMware) environments and migrated SQL Server databases from physical to VMwareservers.
• Installed, configured and administered SQL Server Integration and Reporting Services.
• Migrated Servers from SQL Server 2000 and 2005 and 2008R2 to 2008R2 and 2012 and 2014 based on the application team requests.
• Installed SQL Server 2016 on Windows Server 2016 and migrated databases from SQL Server 2012 to SQL Server 2016.
• Installed and configured windows server 2016 failover clustering Active/Passive.
• Based on the business need created Transactional Replication on Different applications.
• Configured and maintained database mirroring for high availability.
• Implemented AlwaysOn Availability Group as a High Availability solution on SQL Server 2012 and 2014.
• Applying the Hot fixes and patches based on the requirements for different stores within the maintenance window.
• Make recommendations for File group Creation and Placement.
• Applying the Service packs and Cumulative Updates based on the Requirement to fix the issues.
• Routine DBA activities: Backup and Data recovery, Data security, Data Migration, Performance Tuning, Data Integrity analysis, User Management.
• Created Database Maintenance Plan to implement Database backups, Integrity Checks and indexing.
• Manage/administer the file groups for data, index and read-only for VLDB’s.
• Designed Database activities including Data Files and File group organization, Capacity Planning, Data Partitioning and Data Normalization.
• Evaluated 3rd party SQL Server Monitoring Tools that could be used for database administration.
• Involved in Performance Tuning, Indexing, Query Optimization.
• Configured SQL Server 2008R2/2012 Active/Passive Clusters in different environments applying the installation and configuration standards.
• Handling of the database backup failures, fixing the issues and make sure the availability of daily backups.
• Resolving the Database I/O Consistency errors and Allocation errors.
• Performing Health checks and Monitoring performance of the Production Servers.
• Implemented SQL Server Security Standards by granting minimal permissions, using database Roles, Windows Authentication and Active Directory Groups.
• Providing the access to users based on the requirement to the Production/UAT/QA/Development Servers with appropriate approvals.
• Handling of the low Logical disk space issues, Tempdb issues, Data file and Log file issues.
• Implemented Transparent Data Encryption (TDE) on high-valued, enterprise edition, servers and maintained encryption key backups.
• Used Resource Governor for limiting the resources like CPU, Memory to applications on shared environments.
• Worked on time to time basis with NetApps team in configuring the path for Database Backups and issues related with backups for critical applications in Production.
• Monitored the event logs and server logs fortroubleshootingand problem solving.
• Used the PowerShell scripting to get the most consistent production environment.
• Database refreshments from Production to DEV/UAT/QA environments.
• Maintained SQL Inventory documented backup strategies, SQL Server best practices, and installation and configuration procedures.
• Used DMVs, sp Blitz, Alerts, SP Whoisactive, SQL Profiler, Performance Monitor to proactively monitor and tune the Database Environment
• Adhered to the Change Management procedures.
• Evaluated new features in SQL Server 2012 and SQL Server 2014 in lab environment namely Enhanced to Backups, contained databases, Security Principals and AAG.
• Created SSIS packages to pull data fromSQLServer and exported to Excel Spreadsheets and vice versa.
• Involved in working with Redgate tool for SQL compare & SQL Data compare between the databases and tables.
• Loading data from various sources like OLEDB, flat files toSQLServer database Using SSIS Packages and created data mappings to load the data from source to destination.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially usingSQLServer Agent job.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports usingSSRS.
• Developed many Tablix Reports, Tabular Reports, Matrix Reports, Drill down Reports and Charts usingSQLServer Reporting Services (SSRS).
• Deployed the generated reports directly on the client's workstation in SSRS.
• Responsible to support the issues with reports on the enterprise environments (Development, UAT, Test and Production).
• Provided 24/7 Production Support (on-call) and resolved all tickets related to SQL Server Database and tickets opened by application and operations team including SSIS/SQL Job failures, Disk space, Blocking.

Environment: MS SQL Server 2000, 2005, 2008R2, 2012, 2014, 2016, TSQL,OLTP,OLAP, Windows Server 2008/2008R2/2012/2016, Commvault, Redgate, VMware, Spotlight, Visio 2007, SSIS, SSAS, SSRS, Visual Studio 2005/20 .

Confidential, Omaha, Nebraska

SQL Server DBA

Responsibilities:

• Installed SQL Server 2008R2/2012/2014 manually and using HP Server Automation tool.
• Configured SQL Server 2008R2/2012 Active/Passive Clusters in different environments applying the installation and configuration standards.
• Implemented AlwaysOn Availability Group as a High Availability solution on SQL Server 2012.
• Set up the Virtual machines through VMwaresoftware in Development & Production Environment.
• Migrated Servers from SQL Server 2000/20 R2/2012/2014 based on the application team requests.
• Created linked servers from Sybase to SQL Server and migrated databases from Sybase to SQL Server using SSMA.
• Based on the business need created Transactional Replication on Different applications.
• Configured and maintained database mirroring for high availability.
• Applying the Service packs and Cumulative Updates based on the Requirement to fix the issues.
• Routine DBA activities: Backup and Data recovery, Data security, Data Migration, Performance Tuning, Data Integrity analysis, User Management.
• Provided highly available Database and Application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
• Handling of the database backup failures, fixing the issues and make sure the availability of daily backups.
• Resolving the Database I/O Consistency errors and Allocation errors.
• Creation of user databases and ensuring file group creations and also ideally placing files in appropriate locations.
• Performing Health checks and Monitoring performance of the Production Servers.
• Participate in capacity planning, trend analysis, performance forecasting exercises and propose recommendations to meet the ongoing performance and scalability demands.
• Database refreshments from Production to DEV/UAT/QA environments.
• Maintained SQL Inventory documented backup strategies, SQL Server best practices, and installation and configuration procedures.
• Used DMVs, Alerts, SQL Profiler, Performance Monitor to proactively monitor and tune the Database Environment.
• Implemented SQL Server Security Standards by granting minimal permissions, using database Roles, Windows Authentication and Active Directory Groups.
• Providing the access to users based on the Requirement to the Production/UAT/QA/Development Servers with Appropriate Approvals.
• Handling of the low Logical disk space issues, Tempdb issues, Data file and Log file issues.
• Implementing Policy Based Management, Backup Compression and Transparent Data Encryption (TDE).
• Monitored the event logs and server logs fortroubleshootingand problem solving.
• Adhered to the Change Management procedures.
• Evaluated new features in SQL Server 2012 and SQL Server 2014 in lab environment namely Enhanced to Backups, contained databases, Security Principals and AAG.
• Created Database Maintenance Plan to implement Database backups, Integrity Checks and indexing.
• Performance testing on stored procedures, indexes, and triggers.
• Evaluated 3rd party SQL Server Monitoring Tools that could be used for database administration.
• Extensively Used tools SQLServer Profiler, Extended Events, sp whoisactiveand sp blitz utilities, Dynamic Management Views and Functions (DMVs and DMFs) for optimizing performance of SQL Server systems.
• Reviewed and analyzed requirements for New Projects with Application and Business teams.
• Coordinated with SAN Team and involved in Capacity Planning and Storage allocation for Test, Dev, Stage and Prod environments.
• Assisted in maintaining hardware and infrastructure systems primarily consisting of standalone servers, Netapp storage.
• Installed, configured and administered SQL Server Integration and Reporting Services.
• Create complex SQL stored procedures, Triggers, Functions, Views, Indexes in Microsoft SQL Server 2008, 2008R2 and 2012 and 2014.
• UsedRedGate SQL compareto compare Schema.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, and process SSAS cubes to store data to OLAP databases.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Pulling data on a daily basis from OLTP database to OLAP or staging database using the SSIS packages.
• Migration ofDTSpackages toSSISpackages.
• Designed, Developed, Configured and Deployed custom build business reports using SSRS.
• Provided 24/7 Production Support (on-call) and resolved all tickets related to SQL Server Database and tickets opened by application and operations team including SSIS/SQL Job failures, Disk space, Blocking.

Environment: MS SQL Server 2000/ 2005/2008/2008 R2/2012/2014, Windows 2003/2003R2/2008/2008R2/2012 servers, VMware, RDBMS, SQL Monitor-Red Gate, SCOM, SQL Diagnostic manager-IDERA, CA Service Desk, BMC Remedy Tool, TOAD, Net Veritas Backup Tool, Powershell, SSIS, SSRS, Visual Studio 2005/20, Spotlight, Quest Software TPAM, IT Service Catalog, Incident Request, ECHO, OMDB TMEIM, HP Server Automation Tool.

Confidential, Norfolk, VA.

SQL SERVER DBA

Responsibilities:

• Administrated and Managed SQL Server 2014/2012/2008 R 2/2008/2005/2000 databases in Production, Staging, QA and development environments.
• Upgraded/Migrated SQL Server 2000/2005/2008 databases into SQL server 2008R2/2012 and mentored other technical staff.
• Migrated databases from Sybase to SQL Server using SSMA.
• Comprehensively utilizedVMwaretechnologies in the deployment of mission critical SQL Server environments.
• Installing, Configuring and Maintaining SQL Server 2008R2/20 bit) on Active/Active Cluster with latest Service Packs, Hot Fixes.
• Involved in implementation of AlwaysOn Availability Group as a High Availability solution on SQL Server 2012.
• Responsibilities include the Production and Application Support for the Database and Application Servers.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Resolving performance issues using DMVs (Dynamic Management Views).
• Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Worked on everyday tasks and tickets based on priority levels from TFS ticketing system and saved/ updated all scripts related to the tasks in TFS using visual studio 2010.
• Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
• Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
• Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2008R2/2005 and participated in Disaster Recovery Drill processes.
• Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.
• Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing, Resource Governor and Merge statement in T-SQL.
• CreatedPartition function,Partition schemeandmultiple file groups and filesto host the table data forData partitioning.
• Encrypted data and log files usingtransparent data encryption (TDE)solution.
• Extensively worked with NetApps group and strong knowledge of NetApps.
• Used Powershell to manage SQL server databases for high availability.
• Worked in OLTP and OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
• Implemented new features inSQL 2008likePolicy based Management, Table Compression backup compression, SQL Server Auditing, Resource Governorand MERGEstatement inT-SQL.
• Troubleshoot performance issues and database internals using custom targeted DMV scripts to isolate problems and regularly use industry scripts sp WhoIsActive, sp Blitz, sp BlitzIndex.
• Dropped and recreated the indexes on tables for performance improvements. Used Index tuning wizard for tuning of indexes.
• Performed data partitioning for efficient management of database tables and indexes
• Extensively working on performance issues like update statistics, Auto Stats.
• Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.
• Designed and developed SSIS packages using different control flow tasks, data flow task and data transformations.
• Debugged and Deployed SSIS packages in to file system server and MS SQL Server with the help of manifest file.
• Designed, Developed, Configured and Deployed custom build business reports using MS Reporting Services - SSRS.
• Automated theRedGate SQL compare report.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.

Environment: MSSQL Server 2012/2008/2008 R2/2005/2000, Windows Server 2003/2003R2/2008/2008R2/2012, VMware, SQL Profiler, Database Tuning Advisor, SCOM, T-SQL, Litespeed, Erwin, Idera, SpotLight, Visual Studio 2005/20, SSAS, SSIS (ETL), SAN, SSRS, SharePoint Server 2007, Oracle, Linux, Unix, Mainframe, Sybase, DB2, NetAPP.

Confidential, Baltimore, MD

SQL Server DBA

Responsibilities:

• Implemented SIDE BY SIDE Migration of MS SQL SERVER 2000/20 R2/2012 on Windows.
• Designed and deployed HA and DR solutions usingVMwaretechnologies.
• Migrated DTS 2000 PACAKGES to SSIS packages and maintained the archival data using Control flow task.
• Configured the AWE and 3 GB switch for the 32 bit 2005 server.
• Applied Patches and Service packs to update different versions of MS SQL SERVER.
• Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and SQL SERVER LEVEL.
• Implemented native log shipping on MS SQL SERVER 2008R2.
• Scheduled regular BACKUP JOBS and kept track of DATABASE by receiving the emails on Alerts.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot Isolation, Database Snapshot, DDL triggers, Try-Cache blocks, Online Indexing, DMV’s, DMF’s, DTA,SQLCMD and dedicated admin connection, Common table Expression(CTE).
• Used CDC (Change data capture), Table valued parameters and other new features in new applications.
• Implemented DATABASE MIRRORING ON MS SQL SERVER 2008R2.
• Moved files between the File Groups and partitioned the tables to improve the performance.
• Extensively used litespeed backup with MS SQL SERVER 2008R2.
• Utilized the new features of 2008 like TDE, MERGE STATEMENT and Compressed Backups.
• Good knowledge on new concepts of 2008 like PowerShell.
• Extensively worked on Transparent Data Encryption (TDE) and Auditing.
• Monitored database queries/transactions with sp whoisactive, sp who2, and sp who.
• Troubleshooted performance problems, fine-tuning of databases and index Analysis.
• Documented and performed the database health checks regularly.
• Re-factored and fine tuned the queries and stored procedures in T-Sql.
• Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
• Implemented log shipping for Production server database as part of the disaster recovery.
• Implemented the new SQL Server 2008 concepts like Policy Based Management, Central management servers, Transparent Data Encryption, Table and Page level compression and Resource Governor.
• Created baseline and sampling intervals in the perfmon considering threshold values of the counters.
• Rebuilding indexes with different fill factors and update statistics manually.
• Implemented native log shipping for HIGH AVAILABLITY of the Production Server DATA BASE.
• Worked with QuestSQLComparetable and the datacomparebetween Dev to Test and Test to prod environment.
• Generated reports in SSRS using BIDS (Business Intelligence Development Studio).
• Deployed SSIS package for bulk insert and maintained archival data.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.

Environment: TSQL, MS SQL SERVER 2000/ 2005/2008/2008 R2/2012, SSIS/SSRS/SSAS, SAN, NetAPP, EMC, Query Analyzer, Business Intelligence Development Studio (BIDS)Visual Studio 2005/20, Sybase, VMware, Oracle, Unix, Mainframe, Linux VBScript, .NET, C#, Windows Server 2003/2003R2/2008/2008R2, LiteSpeed, SpotLight, Redgate, IIS.

Confidential, Alabama

SQL Server DBA

Responsibilities:

• Database Administration, Database Programming.
• Migrated SQL server 2000 databases into SQL server 2005 and 20 R2 databases by In-place upgrade and Side-by-Side migration.
• Solved SQL Server performance issues onVMwareenvironment.
• Designed and implemented Security policy for SQL Servers.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Rebuilding the indexes at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies. Implemented and Scheduled Replication process for updating our parallel servers
• Automated messaging services on server failures, for task completion and success.
• Intensively used Litespeed to take backups.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Monitored and modified Performance using execution plans and Index tuning.
• Recovering the databases from backup in disasters
• Maintaining the database consistency with DBCC at regular intervals
• Configured log shipping for synchronization of database.
• Good experience in data modeling a metadata services.
• Expertise in SQL Server Analysis Services.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• To provide 24x7 production support for over 150 SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
• Involved in Change Data Capture process.
• To provide direction and development DBA support to over 50 software developers located in various branches in US, Europe, and Asia.
• Monitored database queries/transactions with sp whoisactive, sp who2, and sp who.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, testing, training, production support and Project review with client.
• To setup, implement, and maintain industry standards in database management.
• To maintain change control and release management process for all database objects like tables, views, procedures, and triggers.
• To implement all database development enhancements to multiple SQL Server databases to ensure a flawless functioning of production environment.
• Extensively used Red GateSQLCompareand DataComparetools tocompareand synchronizeSQLDatabase Schemas.
• To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.
• To design & develop data models and perform forward and reverse engineering using data modeling tools like ERWIN.
• Provided 24/7 Support for Production, Development & Test Servers.

Environment: SQL Server 2000/ 2005/2008/2008 R2, Clustering, Replication, Windows Server 2003/2003R2/2008/2008R2, VMware, Visual Studio 2005/2008/2010 , SSIS/SSRS/SSAS, SQL Profiler, Database Engine Tuning Advisor, ERWIN, Litespeed, Oracle, Unix, Linux, Mainframe, Sybase, T-SQL, SpotLight, VB Script and ASP.NET.