PROFESSIONAL SUMMARY:

• Having 12 plus years of experience in Information Technology out of which 10 plus years of experience in SQL Server Database Administration (DBA) with extensive experience in SQL Server Installation, Migration, Troubleshooting in Clustering (Active - Active, Active - Passive) and Non-Clustering environments. Extensive experience in Windows Server Administration, IIS, Confidential, AWS, AZURE, DevOps, SharePoint 2012, Oracle 12c, Power Shell, Linux.
• Experience in MS SQL Server performance tuning along with SQL Profiler, client/server connectivity, query optimization, Database Maintenance plans, Database Consistency Checker using DBCC.
• Experience in Supporting Large Databases, Troubleshooting and documenting root cause analysis
• Experience in SQL Server Automation using DevOps tools (Ansible, Bitbucket, Ansible Tower, Yaml, T-SQL, Power Shell)
• Implemented Resource Governor on AlwaysOn Availability Group in busy Application Production environment.
• Design, configuration and installation of Multi-subnet AlwaysOn cluster.
• Expert in Mirroring, Log shipping and Replication. Did POC on SQL on Linux.
• Automation of SQL Server Administration activities using PowerShell.
• Experience in AWS and Confidential Azure Cloud technologies.
• Worked exclusively on active/active and active/passive clustering.
• Experience in all phases of software development life cycle (SDLC).
• Expert in Backup and Recovery schedules and troubleshooting.
• Expert in design and implementation of Archival and Purging.
• Experience in DTS to SSIS migration.
• Experience on upgrading from SQL Server to 2008 R2 to
• Experience on migrating databases from one datacenter to another datacenter and cloud.
• Experience on SSIS, SSRS and SSAS
• Expertise in SQL Server Security (TDE, Backup Encryption, Always Encrypted)
• Extensive experience on working with SOX Security and Audit compliance.
• Experience in identifying the I/O and memory, bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler.
• Experience in Data partitioning for large tables to increase performance by paralyzing the I/O.
• Excellent communication, presentation and interpersonal skills
• Strong troubleshooting and organizational skill
• Knowledge in Oracle, MySQL
• Hands on experience in Incident, Change and Problem Management.
• Experience in Offshore/Onsite Team management
• Strong analytical skills with ability to quickly understand client’s business needs.
• Involved in meetings to gather information and requirements from the clients.
• Research-oriented, motivated, proactive, self-starter with strong technical, analytical and interpersonal skills.

TECHNICAL SKILLS:

Databases: SQL Server 2000/2005/2008/2012/2014/2016 , 2017 Enterprise, Oracle, MySQL

Languages: C, C++, C#, VB, T-SQL, PL/SQL, java, Visual Studio, PowerShell

Operating Systems: Linux, Ubuntu, Windows NT/ 2000/2008/2012/2016.

Monitoring Tool: Confidential Operations Manager 2005 (MOM), SCOM, Lite speed, SQLSentry, Spotlight, Erwin and RegGate.

Cloud: Confidential Azure and AWS

PROFESSIONAL EXPERIENCE:

Senior SQL Server DBA

Confidential, Marlborough, MA

Responsibilities:

• Implementing SQL Server Automation using DevOps tools, Created a Ansible Playbooks on Windows Server 2012/2016 to Automate SQL Server installation 2012/2016 which includes (SQL Server Installation, Service Pack, SQL Hardening and Post Installation Maintenance Jobs).
• Working on Ansible playbook to automate SQL Server Environment end to end (includes WFCS, AlwaysOn Availability and IIS Application Configuration)
• Implemented Resource Governor on Availability Groups.

Senior SQL Server DBA

Confidential, Englewood, CO

Responsibilities:

• Did architecture and design of consolidated application running on SQL Server.
• Configured IIS server in Confidential Azure Cloud.
• Configured SQL Server in Azure cloud.
• SQL Server Installation and upgrade.
• Managing Share Point 2012 site
• Regular DBA activities.

Senior SQL Server DBA

Confidential, New Hampshire, MA

Responsibilities:

• Created and scheduled a SSIS package for missing indexes, blocking and index fragmentation reports and configured database mail to deliver these reports.
• Replaced regular backup and index maintenance jobs scripts to improve the performance.
• Did design and build of multi-subnet Always On clusters on SQL Server 2012/2014/2016.
• Design and development of SQL Servers inventory reports using SSRS.
• Involved in implementation of SQL Server Security (TDE, Backup Encryption).
• By using 3rd party SQL Management Tools like Quest Spot Lite and Redgate tools monitoring the process, maximum optimization, diagnosis resource utilization like disk space used in percentage, IO/CPU bottlenecks.
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Involved in SQL Server migration from version /2016.
• Presented demo to client on SQL Server.
• Install, upgrade, configuration of MS SQL Server /2008 R2/2012/2014 in clustered and stand-alone environments.
• Refreshing databases from production server to production support and other servers for testing and upgrading data in databases.
• Attend meeting with business units and other support team like server engineers, network engineers, application support team, developer etc for project related solution and production support needs.
• Provided SQL Server DBA support to SharePoint servers.
• Worked with Confidential support teams on critical issues.

Senior SQL Server DBA

Confidential, Mountain View, CA

Responsibilities:

• Involved in SQL Server migration from to 2008.
• Performed migration of SQL Server production servers from one data center to another data center.
• Did root cause analysis of blocking and performance issues.
• Reduced run time of critical SQL Server jobs with the help of fine tuning of queries and indexes.
• Performed archival and purging of data without impacting performance of production server.
• Did database design and performance tuning for SSRS reports.
• Migrated DTS Packages from SQL Server as SSIS Packages.
• Created triggers stored procedures, databases, tables and queries.
• Implemented backup and retention strategies based on business policies.
• Created user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts and granting the privileges to users and groups.
• Involved in installing Service Packs, patches and hotfix for SQL Server.
• Migration of Dev/Test SQL Server to Azure Cloud.

Senior SQL Server DBA

Confidential, Atlanta, GA

Responsibilities:

• SQL Server installation and troubleshooting of installation failures.
• Involved in installation of SQL Server on Windows cluster.
• Database security management.
• Setting up Mirroring/Log Shipping/Replication.
• Perfumed migration of transaction replication distributor from one server to another server.
• Performed Isolation level change at SQL Server level.
• Fixed database corruption issues using DBCC utilities.
• Provided RCA of Sev1 and Sev2 database issues.
• Provided DBA support to application teams for releases on UAT and Production environments.
• Scheduled SQL Agent jobs for full, Differential and Transaction log backups and suggested backup strategies.
• Involved in installing Service Packs, patches and hotfix for SQL Server.
• Troubleshooting SQL Server service outages as they occur.

SQL Server DBA

Confidential, Palo Alto, CA

Responsibilities:

• Co-ordination with the other application teams for smooth functioning and end-to-end completion of process.
• Performing System Acceptance Testing (SAT) in SAT Bed and Operation Readiness testing (ORT) Production Bed.
• Involvement of UAT.
• Clarify database Updating & Management.
• Created user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts and granting the privileges to users and groups.
• Involved in installing Service Packs, patches and hotfix for SQL Server, Error Handling