EXPERIENCE SUMMARY:

• Microsoft SQL Server DBA with over 6+ years of IT experience in installation, upgrade, backup, recovery, administration, maintenance for MS SQL Server 2014/2012/2008 r2/2008/2005
• Good knowledge of Relational Database Management Systems (RDBMS)
• Experienced in Installation, Configuration, Database Migrations and Upgrading of SQL Server from 2005 to SQL Server 2012
• Experienced in Upgrading SQL Server Software to new versions with required Service Packs and Patches and hot fixes
• Management of high performance production CLUSTERED SQL Server database instances using Active - Passive nodes, and Active-Active nodes clustering.
• Handled all SQL administration related issues which includes, Installing, Configuring and troubleshooting Always-On, Replication, Mirroring, Clustering and Log shipping issues.
• Well knowledgeable in using advanced SQL Server features including Replication, Log Shipping, and database mirroring
• Analyze data and made performance recommendations that increased storage efficiency
• Analyze long running queries and tuned to optimize application and system performance.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities
• Extensive knowledge in database maintenance and SQL Server optimization using SQL tools such as SQL Profiler, Database Tuning Advisor, Maintenance Plans, and Database Performance Analyzer by SolarWinds (Ignite)
• Worked on controlling user privileges, monitoring the security and Audit issues. Also administering Security by setting up Groups and then Logins for each Roles or Users for Maintenance of Databases at database level, server level and windows level
• Experienced in managing Alerts, Operators and Jobs using SQL Server Agent and Tidal Enterprise Scheduler (TES)
• Experienced in providing good production support for 24x7 over weekends on rotation basis

TECHNICAL SKILLS:

Databases: MS SQL Server 2005/2008/2008 R2/2012, Ms Access 2000/2005/2007.

Database Tools:  SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIS), Database Engine Tuning Advisor, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication,, SQL reporting, SSIS,MAP Tool, SQL Compare, TSM, CommVault, SCOM, Idera.

Programming:  SQL, TSQL, BASIC, C / C++, XML, HTML, Perl and Shell Scripting.

Operating System:  Windows 2012/ 2008R2/2003/2000, Advanced Server, NT & Windows 9x, Linux.

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

Case Tools:  MS Office 2000/XP/ 2003/2007/2010 , MS Outlook 2000/ 2003/2007/2010 , Visio, Clear Quest.

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Sr. SQL Server DBA

Responsibilities:

• Installed, upgraded and configured SQL Server 2014/2012/2008 R2 for several applications with latest service packs.
• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Implemented Log shipping and mirroring as a part of HA and DR.
• Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012.
• Worked on Always ON Environment and configured Always on in SQL 2012 version with 5 replicas which included 1 primary replica and 4 secondary replicas.
• Implemented Log shipping and mirroring as a part of HA and DR.
• Supported customer service databases which are more than 2TB size.
• Good hands on Log shipping, Mirroring, Replication.
• Actively Participated in DR Test.
• Implemented Robocopy process with SQL Agent to automate the file transfer
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• 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.
• Deploy SSIS packages in various environments Development/test/Stage/production.
• Proficiency in developing Maintenance plans, backup, recovery strategies and Rebuild/Reorganize strategies
• Reviewing and verifying Database backup details, Database user privileges, Inactive user accounts.
• Monitoring Year Old SQL Authenticated accounts, Sys Admin Accounts and Password Policy Check for SQL Accounts.
• Experience with moving physical data and log file from one drive to another drive
• Monitoring CPU resource usage and SQL Server disk management
• Configured Database mail and linked servers between SQL Server to SQL Server, SQL to Oracle Servers, and SQL to MS Access Databases
• Ensured security logins and database access permissions

Confidential

MS SQL Server DBA

