SUMMARY

• SQL Server DBA having 10 Years of extensive experience in installation, configuration, implementation of SQL Server 2014/2012/2008 R2/2005/2000 on stand - alone and clustered instances.
• Extensive experience in designing and implementing High Availability (HA) and Disaster Recovery (DR) solutions like Clustering, log shipping, Replication, Mirroring and Always ON high availability Groups.
• Experience in Backup/ Restoration/ Recovery and Export/ Import of SQL Databases.
• Extensive experience in SQL server upgrades/migrates from SQL /2008R2, SQL R2, SQL 2008R2 to SQL 2012 and SQL Server 2012 to SQL Server 2014 in standalone and side by side.
• Extensive experience in managing DBA activities and critical projects to meet/exceed Service Level Agreements (SLAs).
• Extensive knowledge on Query Optimization, Tracing, Tuning Activities.
• Extensively used Database Performance Monitoring tools for performance tuning.
• Experience in Creating and Removing Indexes, Troubleshoot the existing poor performance Queries and recommend the fixes.
• Expert in using Bulk Copy Program(BCP), Data Transformation Services (DTS)packages andSSIS (integration services)with MS SQL Server 2000/2005.
• Experience in using SSIS(SQL Server Integration Services)for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools likeImport and Export Wizard, Package Installation and SSIS Package Designer.
• Experience in designing and developing SSIS packages for automating DBA Tasks such as Database refresh, Database status Checks.
• Experience in creating Active Directory Users and Groups and managing SQL Server security with active directory groups.
• Experience leading offshore teams to deliver mission critical projects on time.
• Experience in SQL patches upgrades (Service packs and Cumulative updates) by coordinating with the application teams.
• Extensive experience in change management process; Collaborating closely with developers, application owners and infrastructure staff in promoting development code to UAT for user acceptance testing and release in production for validation.

TECHNICAL SKILLS

BACKUP AND MANAGEMENT TOOLS: SQL Lite Speed, Tivoli backup tape(TSM)

MONITORING TOOLS: SCOM

TICKETING TOOLS: Remedy, Magic

DATABASES: SQL Server 2014/2012/2008 R2/2005/2000

MS DEVELOPMENT TOOLS: SQL Query Analyzer, DTS, SQL Profiler, BIDS, BCP, SSMS, SSRS, Import/Export Wizard.

OPERATING SYSTEMS: Windows Server 2012R2/2008R2/2003 / Advanced Server, Windows 98/XP/Professional.

PROFESSIONAL EXPERIENCE

Confidential, San Ramon, CA

Sr. SQL Server Administrator

Environment: SQL Server 2014/2012, T-SQL, SSIS, DMV.

Responsibilities:

• Provide on-call support and prioritized tickets based on severity.
• Installed and maintained SQL Server in a Clustered environment (Active/Passive).
• Upgrading servers from unsupported version to supported versions.
• Consolidated databases from multiple servers to one server during Data center consolidation.
• Migration experience fromMS SQL R2, SQL 2008R2 to SQL 2012 and SQL Server .
• Configuring and Troubleshooting Log shipping, Mirroring and Replication issues.
• Creation of Database and DB files, Users, Indexes and disk space maintenance.
• Implemented and Managed Performance Tuning Tasks with Developers in Optimizing the Long Run Queries.
• Identified, tested and resolved database performance issues to ensure data optimization.
• Used tools like SQL Server profiler, Performance Monitor (Perfmon) to identify bottlenecks
• Ensuring regular and timely Backup of databases on SQL Server (both native backups and SQL lite speed backups).
• Archiving and Decommission the databases for retired applications as per standards.
• Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Performed Database Upgrades from 2008R2 to 2012 and .
• Configured and installed SQL Sentry monitoring tool across the production environments.
• Created SSIS packages and SQL Agent jobs to automate data refreshes from production to UAT servers.
• Implemented Clustering features in SQL Server with Nodes and Functions.
• Configured the AlwaysOn to run the reports on secondary database.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, integrity verification and replication verification and indexing updates.
• Implemented System wide Security Policies & trouble shooting methodologies.
• Troubleshooting high availability and disaster recovery scenarios involving Clustering, Database, Log Shipping, High Availability Groups and Replication.
• Collaborated closely with application owners and developers on issues such as SQL Server upgrades (Service Pack, hotfix patch upgrade etc.) and weekly production releases.
• Configured and managed SQL Server transactional replication and troubleshoot issues.
• Performed ad-hoc database backups and restores and fixed orphaned logins.
• Maintained security policies. Managed Logins and User: adding logins roles, groups to the Windows Server and MS SQL Server and maintaining proper security procedures.
• Checked Database Health by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Prepared Documentation for theDisaster Recovery plan.
• Designed Data Integrity jobs with Error Handling and email notifications.
• 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.

Confidential

Sr. SQL Server Administrator

Environment: SQL Server 2008R2, 2005, DMV.

Responsibilities:

• Understand infrastructure and technical environment of the application.
• Participated in business requirements sessions to understand the systems.
• Working collaboratively with Clients DBA Team in finalizing the DBA activities.
• Performed Installations and configurations of SQL Server in prod and dev environment.
• Performed Installation of Service Packs and applied security patches.
• Creating Databases, Security & User Administration.
• Performed Troubleshooting using SQL Profiler and customized scripts.
• Responsible for DB server error log monitoring - to trace and identify issues reported by the SQL Server within environments and offer potential solutions.

Confidential

SQL Server Administrator

Environment: SQL Server 2008R2, 2005, SSIS, DMV.

Responsibilities:

• Configure and scheduled Database Backups and maintenance jobs as per business requirement.
• Check the database for any torn page errors by running DBCC checkdb command
• Installation and configuration of SQL Server 2005/2008/2008 R2 components.
• Latest SQL server service packs Installation.
• Analyzed the long running and high CPU utilized queries on the server by using profiler and performance monitoring.
• Created transactional and snapshot replication on different servers.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Implemented Clustering features in SQL Server with Nodes and Functions.
• Created, Removed and rebuilt the indexes at regular intervals for better performance of Queries and Packages.
• Monitored and modified Performance using execution plans and Index tuning.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Completed documentation about the Database. Recovering the databases from backup in disasters.
• Exported or Imported data from other data sources like flat files using Import/Export through DTS, SSIS.

Confidential

SQL Server Administrator

Environment: SQL Server 2005, 2000, SSIS, DTS, Tivoli Backup.

Responsibilities:

• Administration of SQL servers in 24 x 7.
• Tickets handling based upon the Priority (Like urgent, High, Medium, Low)
• Installation and configuration of SQL Server 2005/2008/2008 R2 components.
• Performed the migration of SQL Server 2000 to SQL Server 2005.
• Ensuring regular and timely Backup of databases on SQL Server native backups and tape (TSM) backups.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Experience in trouble shooting Client connections, viewing error logs and application logs.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• 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.
• Maintained the database consistency with DBCC at regular intervals.