Jagadeesh R

Seeking assignments in Technical Services, Program Management, Enterprise Management and Projects Coordination to deliver quality solutions for Complex Business process management and technical requirements with a technology driven organization.

• Having 8 + years of experience as a Senior SQL Database Administrator in On-Prem, Azure Cloud and L1 Level in AWS cloud Administration.
• Experience in working with (24 x 7) (24 x 5), Production, Development, QA, and Testing environments.
• Installing, Configuring and Maintenance of SQL Server 2005 and 2008, 2008R2, 2012, 2014, 2016, 2017, 2019 and 2022.
• Experience with upgrades from 2008 to 2012, from 2012 to 2014, from 2014 to 2016.
• Worked with an Environment of Managing 1000+ Servers with 1200 of databases approximately with a size of 1 TB.
• Resolving the Tickets within the SLA Time and Monitoring the SLA.
• Verifying & resolving the SQL Server Blocking issues, Dead Lock issues.
• Resolving the Disk space issues, Log File full, Data File full, Finding the Root cause and Permanent fixes.
• Good Experience in restructuring the stored procedure, designing, coding and developing the same using the T_SQL Programming.
• Familiar with applying SQL Server Patches on Prem Servers, IAAS servers (Azure VM’s).
• Hands on experience on migration production to UAT and DEV servers.
• Strong knowledge of Database Backup, Recovery, Restoration and Disaster Recovery Plans.
• Implement and Maintain Database security (Create and Maintain Users and Roles, Assign privileges).
• Configuring, Maintaining and Troubleshooting the Database Log Shipping.
• Configuring, Maintaining and Troubleshooting the Database Mirroring (High safety, High Availability and High performance).
• Configuring, Maintaining and Troubleshooting the Replication.
• Supported few tasks on data files move .mdf and .ldf from one drive to another in standalone and Always On.
• Having Experience and Supported Few Tasks on Hardware Solutions Clustering. (Active- Passive).
• Having Experience and Supporting Troubleshooting tasks for issues on Always On.
• Experience in Usage of DBCC Commands and DMVs for Troubleshooting.
• Good Experience in Performance Tuning activities like verifying Fragmentation and Rendering the fragmented Indexes.
• Having Experience handling tools like Service-Now, 4me, Idera, redgate, Dynatrace, site 24/7, Perfmon, Accord, commits, Ticket it and SQL Profiler, BCP, Import and Export wizards.
• Having knowledge and supporting a few tasks on Azure cloud database administration Azure SQL Pass Environment and Azure VM SQL Environments.
• Having knowledge and supported power. shell scripting language by requesting and help from Wintel Team as per the tickets.
• Experience in Large table handling with the client scenarios Purging, Archiving and the Data Partitioning.
• Experience in Normal or Adhoc backups and restore using Blob storage in MI and IAAS in Azure, Using S3 Bucket to EC2 and RDS instances in AWS.
• Monitoring, Managing, troubleshooting the backups failures, Disk space issues in the backup resource group in the Azure portal.
• Having Experience on Trouble shooting database Access, login failure and connectivity issues in Azure for business impact client side.
• Experience Trouble shooting diskspace, performance issue, up scaling and down scaling the tier as per the business Workloads in the Azure.
• Having Experience in MTU Configuration for Azure VM’s in Azure Web Portal.
• Experience in Handling SQL server Database migration service from Prem to Azure MI, to on Prem to IAAS.
• Knowledge on EC2 to RDS in AWS, on Prem to EC2 instance and on Prem to RDS in AWS.
• Basic Knowledge and support on Create and maintain and configure the S3 Bucket (Simple storage services) with the RDS and the EC2 instances on AWS.
• Basic Knowledge on Creating and configuring the RDS database instance and the EC2 instance in the AWS web portal console.
• Basic Knowledge on Creating and maintaining the Option Groups, Parameter groups, Instance Level, Database level security in AWS.
• Handling tasks monitor automated backups to S3 Bucket for RDS database instance and EC2 instance in AWS web portal console.
• Familiar Knowledge with Point in time recovery for the database disaster recovery solution in RDS and EC2 instances.
• Good Knowledge on Configuring, Maintaining and Troubleshooting HDR Always on, DB Mirroring in RDS and EC2 instances.
• Good Knowledge Configuring, Maintaining, Troubleshooting, Monitoring Cloud watch Events, Enhanced monitoring, OS Process list, Metrics and Performance insight in AWS.
• Supported Few Tasks Trouble shooting performance insight on RDS DB and EC2 instances databases and configuring alert mechanism in AWS.
• Annually Performed the Always on DR activity AWS RDS instance, Knowledge in EC2 instances and troubleshoot various issues on the priority basis.
• Better Idea on Utilizing AMC(Amazon Management console) in RDS and AWS Systems manager in the EC2 instance effectively apply service packs or updates to both AWS RDS and EC2 instances while minimizing disruption, Ensuring the ability and sure the infrastructure.

• Father's Name: Chenchaiah Naidu. R
• Date of Birth: 07/28/88
• Marital Status: Single