Summary
Overview
Work History
Education
Skills
Timeline
Generic

Venkat Nadendla

Barking,Please select

Summary

A seasoned professional with 11 years of experience in leading and managing projects in healthcare /pharmacy/Retail domain. Having good knowledge working in SQL DBA & AZURE Devops cloud technical support and MYSQL DBA & EXASOL DBA.Expertise in building strong working relationship with cross functional teams in global environments. I have strong Business process knowledge about the pharmaceutical / Retail area related applications, Quality systems and their implementations & controls like change & Release management, Audits/Quality reviews, Incident management, Continuous process improvement

Overview

11
11
years of professional experience
3
3
years of post-secondary education

Work History

Associate Lead

ATMECS Technologies
Bangalore, India
05.2023 - 11.2023
  • Proficient in Administrating Azure IaaS/PaaS services like compute Azure Virtual Machines, Web and Worker roles, VNET, Network services, Azure DevOps, SQL Databases, Storages, Azure Active Directory, Monitoring, Autoscaling, PowerShell Automation, Azure Search, DNS, VPN.
  • Powershell and T-SQL scripting language knowledge.
  • Hands on experience in writing Azure Resource Manager (ARM) to deploy, update and delete multiple resources in Azure and migrating the on-premises resources to Azure with Azure Site recovery (ASR) and Azure backups.
  • Experience in Azure IaaS - Virtual machines, VM Scale Sets, Load Balancer, Traffic Manager, Virtual Networks, SQL, Resource Groups and Cloud Services.
  • Extensive involvement in Azure Backup, Azure Policies, Azure Key Vault, Salt Stack and Tagging.
  • Experience in Azure Platform Development, Deployment Concepts., hosted Cloud Services, platform services and close interface with Windows Azure Multi-Factor Authentications.
  • Experience in CI/CD tools like Bamboo, SFDX, Azure devops, Bit bucket and Sonar code scan validations
  • Good working experience in DevOps, establishing E2E pipeline for Salesforce Orgs using Copado Tool.
  • Creating Azure Virtual Machines both Windows and Linux.
  • Creating Azure Virtual Machine Images (including SQL Server)
  • Understanding of Regions, Availability Zones, and Availability Sets.
  • Understanding on Premium/Standard Storage accounts.
  • Creating Shared Storage using File and sharing the files across multiple VMs.
  • Understanding Azure Networking (VNets, Subnets, Private-Public IPs).
  • Understanding of Active Directory on Azure (Azure AD Connect service)
  • Creating/configuring Azure SQL Databases (PaaS/DBaaS)
  • Creating Server/Database firewall rules in Azure SQL Databases
  • Exporting BACPAC from Azure SQL Databases.
  • Creating and configuring Azure SQL Database Managed Instance.
  • Migrating On-Perm Databases to Azure SQL Databases (Singleton) using DMA
  • Exposure to DMA tools for On-Perm and Azure migrations.
  • Having knowledge on Azure Elastic Pool Databases and Elastic Jobs.

Team Lead

Cognizant
Bangalore, India
11.2019 - 05.2023
  • Participate in 24/7 operations via on call rotation schedule.
  • Audit server health, error logs, windows logs, and application performance to take corrective actions if needed.
  • Automate day-to-day tasks to increase team productivity.
  • Participated in migration of lower environment to higher environment
  • Installed and configured SQL clustered environment with availability groups in Always on
  • Routine patching and upgrading SQL Server installations and FCI clusters.
  • Monitoring disaster recovery and high availability solutions like Log-shipping, Mirroring, Replication and Clustering.
  • Installing and configuring SSIS and SSAS services.
  • Strong knowledge in T-SQL scripting.
  • Strong knowledge in power shell.
  • Implementing Server level, database level security.
  • Performing regular backup and restore operations
  • Performance Monitoring and Query Optimization based on requests.
  • Knowledge of storage, servers, operating systems, and application interaction.
  • Experience working in large enterprises environments with high concurrency.
  • Documented processes for installations, clustering, availability group setup, and patching.

Senior SQL Database Admin

HCL Technologies
Bangalore, India
12.2014 - 11.2019
  • Setting up, troubleshooting and maintenance of Applications on production Servers.
  • Understanding business requirements and providing solutions to the requirement, wherever possible.
  • Implemented the Backup strategy and Database restore.
  • Configuring and monitoring the high availability solutions like Replication,
  • Log Shipping, Mirroring and Clustering.
  • Experience in Database Migration and SQL server up gradations.
  • Checking the performance of a SQL Server by using SQL Server profiler System monitor.
  • Installed and configured a SQL 2016 clustered environment with availability groups in Always on
  • Participated in migration of SQL Server 2012 databases to SQL Server 2016
  • Participated in SQL server patching.
  • Troubleshooting the issues like Deadlocks, Blocking and Locking and resolving the issues.
  • Documented processes for installations, clustering, availability group setup, and patching.
  • Setting up meetings with Clients on weekly basis in discussion of ongoing and upcoming projects which are in pipeline.

SQL DBA Admin

Wipro Technologies Limited
Bangalore, India
09.2012 - 11.2014
  • Installing and configuring SQL Server 2008 , 2012 and 2014.
  • Installing and configuring SSIS and SSAS services.
  • Implementing Server level, database level security.
  • Performing regular backup and restore operations.
  • Managing Backups on a daily basis and Recovery as per request.
  • Monitoring Disk Space of all the Servers and freeing up space as per SQLServer.
  • Moving data from one server to other server by using DTS, Import & Export BCP utility, Bulk-insert.

Education

Master of Computer Science - Computer

Perilyar University
India
04.2005 - 05.2008

Skills

RDBMS:

MS-SQL Server 2008/2012\2014 up to 2022 Database Administration

Operating System:

Windows 2005 Professional, Windows 2008, 2012 up to 2022 Server

  • Leadership management
  • Strategic planning
  • Data interpretation

Timeline

Associate Lead

ATMECS Technologies
05.2023 - 11.2023

Team Lead

Cognizant
11.2019 - 05.2023

Senior SQL Database Admin

HCL Technologies
12.2014 - 11.2019

SQL DBA Admin

Wipro Technologies Limited
09.2012 - 11.2014

Master of Computer Science - Computer

Perilyar University
04.2005 - 05.2008
Venkat Nadendla