PROFESSIONAL SUMMARY:

• Database Administrator with more than 12+ years of experience implementing, maintaining SQL server solutions in an Enterprise environment.
• A detail - oriented, reliable, responsible and self-motivated team player.
• Extensive experience in working with HA and DR solutions.
• Cloud/Azure experience includes Azure Services, PaaS, IaaS, and Migrated from premises databases and Legacy databases to Azure, deployed products on Azure, Setup development and test environment on Azure
• Strong business and technical vision with effective people skills, ability to manage multiple complex projects, innovative and creative problem solver, results oriented, and has an aptitude for learning and can maximize resources while possessing a sense of urgency.

TECHNICAL EXPERTISE:

• SQL Server Administration
• SQL Server High Availability & DR
• Performance Tuning and Capacity Monitoring
• SQL Server Encryption & Security
• PCI & SOX compliance
• SQL Server Disaster Recovery
• SQL Server Consolidation
• SQL Server Virtualization
• SQL Server Upgrades
• SQL Migration between Different RDBMS

TECHNICAL SKILLS:

Databases: MS SQL Server 2016,2014, 2012, 2008, MS SQL Server 2005, 2000

Programming: VB, CMD, TSQL, PowerShell

DBA: Database Administration of MS SQL Server 201, 2008, 2005, 2000, SSIS, SSRS

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

Tools: Red Gate, EMC Data Domain, Spotlight

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

WORK HISTORY:

Sr. SQL Server DBA

Confidential, Orlando, FL

Responsibilities:

• Discovering SQL Server instances into organization, Build inventory to optimize required SQL licenses
• Design, architect infrastructure and strategies to fulfill database build, security, maintenance and support for Vendor and in-house developed software applications
• Administration and Management of 450+ SQL Server Instances into PROD, DEV, QA, Load, DR environments
• 6TB Largest DB supported and maintained
• Responsible for the health and stability of global Confidential SQL Server and related technological platform
• Install, Upgrade, Migration, Consolidation of SQL Servers to SQL Server 2016 on VMWare platform
• Managing critical VLDB, AlwaysOn, SQL Server Failover Clustering, Mirroring, Log-Shipping, Replication
• Performance and Tuning of SQL Server using Index tuning, profiler, PerfMon, DTA and DMVs
• Automation of Maintenance - Backup/Restore, Rebuild Index, DBCC CHECKDB, Update Stats, Batch jobs, SQL Builds, Patching, Security PCI Data pull, Partition Maintenance
• Leading projects, management and co-ordination with teams to follow Change control and resolve tickets
• Administration, maintenance, Backup/Restore, Migration of SQL databases on Confidential Azure
• Expertise experience with SQL Data Domain tool\RedGate
• User, Documentation, Troubleshooting, Event & Incident management and DBA support, T-SQL, VM Ware, Veritas, Litespeed, SSIS, SSRS, Replication.

Sr. SQL Server DBA

Confidential, Redmond, WA

Responsibilities:

• Management and Administration of 50+ SQL Server Instances into PROD-DR-UAT-DEV environments
• Responsible for the health and stability of global Confidential SQL Server and related technological platform
• Design and implement standards, policies, and operational procedures for Database backup/Restore, Security, Performance Tuning, Monitoring, Maintenance, Disaster Recovery and application support
• Managing critical VLDB, AlwaysOn, SQL Server Failover Clustering, Mirroring, Log-Shipping, Replication
• Install, Upgrade, Migration, SPs, CUs of Versions - SQL Server 2005/ 2008 R2, SQL Server 2012
• Performance and Tuning of SQL Server using Index tuning, profiler, PerfMon, DTA and DMVs
• Automation of Maintenance - Backup/Restore, Rebuild Index, DBCC CHECKDB, Update Stats, Batch jobs
• Leading projects, management and co-ordination with offshore teams to release CO and SD tickets
• User, Documentation, Troubleshooting, Event & Incident management and DBA support

SQL Server OPS DBA

Confidential, Tampa, FL

Responsibilities:

• Managed over 1300+ Serves with 3TB large db
• Providing support to Production and Application Environment.
• Participating in Data Center Migration Activities, in different methods i.e. BMR, Virtual and Physical Move. Troubleshooting issues occurred during Migration.
• Responsible for Installation, Configuration and Complete Administration of MS SQL Server 2005/2008/2008 r2 on windows 2003/2008 Servers.
• Successfully upgraded the databases from SQL Server 2000 to SQL Server 2005/2008/2008 r2.
• Monitoring and Troubleshooting jobs in Production, Stage and Development environment.
• Monitoring and troubleshooting SQL Agent Jobs including backup and batch jobs.
• Monitoring and Troubleshooting Cluster Resources in all other environments.
• Installed SQL Server 2000/2008 on Active/Active and Active/Passive Multi Cluster Nodes.
• Provided 24X7 production support for database and application issues.
• Documented the results from the upgrade advisor and resolved the all issues encountered while migrating from SQL Server 2000/2005/2008.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Performing query plans and making sure each and every query is using appropriate indexes.
• Export and Import of data from text files and Excel to SQL Server database using Bulk Copy Insert and BCP utility.

Jr.SQL Server DBA

Confidential

Responsibilities:

• Installed, Configured and Administered SQL Server 2005.
• Involved in upgrading SQL Server .
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Extensively used SQL Server BCP Utility, DTS Import/ Export to load the database from text files received from different applications.
• Involved in configuring servers to implement high availability scenarios (Log shipping).
• Involved in implementing replication.
• Involved in creation of DTS Scheduled Packages for the daily transfer of data from SQL Server Databases to Oracle database.
• Performance tuning and testing on stored procedures, indexes, and triggers.
• Configured the Linked Server with the Oracle database.
• Established backup and recovery procedures for databases and implemented automated jobs for backup.
• Monitoring SQL server performance using profiler and Windows System Monitor.
• Creating Maintenance plans, creating alerts and automating jobs.
• Setup the performance counter by using performance monitor to identify the bottleneck of windows server such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
• Automated consistency check of the database (DBCC) for SQL Server.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Monitoring the data file, transaction log and temp DB growth.
• Involved in applying Patches to SQL Server.
• Detected and corrected bugs during system integration and user acceptance testing.
• Set up a fail-over environment to support a production environment, monitoring the stand by server.
• Ability to handle multiple tasks and capable of handling responsibilities independently as well as a proactive team member.