• Checking the general health of the servers and the databases
• Successfully Installed different versions of SQL Server on the Production
• Installed and Maintained high availability of database using Database Mirroring
• Monitored SQL Server Performance and Activity by using SQL profiler
• Monitored Dashboard Reports for Performance Tuning and finding bottlenecks in database.
• Monitored the server’s status, database file growths, disk space alerts etc.
• Experienced in improving/Tuning SQL Server performance using native and third party tools
• Analyze reports for long running queries, locks, deadlocks, backup history check and retention
• Involved in trouble shooting of database and vendors’ application problems
• Monitored Space estimation for database objects
• Scheduled Alerts and Jobs Using SQL Server Agent (Automation)
• Implemented SQL logins, roles and authentication modes as part of security policies
• Backup and Restoration of Databases using RedGate Backup and SQL native methods
• Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2005 & 2000(SSAS)
• Responsible for transfer of data from client’s existing software to e-ClinicalWorks databases

Environment: SQL Server 2014/2012/2008 R2/2005/2000; SSIS, SSRS, SSAS, Windows Server 2012/2008R2, Visual Studio 2010, SharePoint, Redgate Backup, Solarwinds

Confidential

Database Administrator.

• As a SQL DBA for IMS team, I am responsible for responding to high-level troubleshooting requests from various teams and team members.
• Implemented the issues as per the user requirements.
• Troubleshooting on SQL Server Full, Differential, Transaction Log Backup Failures
• Troubleshooting on SQL Server Database Data File Full/ Log File Full issues.
• Good hands On Log shipping, Alwayson, Clustering and Mirroring.
• Worked on 2node and geo clustering.
• Worked under Active/passive Clustering environment.
• Implemented Log shipping and mirroring as a part of HA and DR.
• Supported Customer service databases which are more than 2TB.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Played an active role in requirements gathering, blueprint, design, configuration and documented
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Complete documentation about the database Created groups, roles, users and assigned access privileges to users.
• Scheduled jobs and alerts using SQL Server Agent.
• Documented HA and DR strategies and actively Participated in DR Test.
• Updating/Deleting Filestream Data.
• Implemented Robocopy process with SQL Agent to automate the file transfer
• Troubleshoot issues with Availability Groups/Replicas/Databases/Listener
• Handling issues with Databases out of sync in Availability Groups
• Configuring backup strategies for Databases in Availability Groups
• Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Experience in Performance Tuning, troubleshooting. Monitoring Dashboard Reports for Performance Tuning and finding bottlenecks in database.
• Expertise in handling Incidents, Service Requests.
• Replication, Always On Availability Groups and Clustering.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Monitoring the alerts of the job failures, log file issues and data file issues
• Involved In Building out New secondary Data- center servers, by configuring SQL 2005/2008/2012 with DR Strategy.
• Geo-Clustering with 2 and 3 nodes (multi-subnet.
• Experience working in Active/Passive, Active/Active cluster environment.
• Experience with HA/DR SAN Production environment - AlwaysOn,
• Expertise implementing high availability with Always on Availability Groups and failover clustering.

Environment: MS SQL Server 2008/2008R2/2012, Business Intelligence - MS SQL Server Integrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), SQL Agent, SQL Profiler, Comm Vault, Database Mail, T- SQL,Windows2003/2008 server, SQl sentry, Visual Studio.

Confidential 

Database Administrator

• Installation of Win 2003\2008\2008R2 OS, related IPAKS and latest hotfixes, assigning IP’s, forming and troubleshooting NLBS and MSCS Clusters on VM’s, physical machines and Blades.
• Managing VM’s trough Hyper - V.
• Configuring WINS and DNS on the servers.
• Converting Static IP to DHCP and vice-versa.
• Expanding the static scope if scarcity of IP’s.
• Managing added responsibility of Shift Lead as per project scope.
• Planning and Implementing MSCS and NLBS Clusters.
• Ensure project delivery as per ITIL standards.
• Mentoring new recruits in the Project on Virtualization\Server Administration. Documenting Processes, Tips for Trouble shooting issues.
• End-end project handling and client interfacing