Resume

D.Venkata Narendar Reddy

Mail: adne71@r.postjobfree.com

Contact: 944*******

Objective

IT professional with 4 Years hands-on experience in managing large-scale databases in production support environment on windows platform. A database administrator with a proven track record of technical skills, who has the ability to work on multiple highly visible projects, is a creative problem solver. Professional Summary:

Experience in Database Administration for very large and complex databases in Microsoft Azure SQL PaaS.

Experience on creating, configuring, monitoring and troubleshooting Azure SQL Database and SQL Managed Instance.

Experience in migrating on-prem databases to Azure using SSMS and DMA.

Experience in configuring service tiers of azure database and Managed Instance depending upon the business requirements.

Experience in connecting Azure databases and SQL Managed Instance from vm’s, local host and on- prem with SQL authentication and with active directory authentication.

Troubleshooting connectivity issues from on-prem to Azure SQL db and Managed Instance depending upon Connectivity settings.

Creating logins and assigning proper permissions to the created logins, mapping logins to the database and granting appropriate permissions for both SQL logins and AD logins.

Managing Firewalls and Virtual networks.

Experience in Importing/Exporting the database using Azure Portal, SSMS, PowerShell and Sql.package.

Experience in configuring the PITR and Long-Term backups.

Experience in copying and restoring the databases in SQL MI.

Experience in creating elastic pools and managing databases in elastic pools.

Experience in configuring Geo-replication.

Experience in configuring Auditing to storage account and log analytics.

Experience in configuring Dynamic data masking.

Experience in configuring TDE using SMK and CMK.

Experience in configuring and troubleshooting vulnerability assessment and advanced threat protection.

Experience in configuring Metric alerts and monitoring the database metrics.

Experience with Intelligent Performance and troubleshooting the database performance.

Experience in configuring automation jobs for database maintenance.

Configuring fail-over groups for geo-replicated databases.

Experience in configuring data-sync in azure and also from on-prem-azure for Azure SQL databases.

Experience in migrating data from on-prem to Azure SQL PaaS using transaction replication.

Experience in configuring private endpoint.

Experience in configuring P2S vpn.

Experience in troubleshooting performance of the database using DMV’s and Query Store. Technical Skills

• Database : Azure SQL Database(Paas) Azure SQL Managed Instance and SQL Server

• Tools : Azure portal, DMA, SSMS,SSCM and SSRS.

• Operating Systems : Windows Server 2016, 2012 and 2008R2 Professional Experience

Currently working as Azure SQL DBA at Mindtree India Pvt Ltd, Hyderabad. Client : Microsoft

Duration : 1.8 years

Team Size : 40

Description: Microsoft Corporation is an American multinational technology company with headquarters in Redmond, Washington. It develops, manufactures, licenses, supports, and sells computer software, consumer electronics, personal computers, and related services. Roles and Responsibilities:

Experience in Database Administration for very large and complex databases in Microsoft Azure SQL PaaS.

Migrating on-prem databases to Azure using SSMS and DMA.

Configuring service tiers of azure databases and SQL MI depending upon the business requirements.

Experience in connecting Azure databases and MI from vm’s, local host and on-prem with SQL authentication and with active directory authentication.

Troubleshooting connectivity issues from on-prem to Azure SQL dB and MI depending upon Connectivity settings.

Creating logins and assigning proper permissions to the created logins, mapping logins to the database and granting appropriate permissions for both SQL logins and AD logins.

Managing Firewalls and Virtual networks.

Importing/Exporting the database using Azure Portal, SSMS, PowerShell and Sql.package. Troubleshooting the errors while the operation.

Experience in configuring the PITR and Long-Term backups.

Experience in copying and restoring the databases.

Experience in creating elastic pools and managing databases in elastic pools.

Experience in configuring Geo-replication.

Experience in configuring Auditing to storage account and log analytics.

Experience in configuring Dynamic data masking.

Experience in configuring TDE using SMK and CMK.

Configuring and troubleshooting vulnerability assessment and advanced threat protection.

Configured Metric alerts and monitoring the database metrics.

Experience with Intelligent Performance and troubleshooting the database performance.

Configured automation jobs for database maintenance and SLO operations.

Configuring fail-over groups for geo-replicated databases.

Configured data-sync in azure and also from on-prem to azure for Azure SQL Databases.

Experience in migrating data from on-prem to Azure SQL PaaS using transaction replication.

Configured private endpoint and P2S vpn.

Experience in troubleshooting performance of the database using DMV’s and Query Store Professional Experience:

Worked as MSSQL DBA at HCL Technologies Pvt Ltd, Bangalore. Client : Vovlo Group AB

Duration : 2.3years

Team Size : 25

Description : The Volvo is a Swedish multinational manufacturing company headquartered in Gothenburg. While its core activity is the production, distribution and sale of trucks, buses and construction equipment, Volvo also supplies marine and industrial drive systems and financial services. E

Roles and Responsibilities:

Experience on Installing, configuring, monitoring and troubleshooting SQL Server.

Experience in upgrading SQL Server to new versions.

Performed installation of SQL Server Service Packs.

Creating logins and assigning proper permissions to the created logins, mapping logins to the database and granting appropriate permissions

Monitoring free space of database.

Checking the status of backup, troubleshooting the failed backups and restoration of databases.

Used System monitor to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance

Verifying all instances are up and running as per the checklist

Experience in TDE, DBMAIL, Audits and finding the Blockings in database.

Involved in database migration to physical and cloud environment.

Recovering and Restoring databases from backup in disaster situations

Performing SQL server daily health check and preparing a report based on it.

Scheduled and maintain routine Jobs, Alerts and Maintenance Plans

Creating and managing Users, Roles and Groups and handling database security

Creating Customized Server Roles

Managing Backups on a daily basis and Recovery as per request

Reviewing SQL Server and SQL Server Agent Error Logs

Implemented and Maintaining Log shipping High Availability option.

Implemented Replication High Availability.

Have worked on 2-node cluster and monitoring through cluster administrator.

Configured Always ON

Education and Personal details:

• Qualification : B.Tech in Electrical and Electronics Engineering from Auroras Engineering College, Bhongir.

• Pass-out Year: 2015

• Date of Birth : 20-08-1994

• Marital Status: Married

• Address: 2-108/7/103,Roadno-2,SBR colony,Boduppal,Hyderabad,Telangana state,India-500092.

• Languages : English, Telugu, Hindi

I hereby declare that the information furnished here is true to the best of my knowledge. Place: Hyderabad D.VENKATA NARENDAR REDDY

.

Contact this candidate