SUMMARY

• Over 10 years of experience in Database Administration and Development for very large and complex databases in SQL Server 2016/ 2014/2012/2008 R 2/ 2008/2005/2000
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Extensively worked on installing and configuring different versions SQL Server 2005, 2008R2,2012 and 2014 updating with latest Cumulative Updates and service packs.
• Configured and Maintained SQL Server Always On Failover Cluster for Active - Active and Active-Passive Clustering.
• Implemented SQL server Always On Availability Groups.
• Extensively worked on implementing High availability solutions like different Replication models (Snapshot and Transactional), Log shipping, Clustering and mirroring on physical and virtual machines.
• Migrated SQL Server 2000/2005/2008 databases to SQL Server 2012/2014/2016
• Extensively worked on Active-Active and Active-Passive Clustering.
• Worked on DBArtisan 9.7.2 multi-platform database management tool
• Efficiently carried out DBA responsibilities in planning migration activities from Sybase to SQL server.
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes and table partitioning.
• Expertise in reading and understanding execution plan and fixing the query to execute with low cost using joins like merge, nested loops, hash join.
• Extensively worked on Locks, Deadlocks, Handling Isolation Level and Concurrency Effects, Detect CPU, I/O, Memory Bottlenecks.
• Monitoring Event Viewer, SQL Error logs and Log file viewer for software and hardware related errors.
• Proficient in SQL Server features like Query Store, Resource Governor, Performance Data Collector (MDW), Transparent Data Encryption (TDE), Database Snapshot, Data partitioning, Backup compression and encryption, Column Store, Filtered Indexes, online indexing, Statistics update and Change Data Capture
• Expertise in Performance Tuning, Query Optimization, Client/Server connectivity and Database Consistency and integrity checks using DBCC Utilities, DMVs, Wait Stats, Extended Events.
• Expertise in using Native tools like SQL Server Profiler, Database Tuning Advisor, Perfmon and third party tools like LiteSpeed and Red gate.
• Handled up to 2.2 TB Size databases with clustered environment.
• Created effective Backup and Recovery plan by Transactional Log and Full Database Backups and utilized to recover data in point in time in case of disaster of server.
• Configured Security at ACTIVE DIRECTORY and SQL SERVER LEVEL by Creating Principals (logins) and Mapping users to roles. (Securable and Permissions).
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in Troubleshooting and Documenting root cause analysis.
• Thorough Understanding of different RAID levels implementation.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MSSQL server by using BCP utility, DTS and SSIS services.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in creating deployment utility to deploy SSIS packages over Production, QA and Dev Systems.
• Strong experience in mentoring with team members, documentation and 24/7 on call production support

TECHNICAL SKILLS:

Databases: MS SQL Server 2016/ 2014/2012/2008 R2/2008/2005

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

Data Modeling Tools: Erwin, Red gate, LiteSpeed, Foglight, Spotlight

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP and SMTP.

Languages: T-SQL, C/C++, C#, Visual Studio2005/2003, VB.Net.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

MS SQL Server Database Administrator

Responsibilities:

• Installed, Configured and Maintained MS SQL Server 2016/2014/2012 and associated database tools, updating with latest Service packs, hot fixes and security patches.
• Installed and Implemented three node SQL Server Failover cluster for Asset Management Group
• Configured and supported high availability features like SQL Server Always On, Database Mirroring, Transactional Replication and SQL Server Log Shipping.
• Expert level proficiency in designing and troubleshooting Always On Availability Groups for High Availability and Disaster Recovery in SQL Server 2012/14 servers.
• Involved in BCP(Business Continuity Process) Exercises to verify the disaster recovery scenarios and worked with application partners to validated the applications.
• Worked on Data Conversion and Migration from Sybase Cross Platform Migration to SQL Server.
• Worked on SQL Server Migration Assistant for Sybase (6.0) to covert objects from ASE 15.0.2 to SQL Server 2012.
• Migrated Databases from SQL Server 2005/2008/2008 R2 to SQL Server 2012/2014/2016
• Automated regular refresh's from Production to UAT and TEST Environments
• Worked on 3rd party Monitoring tools Foglight (5.7.5.3), Spotlight (11.5), backup tools LiteSpeed (6.1) Net backup (7.7.2)and IBM Deployment tool AnthillPro (5.1)
• Recommended and implementation of SQL Server standards and Best practices to maintain safety and soundness of Enterprise.
• Investigating and resolving dead locks , blocking and performance related issues using Profiler traces and DMV’s .
• Installation, Configuration of SSRS and deploying the reports using SSRS and its Administration
• Deploying SSIS Packages to MSDB and File System .
• Providing Escalation support for Production issues and lead Line2/Line3 teams

