SUMMARY:

• Having 9 years of Administration experience on Data Design using SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 systems in OLTP and OLAP environments
• Extensive experience in Healthcare, Manufacturing Domains.
• Extensive Experience in Deploying and Implementing Electronic Health Record(EHR) Application for Enterprise Clients.
• Expertise in installing MS SQL Server 2016,2014, 2012, 2008R2, 2008, 2005, 2000 and associated database tools, updating with latest service packs, hot fixes and security patches.
• Expertise in setting up Active/Passive and Active/Active Clusters, Load balancing and Failover for High availability.
• Implemented In Place and Side - by-Side Migration of MS SQL SERVER 2000/2005 to 2008 R2 and from lower versions to 2012, 2014,2016.
• Dexterity in implementing different types of High Availability & Disaster Recovery scenarios like AlwaysON Availability Groups, Clustering, Database Mirroring, Transactional Replication and Log Shipping.
• Expertise in Performance Tuning, Index Tuning Wizard, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup/Recovery of databases, Replication, Linked Servers, Database Maintenance Planning.
• Experience in setting up high-availability / disaster-recovery (HA/DR) environment which includes Failover Cluster Instances and Always-on Availability Groups.
• Proficient in using Native tools like SQL Server Profiler, Database Tuning Advisor and Perfmon Counters.Experience in resolving locks deadlocks, handling Isolation level and concurrency effects, detect CPU, I/O, Memory bottlenecks.
• Providing support for overall Microsoft SQL Server set up in the organization with multiple SQL Server environments.
• Evaluating existing SQL infrastructure, architecting new solutions and supporting a 24/7 production environment. Experience in Data Warehousing using Microsoft tools: SSIS, SSRS
• Database administration using ITIL Standards (including Change, Incident, problem management. Development & Administration under Windows environment, using Client-Server/Internet architecture.

TECHNICAL SKILLS:

Operating System:: Windows 2000/2003/2008/2012 Server and Windows XP, Windows Vista, Windows 7, windows 10

Tools:: TFS, Quality Center, MS-Office, Light speed, Clear trace, Trace Analyzer, Redgate, SQL Internal viewer, SQL dumper, SQL Compare,SQL Pofiler and various Microsoft utilities. VMware

IIS:: IIS 6, IIS 7, IIS 7.5

Web Framework:: IDX Framework 5.02, 5.03, 5.04

Microsoft Technologies:: VM Ware, Citrix, GE framework, EHR etc.

Hardware:: Pc Maintenance & Troubleshooting, Networking

Applications:: Ms Office 2003, 2007, 2010 & 2013.

Database:: MS SQL SERVER 2005, 2008,2012,2014 & 2016.

PROFESSIONAL EXPERIENCE:

Confidential, South Burlington, VT

Sr. SQL DBA

Responsibilities:

• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Managed databases during the P2V and V2V Server Conversions.
• Installed and Upgraded from SQL Server 2005/2008 to SQL server 2008 R 2/2012/2014/2016.
• Migrated Databases on SQL server 2005, 2008/R2, 2012 & 2014 from local datacenter to cloud based environment
• Worked on 2-node (Active-Passive, Active-Active) and 3-node (Active-Active-Passive) Clusters and DB Mirroring environment as a High availability solution.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Altered/modified and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on OLTP and OLAP.
• Managed Security using SQL Logins, Permission, Roles and Security Modes as a part of Security Policies for various categories of users.
• Controlled and coordinated the installation of Security Patches and Service Packs.
• Responsible for IIS Administration for web applications includes creating virtual directories, connecting to servers, managing Services and configuring IIS backup and recovery.
• Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.
• Deployed and managed reports using SQL Server Reporting Services (SSRS).
• Deployed database objects from development/testing environment to production environment.
• Extensively worked on SQL Profiler & Performance Center to perform day to day tasks and tune the databases, servers and query tuning respectively.
• Review the blockings/deadlocks issues and work on it to get those corrected.
• Assist DBA team in Database performance analysis, diagnosis and tuning (Sql Query Optimization, Storage and Network performance, CPU and Memory tuning, IO Load balancing etc).
• Responsible for monitoring Jobs, Disk spaces, Error logs and making recommendations for performance improvement in hosted databases which involved index creation, index removal, file group modifications, and scheduling jobs to rebuild/reorg indexes and update statistics.
• Responsible for Application support for front end feeds and Resolved Application connectivity issues like connection time-outs, connection pooling issues and memory leaks.
• Setting up and Monitored transactional replication, Database mirroring and log shipping, Always On Availability Groups on Production, QA and Dev servers.
• Resolve SQL Server problems in conformance with SLAs which involves in-depth knowledge of SQL Server architecture, connectivity, replication, backup/restore, database corruption, security and log-shipping.
• Documented Trouble-shooting guide for various issues.

Environment: Windows Server NT,2003,2008,2008R2 & 2012 MS SQL Server 2016,2014,2012/2008 & R2/2005/2000, SQL Management Studio, SQL Profiler & Performance Center, Query Analyzer, SSIS, SSRS, Configuration Manager, System Monitor/Performance Monitor.

SQL DBA

Responsibilities:

• Administrated and Managed SQL Server 2012/2008R 2/2008/2005/2000 databases in Production, Staging, QA and development environments.
• Responsibilities include the Production and Application Support for the Database and Application Servers.
• Migrated In-place and side-by-side SQL Server 2000 databases to SQL Server 2008R2/2008/2005 databases and 2008 R2 to 2012 mentored other technical staff.
• 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.
• Installing, Configuring and Maintaining SQL Server 2012/2008R2/2008/2005 (64 bit) on Active/Active Cluster with latest Service Packs, Hot Fixes.
• 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 2008/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 2012 like Always on Availability Groups .
• Performed data partitioning for efficient management of database tables and indexes.
• Extensively working on performance issues like update statistics, Auto Stats.
• Maintained Production and Test Database Environment in SQL server 2012, 2008R 2/2008/2005.
• 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.

Environment : Microsoft Windows 2008R2, 2008, 2003 Server, Microsoft SQL Server 2012,2008 R2, 2008, 2005, IDERA Management Tools, MS Visual Source Safe, IIS 6.0, XML.

SQL DBA

• Extensively managed and administered SQL Server 2008 R2/2008/2005 and 2000 servers.
• Installation of SQL Server 2008R2/2008/2005 on DEV, Staging and Production Servers for teams.
• Migrated SQL server 2000 databases into SQL server 2005/2008R2 databases.
• Monitored SSIS packages and job workflows for used database partitions to manage data.
• Transferred SQL Server Objects from QA to Production Using SSIS Packages.
• Used SQL Server Dynamic Management Views (DMVs) to track performance and usage.
• Configured Reporting Server Using Reporting Services Configuration Tool.
• Worked with SQL server Profiler to generate traces and fine-tuned databases and T-SQL.
• Integrated SQL traces with Performance Monitor to have better graphical analysis to find system bottlenecks to analyze CPU, Memory and Disk usage patterns.
• Managed SQL Object Permissions, Roles and Authentication Modes for security policies.
• Rebuilding the indexes at regular intervals for better performance and updated statistics.
• Maintaining SQL scripts for creation of Database Objects using Red Gate’s Source Control.
• Created Database maintenance plans and performed DBCC Database Integrity Checks.
• Configured Report Server (SSRS) and scheduled SSIS packages with alert notifications.
• Planned the complete backing up of Databases and Disaster Recovery /Restore procedures.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Used log shipping for synchronization of databases between Primary and Standby servers.
• Monitored transactional replication, Database mirroring on Production, QA and Dev servers.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Worked on database design for Query optimization, performance tuning and Indexing.
• Extensive testing on the Performance of the Stored Procedures, Functions, T-SQL queries.
• Scheduled and monitored all maintenance activities including d atabase consistency check, index defragmentation to ensure optimal DB performance.
• Developed operational drill-down reports using SSRS and added report parameters.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Migrated data from Heterogeneous Data Sources and legacy system (Access, Excel) to SQL Server instances for DEV, QA, Staging and Production environments.
• Provide 24x7 Production Database on-call support as needed

Environment: SQL Profiler, SQL Server 2000/2005/2008/ R2,T-SQL, Business Intelligence (SSIS,SSRS) Excel, Windows 2008/2003 Server, Red Gate Source Control, Erwin 4.0, Lite Speed

Jr DBA

• Creating and managing database users.
• Maintaining policies and procedures and implementing them as per the organization requirement.
• Installing and upgrading software’s and maintaining access.
• Troubleshooting and resolving critical production issues related to users.
• Expertise on SQL Diagnostic Manager Tool which can be configured for all production databases
• Monitoring production, test and train instances of SQL server
• Verifying free space in Data file and managing space.
• Worked with developer for designing scripts for the maintenance activities of the Database.
• Migration Jobs from one server to another.
• Implement and maintain database security, manage users and permissions.
• SQL Server backup, restoration, patching and upgrades of databases

Environment: - SQL Profiler, SQL Server 2000/2005, Windows 2003 Server