PRAVEEN

SQL Server DBA

E-Mail: adkiys@r.postjobfree.com Mobile: +91-949*******

Profile Summary

Around 4 Years of experience as a SQL Database Administration and SQL Azure, currently working with Infosys, Hyderabad in a production environment. Good Hands-on experience on SQL Server activities like Installation and Configuration, backup, recovery, and server related issues.

SQL Azure:

Excellent knowledge and hands on experience in Migrations from on-premises to Azure IAAS and PAAS servers

Having very good knowledge on Pricing models of DTU/eDTU vs Vcore Model

Having good expertise into Geo-Replication, Availability Group(s) and Data Sync

Implemented Data Partitioning, Purging and Archiving solutions in the Azure model databases.

Having very good knowledge on saving the cost on Azure models.

Deploy, Configure, Maintain Compute on Azure IAAS and PAAS servers

Troubleshoot Azure related issues and engage internal teams and vendor issue resolutions.

Automate deployment and troubleshoot mechanisms for quick service.

Create and configure Logical SQL servers, databases, elastic pools in Azure Cloud.

Monitor performance and setup alerts to avoid performance issues occurring on Azure databases.

Having hands on experience in Elastic Jobs and Run Books.

Having good knowledge on External tables and Elastic pool Model(s)

Having hands on experience into the Reservations and Azure hybrid benefits

Import and Export data within Azure Cloud environment.

Creating and Managing logins/Access levels in Azure IAAS and PAAS environments.

Installation

Experienced in installation MS SQL Server 2016, 2012, 2008 R2, 2008, 2005 and 2000 on standalone and cluster servers.

Experienced in configuring windows failover clusters Active<->Active, Active<->Passive.

Expert in configuration of Microsoft Azure environment and doing migration from data SQL machine to SQL Azure.

Upgrade and Migration

Experienced in in place upgrade and side by side upgrade and upgrade to new hardware.

Experienced in migration from dBASE database management system to SQL Server 2012 and SQL Azure.

High availability and Disaster Recovery

Implemented and supported Always on Availability Groups, Clustering, Database Mirroring, Log shipping, Replication.

Experienced in creating Maintenance plans, backing up databases and restoring databases.

Creating jobs and experienced in rebuilding master database and restoring Master database and user databases.

Monitoring and performance Tuning

Experienced in implementing the database mail, operator and implementing the alerts.

Monitor the production server using tools like SQL Profiler, Windows Performance Counters and SQL server logs for Monitoring and Tuning SQL Server.

Experienced in performance tuning by using DBCC commands, Execution plans, system stored procedures, DMV’s and tools like DTA and SQL profiler.

SSIS, SSAS, SSRS

Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Integration Services (SSIS).

Educational Details

•Completed B-Tech from JNTUH University in 2013.

Professional Summary

•Working as a SQL Server DBA in Infosys Ltd, Hyderabad from April 2017 to till date.

TECHNICAL SKILLS

Database : SQL Server 2008/2008R2/2012/2016.

Operating System : Windows Server 2008/R2/2012

Cloud : Microsoft Azure

Professional Experience

Project - 2:

Client : Microsoft (ESBI Support), India

Team Size : 12

Environment : Microsoft Azure, SQL Azure, SQL Server 2012, 2014 and 2016.

Role : Data Base Administrator.

Duration : August 2019 to till date

Roles and Responsibilities:

•Implementation of Hosting SQL services in azure IAAS and PAAS servers.

•Create and configure Logical SQL servers, databases, elastic pools in Azure Cloud.

•Deploy builds on multiple databases in Azure cloud.

•Manually take the schema and data backups of the databases and restore/copy databases and restore deleted databases in Azure cloud.

•Import and Export data within Azure Cloud environment.

•Creating and Managing logins/Access levels in Azure IAAS and PAAS environments.

•Migration of databases from On premise to Azure Cloud environment.

•Setup maintenance plans for databases using Azure Elastic jobs and Azure automation methods.

•Setup Audit and threat detection logs to ensure the security of the databases in Azure cloud and recover any in case required.

•Monitor performance and setup alerts to avoid performance issues occurring on Azure databases.

