Avinash V

Highly experienced IT professional with over 13 years of expertise in database administration, development, and infrastructure support across Microsoft SQL Server (2000–2022), Oracle (9i–12c), PostgreSQL, and MongoDB. Proven success supporting 24x7 enterprise environments with 1000+ servers and 4000+ databases (10GB–40TB), including performance tuning, high availability (AlwaysOn, clustering, log shipping), disaster recovery, and database security (TDE, HIPAA compliance). Deep experience with data center migrations, Redshift/RDS/S3 integration, and end-to-end ETL solutions using SSIS. Skilled in both on-premise and cloud architectures, with hands-on expertise in AWS, Azure (IaaS/PaaS/SaaS), VPNs, and advanced network configurations. Adept at automation using PowerShell.

• Responsible for supporting 24x7 over 1000+ production servers, over 4000+ databases(PROD& Non-PROD), the average sizes of the databases are 10GB - 40 TB.
• Experience in installing, configuring, and upgrading MS-SQL Server 2005 – 2022.
• Experience in Data center migrations where the application servers and SQL servers are moved from one data center to another data center, moreover over setup the new environment.
• Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 8 nodes.
• Experience on Virtual Networks & VPN Gateway creation, Establishing Peering and Configuring Network Security Groups.
• Experience on Availability sets, Load balancers, Application Gateway and Traffic manager, Network Watcher.
• Configured DAG (Distribution Availability Group) on AlwaysOn between 6 nodes, database replication, log shipping, and automation process for backups with PowerShell and Ola Hallengren scripts.
• Performed the physical database analysis and feasibility requirements. This involves performance, security, archival, maintenance, and recovery requirements.
• Collaborated with the app team to implement TDE(Transparent Data Encryption) and audit compliance for HIPAA data.
• Built and deployed SSIS packages for data loading from OLTP to OLAP data warehouses, including incremental packages for loading net changes. And bulk SSIS package migration with PowerShell. 
• Experience in Cloud computing architecture, technical design and implementations including Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS) delivery models.
• Experience on DB migrations from on-premise to Azure IAAS, PAAS servers and  AWS. 
• Having very good knowledge on Pricing models of DTU/eDTU vs Vcore Model
• Implemenetd Data Partitioning, Purging and Archiving solutions in the Azure model databases.
• 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 benifits
• Import and Export data within Azure Cloud environment.
• Deployed Active Directory domain controllers to Microsoft Azure using Azure VPN gateway

Masters in information technology