SUMMARY

• Having 9+ years of experience in SQL database admin with Azure Cloud.
• Migrated databases from on - premises to Azure using different methods DMA, BACPAC and DMS.
• Migrated databases from on-premises to IAAS (SQL on VMS).
• Migrated databases from on-premises to PAAS (BACPAC, DMS).
• Experience in creating and monitoring Azure SQL Server databases. Configured and Maintained Elastic DB pools.
• Experience in configuring and monitoring Geo Replication
• Configured failover groups to provide high availability for PAAS SQL Server.
• Experience configuring backups and restoring database from recovery vault.
• Good experience in azure services like VMs, azure load balancers and azure storage services.
• Designed and Implemented NSGS to control inbound and outbound access to NICS, VMS and SUBNETS.
• Configured and Implemented point-to-site and site-to-site connections.
• Configuring & Managing Load Balancer Using Basic and Standard Load Balancer.
• Configuring & Managing Traffic Manager Profiles with different Routing methods.
• Configuring server Backups, Recovery files by Recovery Service Vault.
• Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2008 R2, 2012 & 2016.
• Good Experience in upgrading service pack for SQL Server 2008 R2, 2012 & 2016.
• Upgrading the environment from SQL Server 2008 to SQL Server 2012 and 2016 using side by side approach.
• Creating and monitoring jobs for daily Maintenance tasks like backups.
• Checking integrity of databases, updating statistics and index maintenance
• Monitoring growth of the databases, as a part of capacity planning.
• Experience in Database administration activities forDB Security(creating logins, users, roles, and assigning permission to them).
• Experience in Maintaining and scheduling SQL backup jobs, restoration jobs.
• Optimization jobs and checking alerts if it fails and resolving them.
• Experience with high availability solutions as Log Shipping and Database Mirroring.
• Experience with high availability solutions as Always on Availability group.

TECHNICAL SKILLS

Azure SQL: PaaS, IaaS

Database: Microsoft SQL Server 2016, 2012, 2008 R2

Languages: SQL

Tools: SQL Profiler, Performance Monitor, SSMS

PROFESSIONAL EXPERIENCE

Confidential, GA

Azure SQL DBA

Responsibilities:

• Configuring Azure Services PaaS, IaaS and Migrated databases from on-premises to Azure.
• Experience in creating and monitoring Azure SQL Server databases. Configured and Maintained Elastic DB pools.
• Experience in configuring and monitoring Geo Replication
• Configured failover groups to provide high availability for PAAS SQL Server.
• Experience configuring backups and restoring database from recovery vault.
• Provided high availability for IaaS VMs and PaaS role instances for access from other services in the VNet with Azure Internal Load Balancer.
• Experience implementing TDE (Transparent Data Encryption) and DDM (Dynamic Data Masking) Features.
• Experience in migrating the on-premise database to Cloud and from cloud to on premise using multiple methods.
• Handling connectivity issues from VM, SSMS, using Azure private link, VNet issues and from other resources hosted on Azure.

Confidential

SQL Admin with Azure

Responsibilities:

• Good experience in azure services like VMs, azure load balancers and azure storage services.
• Designed and configured azure VNets, subnets, inbound and outbound rules based on requirement.
• Involved in installation & configuration of SQL Server 2012//2014/2016/2017/2019.
• Involved in Applying latest patches and CU’s.
• Having Experience to handle the issues to TempDB is full and log file is full.
• Having experience on moving system databases and rebuilding Master/MSDB databases.
• Check OS Event Logs and SQL Server Logs for unusual events.
• Monitoring log space, Disk Space, event logs and SQL Server error logs.
• Monitoring SQL Server performance by finding Deadlocks and Blocking.
• Designed and Implemented NSGS to control inbound and outbound access to NICS, VMs and SUBNETS.
• Good experience on VNET PEERING.
• Configured and Implemented point-to-site and site-to-site connections.
• Configuring & Managing Load Balancer Using Basic and Standard Load Balancer.
• Configuring & Managing Traffic Manager Profiles with different Routing methods.
• Designed& Implemented Storage Accounts-Blob, File share.
• Configuring server Backups, Recovery files by Recovery Service Vault.