Environment: : Microsoft Windows 2003 R2/2008/2008R2/2012/2012R2 Server, Microsoft SQL Server 2016/ 2014/2012/2008 R2/2008/2005

Confidential, ( Saint Louis, MO

MS SQL Server Database Administrator

Responsibilities:

• Installed, Configured, Administered SQL Server 2014/ 2012 in Development, Test and Production Environments.
• Configured SQL Server 2012 Always on Clustering on windows 2012
• Configured Database mirroring for XENAPP Citrix application.
• Implemented AVAMAR (7.0) SQL Backup Strategy for all SQL Applications.
• Implemented Merge replication between SQL Server 2005 and Hand-held devices by using SQL server Compact edition for Sales report application.
• Installed and configured Performance Dashboard reports, MDW to track the performance reports.
• Configured Log-Shipping for CPI Application.
• Worked on implementing changes to production through change management approvals.
• Migrated SQL 2005/2008 to SQL 2012.
• In-Place upgrade for SQL 2008R2 to SQL 2012.
• Supporting application teams for their deployments on Development, Test and Production Environments during off Production hours.
• Involved in Refresh/Restore activities, fixing security issues.
• Fine-tuned Service Manager Application.
• Applied latest Services packs on clustered and standalone instances.
• Worked on SSIS and SSRS deployments.
• Provided On-Call support to Mission critical Environments

Environment: : Microsoft Windows 2003 R2/2008/2008R2/2012/2012R2 Server, Microsoft SQL Server 2014/2012/2008 R2/2008/2005

Confidential, (Saint Louis, MO)

MS SQL Server Database Administrator

Responsibilities:

• SQL Server 2005/2008/2008 R2/2012 Database Administration
• Migrated SQL Server 2005/2008 databases to SQL Server 2012.
• Configured and Maintained High Availability and disaster recovery Setups (Always On Failover Clustering, Transactional Replication, Mirroring, Log Shipping)
• Performed In-Place Upgrade from SQL Server 2008 R2 to SQL Server 2012
• Maintained database consistency with DBCC at regular intervals.
• Performed Edition Upgrade for SQL Server 2012 from Client Access Licensing (CAL) to Core Based Licensing.
• 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.
• Involved in Capacity planning and up-gradation of KOFAX application.
• Worked on Security related issues, SQL Server Hardening and Database Provisioning.
• Installed SQL SERVER Service Packs on Standalone, Two-node and Four-node Clusters.
• Deployed and scheduled SSIS Packages to run on Production, UAT and Development Systems.
• Performed the BCP test (Business Continuity Process) on Log shipping database routing the application to DR Servers for testing the Application connectivity and Data validation.
• Deployed SSRS Reports and configured Email Subscriptions and Data Driven Subscriptions for Application Partners.
• Provided On-Call support to Mission critical Environments

Environment: : Microsoft Windows 2003 R2/2008/2008R2/2012/2012R2 Server, Microsoft SQL Server 2012/2008 R2/2008/2005

Confidential, Chesterbrook, PA

MS SQL Server Database Administrator

Responsibilities:

• Implemented SQL Server 2008R2 Active-Passive Cluster in Windows 2008 Environment.
• Setup and maintained Database Mirroring with automatic failure and Transactional Replication.
• Extensively worked on Installation and Maintenance of SQL Server 2012/2008R2 on Test, Development and Production Environments.
• Worked with SQL Server 2008 side by side upgrade from SQL server 2000.
• Database Backup and restores, and periodical database refreshes
• Worked Extensively on Remedy application Database server tuning.
• Worked on Operational side for Disk Space, Log Space, Blocking and Deadlock issues.
• Moved SharePoint Content Databases from one Drive to another Drive.
• Fixed high Memory utilization issues.
• Installed Various Service packs for SQL Server 2008 and 2005.
• Migrated SQL Server 2005/2008/2008 R2 databases to 2012
• Having expertise Knowledge on SQL Server 2012 High availability concepts.
• Worked On SQL Server 2000/2005/2008 (R2) Clustered Environments.
• Managed Security using SQL Logins, Roles and Security Modes for various users.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• Checking Database Health by using DBCC Commands and DMVS.
• Added SQL Clustered Node to Existing Cluster for SQL Server 2008R2
• Correlated Profiler trace events with System Monitor performance counters to identify what event(s) are hogging server resources
• Handled numerous Change Management Requests on production servers.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas.
• Used Perfmon, DMV’s, SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.
• Moved Tempdb files from One Drive to another Drive.

Environment: : Microsoft Windows 2003/2008/2008 R2 Server, Microsoft SQL Server 2008 R2, 2008/2005/2000, IIS 7.5

Confidential (Stamford, CT)

MS SQL Server Database Administrator

Responsibilities:

• Implemented and managed the clustering environment like Active/Passive and Active/ Active
• Extensively worked on Administration, Database Design, and Performance Analysis on very large and highly transactional production databases
• Installed and configured SQL Server 2005/2008 (R2) on new servers with service packs
• Configure the RAID levels for data files, log files and temp db at server level.
• Reconfigure the default locations of the data files, log files and error log files onto the SAN environment for all the servers.
• Worked with tools like SQL Profiler, Perfmon counters and Activity Monitor for event monitoring.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors
• Involved in Change Data Capture process
• Implement various Data Flow Transformations, such as Copy Column, Row Count, Merge Join, Aggregator, Sort, and Lookup.
• Fix data issues and write various SQL scripts and procedures for migration process.
• Involved in Data Compression, Hot add CPU, Fact Table size reduction and improved performance using SQL Server 2008.
• Expert in using and implementing DMV’s, DMF’s, data partitioning, DDL triggers, Mirroring and Online indexing.
• Implemented data availability solutions like online Restore, Online index Operation, Database Snapshot, and Fast Recovery.
• Monitor and modify performance using execution plans and Index tuning.
• Migrated SQL Server 2000 to 2005, SQL Server 2005 to 2008 R2 and DTS to SSIS (ETL).

Environment: MS SQL Server 2008R 2/ 2008/2005/2000, Windows 2000/ 2003/2008/2008 R2, SSRS, SSIS, PL/SQL, MS Access, VB, C#, Erwin, Perl and SharePoint 2007.

Confidential

MS SQL Server Database Administrator

Responsibilities:

• Installation of SQL Server 2008/2008R2on Windows Server Clustered environment.
• Managed and Administrated the SQL Server 2008/2005 production and Non-production servers.
• Data Migration from Legacy system to SQL Server 2008 using SSIS packages
• Upgraded/Migrated SQL Server 2005 databases to SQL Server 2008 databases and mentored other technical staff.
• Performed backup using backup compression and Data compression in SQL Server 2008 on clustered environment.
• Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Monitored transactional replication on Production, UAT, QA and Dev servers.
• Used SQL Server 2008 Activity Monitor When troubleshooting a performance issue or monitoring a server in real time.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, and SQL Server Agent
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• Performed transparent data encryption (TDE) and decryption of the data and log files.
• Analyze execution plans and generate suggestions for improvement.
• Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.

Environment: SQL Server 2008 R 2/ 2008/2005/2000, Windows 2000/2005/2008

Confidential

MS SQL Server Database Administrator/Developer

Responsibilities:

• Installing, Configuring and Maintaining SQL Server 2008/2005/2000 on Active/Active Cluster with latest Service Packs, Hot Fixes.
• Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2005 and participated in Disaster Recovery Drill processes.
• Provide and Monitor database "health" - availability, reliability, performance and capacity planning using SQL Profiler, Database Tuning Wizards.
• Provide Reliability using Transactional Replication.
• Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
• Performance Tuned Stored procedures using Index Tuning Wizard, Estimated Execution plan, Profiler and PerfMon.
• Used the DMV’s to find the missing indexes on the tables for most appropriate used and missing indexes.
• Setup Database Security and maintain accounts and access levels by creating suitable Logins, Roles and assigning object level permissions.
• Analysis, development and maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.
• Involved in creating Stored Procedures, views, tables, constrains.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity.

Environment: MS SQL Server 2008/2005/2000, Windows server 2008/2003 Datacenter and Enterprise edition 32 bit/64 bit, Transact-SQL, SQL LiteSpeed, MS Visio for Enterprise Architect, ADO.net, VB.net, SSIS,SSRS, TFS(Team Foundation server).