SUMMARY

• Nine+ years of IT experience in Database Administration, System Analysis and Design, Development and Support for MS SQL Server.
• Expertise in Managing PRODUCTION Databases on MS SQL Server 2019/2017/2016/2012 in VIRTUAL and PHYSICAL environments.
• Managed MS SQL Servers in High Availability and Disaster Recovery environments
• Provided 24/7 and on - call Support for PRODUCTION environment
• Expertise in Database Administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database Designing and Query Optimization.
• 4+ Years’ experience in setting up Always ON Availability groups.
• Managing Virtual Machines in IAAS & PAAS, supporting max size of 4 TB hosted in Microsoft Azure.
• Expert in Migrating On Premise SQL Databases to SQL Azure using DMA & DMS(Offline & Online).
• Having experience in configuring Virtual machines using Azure portal.
• Having experience in creating the alerts for VMs using Azure Portal.
• Reviewing the Activity logs and troubleshooting the errors.
• Having knowledge on configuring managed disks and un managed disks in Azure.
• Configured Log Analytics for Virtual Machines and SQL AZURE Pass databases.
• Having knowledge on storage accounts and storage replications.
• Experience in moving on premises MS SQL Server databases to Azure using bacpac files.
• Experience in creating the database maintenance tasks using Azure Automation.
• Experience in working with Azure SQL Database Import and Export Service.
• Experience in working with Point in time restores in Azure.
• Configured Long Term Retention (LTR) backups for Mission critical databases.
• Configured on-premises SQL database backups to Azure using Microsoft Azure Backup tool.
• Creating logins, users and assigning the permissions to the users in Azure.
• Configured Active Geo Replication, Failover Groups using Azure portal.
• Monitoring the alerts using the Operations Management Suite (OMS) in Azure portal.
• Expertise in ACTIVE/ACTIVE and ACTIVE/PASSIVE Clustering.
• Experience in implementing Disaster Recovery and High Availability Solutions using Database Mirroring and Log Shipping.
• Hands on experience in Backup and Restoration of databases, Automating Administration and Security maintenance.
• Performed Capacity Planning, Data Modeling and Logical/Physical database design.
• Strong experience in performing database consistency checks and planning and scheduling Recovery Procedures.
• Configured and maintained Transactional and Snapshot replication.
• Estimated disk storage requirements for database software, files & database administration needs.
• Monitored the database server performance and if required and tuned, if required TSQL queries, Stored procedures etc.

TECHNICAL SKILLS

• Microsoft SQL server 2019/2016/2012
• Azure Managed SQL instance (IaaS)
• Windows
• VMWare
• MS Azure
• SQL Server Integration Services (SSIS)
• SQL Server DTS
• SSDT
• Visual Studio
• Erwin
• Microsoft Visio
• SQL server Management Studio
• SQL server Query Analyzer
• SQL server mail service
• DBCC
• BCP
• SQL server profiler
• Event Viewer
• Index Tuning Wizard
• SQL Server Agent
• Extended Events
• SSRS
• SQLCMD

PROFESSIONAL EXPERIENCE

Confidential, DC

Senior MS SQL Server DBA

RESPONSIBILITIES:

• Lead a team of total 7 DBA’s. 3 offshore and 4 on shore.
• Monitoring environment and pro-actively guiding team.
• Proposed cloud integration across the firm.
• Worked on designing / architecting and supporting databases with more than 2-4 TB in size.
• Managed Database Development and Operational database teams, managing the full-time resources, setting goals and their performance management.
• Worked on identifying Infrastructure architectural issues and proposing alternate solutions.
• Budgeting and capacity planning, as well as systems performance and uptime management.
• Manage 24/7/365 operations in a business-critical environment.
• Manage day-to-day database operations and DBA charters for production databases and projects. This includes database administration, planning, design, build/delivery, deployment, monitoring, standards, compliance, etc. for production, production operations, monitoring, project builds & delivery, deployments, etc.
• Managing Virtual Machines in IAAS & PAAS, supporting max size of 4 TB hosted in Microsoft Azure.
• Migrated On Premise SQL Databases to SQL Azure using DMA & DMS(Offline & Online).
• Configured Virtual machines using Azure portal.
• Created alerts for VMs using Azure Portal.
• Reviewing the Activity logs and troubleshooting the errors.
• Configured managed disks and un managed disks in Azure.
• Configured Log Analytics for Virtual Machines and SQL AZURE Pass databases.
• Having knowledge on storage accounts and storage replications.
• Worked in moving ON Premise SQL Server databases to Azure using bacpac files.
• Created the database maintenance tasks using Azure Automation.
• Worked with Azure SQL Database Import and Export Service.
• Experience in working with Point in time restores in Azure.
• Configured Long Term Retention (LTR) backups for Mission critical databases.
• Configured on-premises Sql database backups to Azure using Microsoft Azure Backup tool.
• Creating logins, users and assigning the permissions to the users in Azure.
• Configured Active Geo Replication, Failover Groups using Azure portal.
• Monitoring the alerts using the Operations Management Suite (OMS) in Azure portal.

Confidential, Chicago, IL

Senior MS SQL Server DBA

RESPONSIBILITIES:

• Worked primarily as lead DBA to improve database performance.
• Led overseas DBA team training to understand and support the environment.
• Installed and configured SQL Server 2012, 2016, 2017
• Configured and managed SQL 2012, 2016 and 2017 Always on High availability (HADR/ Replica) for Relativity Database. Planned and upgraded Relativity application from 9.2 to 9.6 version and implemented database changes.
• Automated Adding of Databases into Always on Groups.
• Automated Login transfer between Always on Nodes.
• Configured Always on Databases health checks.
• Automated SQL install by providing SQL.INI file to VM team.
• Configured SSRS services with Always on Availability.
• Created workflow to restore client databases in environment for in-house analysis.
• Administer, support and monitor multiple SQL Server databases.
• Created and Implemented disaster recovery plan for critical analytics SQL Server.
• Created and managed schema objects such as tables, views, indexes, procedures, and triggers & maintained Referential Integrity.
• Monitored MS SQL Server performance and network issues.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations.
• Controlled user access rights, and managed data security at rest.
• Managed Microsoft Active\Active and Active\Passive Cluster for SQL Server 2012 and higher version.

Confidential, Bridgewater, NJ

MS SQL Server DBA

RESPONSIBILITIES:

• Worked primarily as a PRODUCTION support DBA giving 24/7 Support
• Managed PRODUCTION, DEVELOPMENT, QA and UAT environments
• Worked extensively on Virtual and VMware Environments.
• Migrated Databases from Physical to Virtual environment.
• Involved in Performance Tuning on Production, QA and Staging servers of the current project.
• Managed Production environment for High Availability in Active/Active and Active/Passive mode
• Involved in Monitoring Performance of different production servers.
• Implemented Database mirroring and Log Shipping for disaster recovery.
• Maintained various databases for Production and Testing using SQL Server 2008 R2.
• Performance tuning and optimization of procedures and queries.
• Extensive use of SQL Server DMV's for Performance Tuning.
• Worked extensively with SQL server Profiler.
• Created the backup and restore strategy for the production and development environment.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
• 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.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them.
• Performing fine Tuning of Database Application. Cleansing and solving Database troubles.

Environment: SQL Server 2008 R2/2012, VMware, Virtualization, Diagnostic Manager