Confidential, TX

Database Administrator

Responsibilities:

• Involved in installation & configuration of SQL Server 2012//2014/2016/2017/2019.
• Involved in Applying latest patches and CU’s.
• Having Experience to handle the issues to TempDB is full and log file is full.
• Having experience on moving system databases and rebuilding Master/MSDB databases during crash situations.
• Check OS Event Logs and SQL Server Logs for unusual events.
• Monitoring log space, Disk Space, event logs and SQL Server error logs.
• Monitoring SQL Server performance by finding Deadlocks and Blocking.
• Managing Security (Creating users, logins, and roles, granting permissions) & Fixing
• Orphaned users.
• Performing automation and manual Backup and Restore Databases in SQL Server.
• Restoring the Databases from Production to test environment and vice versa.
• Experience on SQL HA features Log shipping, Replication, Always-On and Clustering.
• Monitoring SQL Server Agent, Performance Tuning, Database Backups and to check if the SQL instances are all up and running and accepting user connections.
• Participating in all team meetings and T-CAB & B-CAB, conducted for the improvement f the operational and workflow.
• Daily Log checking for errors on Production Server and Non-Prod server also.
• Good troubleshooting and problem-solving skills in SQL Server environment.
• Providing On-Call supports on weekends for all the server

Confidential

Database Administrator

Responsibilities:

• Daily checking the assigned tickets and resolve the tickets depends on the priority levels.
• Daily checking the issues like backup failures, failed logins and resolve the issues.
• Monitoring the TempDB full and transactional log full issues.
• Changing the recovery models whenever necessary.
• Database installation and administration of MS SQL Server 2008r2 and 2012.
• Performing the Cluster installation and adding the nodes in the respective servers in SQL Server 2005 and 2008R, 2012, 2014, 2016.
• Protecting the databases by taking different kinds of Backups such as Full, Differential, and Transactional log backups.
• Data base mirroring configuration.
• Resolves database performance issues, database capacity issues and other data issues related to database.
• Maintain database consistency check using DBCC commands.
• Performing the Failover and Failback operations in the cluster environment and adding the new Disks and troubleshooting activities
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
• Migration and up gradation of servers and databases
• To analyze long running slow queries and tune the same to optimize application and system performance.

Confidential

Database Administrator

Responsibilities:

• Installing and Configuring SQL Server.
• Creating Databases and Consistency Checks.
• Database Administration and Maintenance.
• Backing up and restoring the databases.
• Setup up regular backup, recovery and restoration.
• Taking regular full, transactional backups.
• To take the daily Back Up, in a separate Back Up folder and store it in tape.
• To maintain the Databases, such as creation, modification or deletion of tables.
• Involved in installation & configuration of SQL Server 2008, 2008R2, 2012
• Involved in Applying latest patches and CU’s.
• Having Experience to handle the issues to TempDB is full and log file is full.
• Having experience on moving system databases and rebuilding Master/MSDB databases during crash situations.
• Check OS Event Logs and SQL Server Logs for unusual events.
• Monitoring log space, Disk Space, event logs and SQL Server error logs.
• Monitoring SQL Server performance by finding Deadlocks and Blocking.
• Managing Security (Creating users, logins, and roles, granting permissions) & Fixing Orphaned users.
• Performing automation and manual Backup and Restore Databases in SQL Server.
• Restoring the Databases from Production to test environment and vice versa.
• Experience on SQL HA features Log shipping, Replication, Always-On and Clustering.
• Monitoring SQL Server Agent, Performance Tuning, Database Backups and to check if the SQL instances are all up and running and accepting user connections.
• Daily Log checking for errors on Production Server and Non-Prod server also.
• Good troubleshooting and problem-solving skills in SQL Server environment.
• Providing On-Call supports on weekends for all the server
• Verifying & resolving the SQL Server Blocking issues &finding and fixing the root cause.
• Resolving the Disk space issues and finding the root cause and permanent fixes.
• Designing a successful backup strategy to ensure backups are done at regular intervals.
• Ensuring data consistency in the database through DBCC commands.
• Daily Log checking for errors on Production Server.
• Good experience in resolving blockings and Deadlock Issues by using SQL commands.