Objective

SQL Server DBA with Overall *.*Years of Experience and Willing to Work in a Challenging my Team and Organization there-by improving my Knowledge and Technical Skills.

Professional summary

Experience in Database administration activities like Installation, Configuration, Backup & Recovery and Database Security.

Extensive Knowledge on Successfully Troubleshooting Various SQL Server Issues.

Experience in Azure IaaS and PaaS Environments.

Experience in Managing and Troubleshooting Database issues in Azure.

Experience in Analyzing, Resolving Performance Issues and Provide Recommendations.

Extensive Knowledge of Database Migration, Database Refresh Activities.

Experience in Creation, Management and Troubleshooting of High Availability Solutions Such as AlwaysOn, Replication and Log Shipping.

Experience on implementing TDE encryption like column level as well as database level.

Experience on creating changes and attending CAB meetings for approvals.

Experience in Index Analysis and Providing Index Recommendation based on the Analysis.

Experience on Microsoft Parallel Data warehouse Deployments and Troubleshooting issues.

Hands-on Experience in Managing User Security, Capacity Planning, SQL Patching.

Experience on Cluster installation and Veritas Cluster Installation.

Experience on Double take replication at SAN level.

Hands-on Experience in Various SQL Monitoring Tolls Such as SQL IDERA.

Experience in Deployment and Migration of SSAS Cubes.

Experience in Installation, Configuration, Migration and Troubleshooting of SSRS Environments.

Experience in Deployment and Troubleshooting of SSIS.

Experience in Developing T-SQL, PowerShell Scripts.

Excellent Team Player and 24/7 Production Experience.

Education

MTech in Computer Science Engineering- SRM University Completed: may-2014

Technical skills

SQL Versions

: SQL Server 2017/ 2016/ 2012/ 2008R2/ 2008/ 2005

Server OS Versions

: Windows Server 2005/ 2008/ 2008R2/ 2012/ 2012R2/ 2016

Tools

: Idera SQL, IBM Tivoli, Emc networker

Datawarehouse

: SSIS, Microsoft Parallel Datawarehouse

Ticketing Tools

: BMC Remedy,CISM

Professional Experience

Mercedes-Benz Research & Development India, BANGALORE Nov -2019 to till date

Role: Senior consultant

Responsibilities:

Resolving incidents, Problem tickets by providing the root cause.

Leading teams for Major activities like DR, storage migrations, sql server migrations.

Experience on sql Backup restores by using third party tool IBM Tivoli, EMC Networker.

Experience on high availability solutions like Log-shipping, Mirroring, Replication, Always On Availability Groups.

Having hands on experience in trouble shooting performance issues like slow running queries.

Experience in trouble shooting and fine-tuning of databases for its performance and concurrency using Database Tuning Advisor, sql profiler, performance monitor, IDERA.

Experience on Cluster installation and adding the nodes in the respective servers in SQL Server 2012, 2014, 2016 and 2017.

Experience on implementing TDE encryption like column level as well as database level.

Having Knowledge on Development, which will use to pull the consolidated reports like all database backup reports, server details, finding the frequency of index fragmentation for particular databases for a time etc.

Creating changes and attending CAB meetings for approvals.

Experience on supporting Azure vm's and Azure sql databases in both IAAS and PAAS.

Experience on Patching and Service pack installation.

PRAMATHI TECHNOLOGIES, BANGALORE June-2017 to Nov-2019

Client - Arthur J Gallagher, Role - SQL DBA

Responsibilities:

Daily checking the assigned tickets and resolve the tickets depends on the priority levels.

Experience in database migration from SQL Server 2008R2 to SQL Server 2014, 2016, 2017.

Resolving the issues like backup failures, failed logins.

Resolving disk space issues and data base growth issues.

Patching and Service pack installation.

Implemented Backup plans like Daily, weekly basis.

Experience on high availability solutions like Log-shipping, Mirroring, Replication, AlwaysOn Availability Groups.

Experience on supporting Azure vims and Azure sql databases in both IAAS and PAAS

Experience on SQL IDERA monitoring tool.

Experience in trouble shooting and fine-tuning of databases for its performance and concurrency using Database Tuning Advisor, sql profiler, performance monitor, IDERA.

Experience on SSIS and SSRS Deployments.

Experience on migrating SSRS and SSIS from lower to higher versions.

Experience on Veritas cluster installation in SQL 20008R2, SQL 2012,2014,2016,2017.

Activities like backup, restore, recovery, data archival.

Experience on handling the Tempdb full and transactional log full issues.

Having hands on experience in trouble shooting slow performance issues.

Experience on Cluster installation and adding the nodes in the respective servers in SQL Server 2012,2014,2016 and 2017.

Having Knowledge on Development which will use to Pull the consolidated reports like all database backup reports, server details etc.

CRYPTOGRAPH TECHNOLOGIES, BANGALORE June-2015 to June2017

Client - CenturyLink, Inc., Role - SQL DBA

Responsibilities:

Having Knowledge on Development, which will use to pull the consolidated reports like all database backup reports, server details etc.

Experience in Installation and Configuration in different versions like SQL Server 2005, 2008, 2008R2, 2012.

Set up Database backup jobs for more efficient recovery by setting up FULL/Differential backup and more frequent transaction log backup for more dynamic databases.

Creating user logins and providing access to users on databases and server.

Installing Default/Named instances of SQL servers 2005/2008/2008R2 on standalone servers.

Upgrading SQL servers by applying Service packs, Security patches and Hot fixes.

Upgrading/Migrating the databases from earlier versions to the latest versions.

Experience on high availability solutions like Log shipping, Mirroring.

Migrating Logins and fixing the orphaned users.

Experience on sql Backup restores by using third party tool IBM Tivoli.

Upgrading the database by using Backup and restore & Attach detach methods.

Creating Jobs, Alerts & Operators for getting mails to the DBA team whenever required.

Configuring the SQL Server & SQL Server Agent Properties.

SQL server daily health check.

Taking Backups regularly through Jobs.

Verify backups and error logs on the servers and troubleshoot on any failures or alerts.

Checking the status of Backup troubleshooting the failed backups and Restoration of databases.

Contact this candidate