SUMMARY

• I am a SQL Server DBA/Technical Lead having 13 years of experience in managing huge environments with high OLTP load with about 4000 Database Servers consisting of SQL versions from SQL 2000 to SQL 2019 with Servers located in DataCentres, IAAS and PAAS.I also have good exposure of managing Clusters as I have installed, configured and supported more than 200 Clusters located in same Datacentre as well as across multiple data centres and in Azure.I have Troubleshooted and resolve critical incidents that come up due to multiple reasons for database servers also joining MIM calls while troubleshooting the incident to keep updating the client with the status of the incident.
• I have designed, migrated and implemented end - to-end Database migrations solutions consisting of migration from OnPrem to IAAS and PAAS using Side by Side migration, ASR, Azure DMS,DMA etc.
• I have worked on setting up HA/DR technologies like Failover Clustering, Alwayson on both OnPrem and IAASsetting up DR solutions like Log shipping, Mirroring, Replication.
• I have worked on migrating Databases from various version from SQL 2005 Till 2019 both OnPrem and in Cloud.
• I have been designing solutions for Database migration for OnPrem and Azure running assessment reports and providing recommendations to client as to which will be best feasible Solution for migrating Application databases to DataCentre or IAAS or PAAS.
• I have rich experience In troubleshooting performance issues arising both in day today activities and also post DB migrations to latest SQL Server versions and to IAAS or PAAS.
• I have migrated SSIS packages from OnPrem to Azure SQL database using ADF .
• As a team lead, I have experience in Leading multi-cultural team, managing huge database environments, designing upgrade path, Client Demos, Tech Interviews, Knowledge Sharing Session.
• Last 1 year I have been getting involved into Azure Architect trainings and also with the exposure I got with the migrations
• From DataCentre to Cloud I was able to successfully complete the Azure Solutions Architect Certification.

TECHNICAL SKILLS

SQL Server Versions: SQL 2000,2005,2008,2012,2014,2016,2019

SQL on Azure: SQL server on Azure VMS,Azure SQL Database

Migration Tools: DMA,DMS,SSMS,Bacpac,Backup/Restore,ASR,Azure Migrate

Operating System: Win 2003,2008,2012,2016,2019

Monitoring Tools: Zenoss,SCOM,SQLSentry,Patrol,profiler,ResourceManager,LiteSpeed

Ticketing Tool: ServiceNow,Remedy,ServiceDesk

Backup/Restore Tool: Tivoli,Netbackup,Rubrik

Databases: MongoDB.

Services: SSIS,SSRS,SSAS,Vormetric Encryption.

PROFESSIONAL EXPERIENCE

Confidential

Team Lead

Responsibilities:

• Core area of skill is SQL Server Database Administration which includes Maintenance, Performance
• Tuning, Database Security Implementation, Backup & recovery, Migration, and other HA features.
• Worked on active\active clusters
• Performing DR test for servers on regular basis.
• Applying service packs on different nodes on clusters on both sql 2005,sql 2008,2012,2014.2016,2019
• Upgrading of sql server from legacy versions to latest one on various nodes on active\active clusters and also on standalone environment.
• Migrated report server from one server to another
• Installed, configured and manage sql server 2005,2008,2008 R2,2012.2014,2016,2019
• Migrating user databases and system databases
• Performing build QA for both standalone and cluster servers.
• Creating and managing database and database objects(tables,views)
• Backing up the databases and restoring them and creating the backup strategy.
• Simulating the different recovery scenarios
• Installed and configuring SQL Always ON clusters
• Worked on transactional and snapshot replication in complicated environments
• Single publisher-multiple subscriber scenario,also multiple publisher single subscriber
• Configured and Worked extensively on logshipping .
• Worked on mirroring
• Perform database refresh using IBM TIVOLI and taking backups using Tivoli whenever there is backup failure
• Migrated ssis packages as part of consolidation project
• Ssas administration ie.migrated cubes from one server to another,permissions management for ssas,processing the cubes
• Ssrs administration ie. Reports deployment,managing the datasources for reports,creating subscriptions for reports,managing permissions for users to reports
• Deployed ssis packages,migrated ssis packages from one server to another
• Performance and Tuning (Performance monitor,DMV’s) for troubleshooting and resolving application slowness
• SQL Agent Jobs creation and scheduling such as for backups,restores,indexing etc

Confidential

Support day to day activities

Responsibilities:

• Design Migration solutions for client database servers from legacy versions to latest offerings.
• Design the Proof of Concept for new technologies and features that come up for the database software.
• Setup HA/DR solutions for critical client applications to reduce the downtime in case of outage.
• Troubleshoot performance issues due to production deployments and also due to database migrations
• From legacy version to latest offering. Setup Single Publsiher,Multiple Subscriber topology replication as
• Per client requirement.Setup 3 node Multisubnet AlwaysOn Clusters for critical applications and worked on