+91-799******* admcmp@r.postjobfree.com https://www.linkedin.com/in/aditya-chaganti-450ab21b4 Summary
Seeking a challenging and rewarding career in Database as MSSQL DBA and Cloud Services professional where I can contribute my knowledge and skills for growth and development of the organization and to be able to implement solutions that meet the customer requirements using my variety of software development skills and technical expertise EDUCATION
B.Sc. in Computer Science May '10 - Jun '13
Avanthi Degree College
Osmania University
Technical SKILLS
Cloud: Amazon Web Services
OS: Windows,Linux
Language: Shell Programming in Unix.
AWS: EC2,S3,DyanmoDB,Route53,VPC,EMR,Cloud Formation, RDS,IAM,Cloudformation, BeanStalk, EBS, CloudWatch Version Control: Git
Database: MS SQL 2008,2012,2014,2016,2019
CI: Jenkins
Build Tools: Docker, Puppet, Ansible
Web Servers: Apache
Others: PowerShell, GCP
PROFESSIONAL EXPERIENCE
SQL Database Administration Jan '15 - Present
Infosys Limited
Project:
DevOps Engineer Oct '20 - Present
Hyderabad
Hyderabad
Aditya Sai Chaganti
Responsible for installation, configuration of different versions of SQL Server (2008-2019) and Cluster server environments Apply Service pack (SP) and hot fixes on SQL Server 2012,2014,2016. Configure Failover Clusters and AlwaysOn Availability Groups, Log Shipping, Mirroring. Experienced in Upgrade/Migration of MS SQL Server 2008, 2012 and 2014. Experienced working with application team and implemented Databases as per the specifications. Good at PerfMon/SQL Profiler/Scripts/DMVs/DMFs/ and performance related issues like memory, CPU and I/O issues and other third party tools to resolve bottlenecks, deadlocks and slow running queries. Experienced in Backup and Recovery, Query Optimization and Security. Experienced in Monitoring the Health and Performance of SQL servers using native tools and other third party solutions. Adept at T-SQL,SP,tables.
Performing Database Refresh, Restoration in all the SQL servers. Awareness of attaching and detaching the databases in all the editions. Experience in finding Root cause for all type of incidents to fix the issue. Good experience in deploying and executing SSIS packages using integration services. Creating linked servers for communication between SQL and ORACLE servers. Experience in configuring, scheduling, monitoring and troubleshooting SQL server agent jobs. Experienced in creating technical documentations.
Experienced in supporting and maintaining large databases and troubleshooting. Strong knowledge and real time experience in Amazon Web Services (EC2, S3, RDS, SES, VPC, Route 53, Elastic Beanstalk etc.) Involved in deploying and configuring various EC2 and RDS machines for Cloud Customers. Performed migration of databases from On Premises to AWS Cloud Platform (EC2 machine & RDS machine) and Vice Versa and performed migration on public cloud to private cloud. Create and configure S3 bucket
Infosys Limited
Environment: Jenkins, Docker, AWS
Virtualisation & Containerisation
Hands-on knowledge of software containerization platforms like Docker and container orchestration tools like Kubernetes 6 months of experience in the field of Devops Engineer in application configuration, code compilation, packaging Good hands-on knowledge of Source Code Management (Version Control System) tools like Git and Subversion Proficient in developing Continuous Integration/ Delivery pipelines Experience with automation/ integration tools like Jenkins Knowledge of major cloud service providers, like AWS Good understanding of Infrastructure as Code (Programmable Infrastructure), and how you can achieve that by using tools like Puppet, Chef, Ansible etc.
CERTIFICATIONS
Microsoft Certified Azure Fundamentals
ACHIEVEMENTS
Awarded with AWARD OF EXCELLENCE from Pfizer client. Hyderabad