VENKATESWARLU GRANDHI

• Maintaining more than 500+ SQL Servers which are in Dedicated and Shared Environments
• LOB Support for Database Operations - RST
• Successfully Migrated/Upgraded more than 200+ SQL Servers from 2016 to 2019
• Managing 500+ databases size of 20 GB to 10 Terabytes
• Configured and troubleshooting of Log Shipping, Mirroring, Replication and Clustering
• Configured and troubleshooting of Always on (AG)
• Automated DB Refresh, SLA & OLA reports and Password Expiry notifications
• Index Rebuild and Update Statistics, Database Backup/Restore, Data Imports and Exports
• Health Status report of all the jobs, Database Consistency Checks and Data Encryption
• Created KB articles, Operational, Release Guide and RCA
• Worked with business and IT management to explain benefits of design proposals
• Collaborate with application development teams and operations teams to create synergy leading to successful application delivery
• Contribute to technical process improvements across a variety of disciplines such as training, CM, Agile, and modern development practices
• Troubleshooted and resolved deployment/configuration/set up issues and work with appropriate teams to correct any issues
• Developed large-scale application architectures to meet business requirements in complex environments
• Educated customers of all sizes on the value proposition of AWS, and participate in deep architectural discussions to ensure solutions are designed for successful deployment in the cloud
• Captured and share best-practice knowledge amongst the AWS solutions architect
• Created business continuity disaster recovery, fail-over and run-book documentation
• Ensured security is integrated into all cloud architecture solutions
• Deployed Amazon Inspector, Macie, Guard Duty and AWS Shield & WAF to enhanced security in the customers AWS production environment
• Extensive understanding of and ability to solution service offerings across; Infrastructure (including outsourcing best practices, transition, and ITIL)
• Created new VM templates for several Operating Systems with all the recommended and required settings for optimum performance and efficiency
• Configured NACL and security groups, thus limiting malicious attacks from blacklisted range IP addresses Shot on OnePlus Sanaged public/private cloud infrastructures, using Amazon Web Services which include EC2, S3, Front, Elastic File System
• RDS VPC Diar
• Experience in deploying and monitoring applications on various platforms using Elastic Bean Stalk, setting life cycle policies to back the data from Amazon Web Services AWS S3, RDS, EC2
• Tuned 20+ applications and improved the performance from 50-90%
• 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 more than 600+ SQL Servers which are in Dedicated and Shared Environments
• Educated customers on the value proposition of AWS and AWS services
• Built deep relationships with senior technical individuals within customers to enable them to be cloud ad
• Partnered with the sales team to design solutions for customers that drive AWS adoption and revenue
• Captured and share best-practice knowledge amongst the AWS Solutions Architect team
• Created business continuity/disaster recovery, fail-over and run-book documentation
• Ensured security is integrated into all cloud architecture solutions
• Conducted deep-dive 'hands-on' education/training sessions to transfer knowledge to internal customers considering or already using the AWS cloud
• Built deep relationships with senior technical individuals within customers to enable them to be cloud adv
• Hands-on experience writing Production-ready automation code to implement solutions with Puppet, Ansi CloudFormation or similar - e.g.: Chef, Terraform
• Designed of customer's Cloud environments with a focus on AWS and demonstrated technical cloud archit knowledge, playing vital role in the design of production, staging, QA and development Cloud Infrastructure running in 24x7 environments
• Experience in deploying and monitoring applications on various platforms using Elastic Bean Stalk, setting life cycle policies to back the data from Amazon Web Services AWS S3, RDS, EC2
• Hands-on knowledge of transitioning clients to the Cloud, i.e., migrations, hybrid co-existence
• Collaborate across multiple teams to research, architect, engineer, and configure complex cloud solutions to specified requirements in support of global, business critical systems
• Successfully Migrated/Upgraded more than 200+ SQL Servers from 2005/2008R2 to 2012
• Successfully Migrated/Upgraded more than 200+ SQL Servers from 2012 to 2016
• Managing 500+ databases size of 20 GB to 4 Terabytes
• Configured and troubleshooting of Log Shipping, Mirroring, Replication and Clustering (A/A/P)
• Automated DB Refresh, SLA & OLA reports and Password Expiry notifications
• Index Rebuild and Update Statistics, Database Backup/Restore, Data Imports and Exports
• Health Status report of all the jobs, Database Consistency Checks and Data Encryption
• Created KB articles, Operational, Release Guide and RCA
• Tuned 20+ applications and improved the performance from 40-90%
• 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 more than 500+ SQL Servers which are in Dedicated and Shared Environments

• Successfully Migrated/Upgraded more than 100+ SQL Servers from 2005/2008R2 to 2012
• Managing 500+ databases size of 20 GB to 4 Terabytes
• Configured and troubleshooting of Log Shipping, Mirroring, Replication and Clustering (A/A/P)
• Automated DB Refresh, SLA & OLA reports and Password Expiry notifications
• Index Rebuild and Update Statistics, Database Backup/Restore, Data Imports and Exports
• Health Status report of all the jobs, Database Consistency Checks and Data Encryption
• Created KB articles, Operational, Release Guide and RCA
• Tuned 20+ applications and improved the performance from 40-90%.

• Technical Contribution: Enrolled users with required permission based on their roles
• Maintaining the availability of database to the team by scheduled backup and restoration
• Security of database by restricting the permissions to the users
• Recovering the database after crash
• Keeping the database in sync at offshore and onsite
• Point in Time recovery of Database
• Performance Tuning of Database
• Administration of Data Base under the Test, dev and Production Environment
• Query Optimization
• Database Monitoring
• Database Refreshing
• Database Replication.