•Troubleshooting issues occurred with the databases in Azure cloud environment.

•Suggest Cost optimization solutions in Azure PAAS environment.

•Enabling and Managing data masking and encryption in Azure cloud environment

•Enabling Geo replication to ensure availability of the Azure databases as DR plan.

•Enabling Long time retention backup policy for Azure databases.

•Creation of indexes, Partitions of the data in the Azure databases.

•Monitor the health check of the SQL server and review and apply azure recommendations.

•Enable and manage query store for the azure sql databases.

•Maintaining of over 200+ standalone\Cluster servers.

•Installation & Configuration of SQL Server 2008 R2/20012/20014/2016 on Local System and Remote System

•Involved in the process of Up gradation/Migration from SQL Server 2008R2,2012 and 2014.

•Involved in applying the latest service packs & hot fixes.

•Continuously monitoring and updating the Backup & Recovery strategy and also monitoring scheduled jobs of backup and restore procedure for database.

•Maintenance work on different databases (e.g.: Re-indexing, Statistics Update, freeing up space or adding data/log files etc…)

•Having experience on database backup and restorations.

•Implementation of Logins, creating Users, assigning responsibilities as a part of Security Policies for various categories of User Support.

•Implemented database refresh and troubleshooting orphaned users.

•Identifying/resolving fragmentation resulting in improved performance

•Making data available to all the resources using the Log Shipping

•Having implementation and technical knowledge on Database Mirroring

•Implementation of Hosting SQL services in azure IAAS and PAAS servers.

•Create and configure Logical SQL servers, databases, elastic pools in Azure Cloud.

•Deploy builds on multiple databases in Azure cloud.

•Manually take the schema and data backups of the databases and restore/copy databases and restore deleted databases in Azure cloud.

•Import and Export data within Azure Cloud environment.

•Creating and Managing logins/Access levels in Azure IAAS and PAAS environments.

•Migration of databases from on premise to Azure Cloud environment.

•Setup maintenance plans for databases using Azure Elastic jobs and Azure automation methods.

•Setup Audit and threat detection logs to ensure the security of the databases in Azure cloud and recover any in case required.

•Monitor performance and setup alerts to avoid performance issues occurring on Azure databases.

•Troubleshooting issues occurred with the databases in Azure cloud environment.

•Suggest Cost optimization solutions in Azure PAAS environment.

•Enabling and Managing data masking and encryption in Azure cloud environment

•Enabling Geo replication to ensure availability of the Azure databases as DR plan.

•Enabling Long time retention backup policy for Azure databases.

•Creation of indexes, Partitions of the data in the Azure databases.

•Monitor the health check of the SQL server and review and apply azure recommendations.

•Enable and manage query store for the azure sql databases.

•Having Knowledge on Power BI.

PROJECT -1:

Client : Microsoft (Sales), India.

Team Size : 10

Environment : SqlServer2005, 2008, 2008 R2, 2012,2014,2016

Role : Data Base Administrator.

Duration : April 2017 to July 2019.

Roles and Responsibilities:

•Installation & Configuration of SQL Server 2008 R2/2012/2014/2016 on Local System and Remote System.

•Maintaining of over 100+ servers.

•Continuously monitoring and updating the Backup & Recovery strategy and also monitoring scheduled jobs of backup and restore procedure for database.

•Maintenance work on different databases.

•Having experience on database backup and restorations.

•Implementation of Logins, creating Users, assigning responsibilities as a part of Security Policies for various categories of User Support.

•Identifying/resolving fragmentation resulting in improved performance.

•Troubleshooting transaction logs and TempDB when full

•Hands on experience in High Availability such as Log-Shipping, Database Mirroring, Replication and Clustering

•Having experience on rebuilding master database during crash situations

•Working on file moment activities as per request with application teams.

•Monitoring SQL Server alerts at regular intervals

•Monitoring SQL Server agent jobs/maintenance plans

•Provided 7 x 24 Production support for the database and application issues.

•Good knowledge in migration activities.

Personal Details:

•Date of Birth : 10/08/1992

•Sex : Male

•Marital Status : Married

•PAN Number : AXIPN6318D

(PRAVEEN )

Contact this candidate