Jagan Gaddam

• 14 years of experience in Infrastructure Hosting and managing the DB servers in cloud platform including AWS and Azure. 
• 5+ years of DevOps engineering experience.
• Experience with global companies predominantly in financial services, Healthcare, Insurance and technology industry.

Professional Experience:

Client: Experian                                   Cloud Database Engineer                    Jan’2023 – Till Date

Project: AWS - Infrastructure Hosting and Managing.

Responsibilities:

• Deploy, Maintain and Monitor infrastructure in multiple cloud platform including AWS and Azure.
• Familiarity with automation and infrastructure-as-code standards using the AWS CloudFormation and Terraform
• Write technical documentation for processes and develop solutions needed to improve infrastructure scalability and reliability.
• Develop, test, deploy and maintain automation pipelines and systems including CI/CD
• Deploy code and manage system files related to software deployments.
• Proactively identify and reduce issues through design, testing and implementation of software solutions
• EC2 SQL Server and other databases administration, performance tuning, and data manipulation
• Database administration, performance tuning, and patching as needed.
• Lead, planned, and executes on-premises to cloud database migrations, including planning, testing, and executing migration strategies.
• Analyze performance and system health of cloud, hosted, and internal systems.
• Collaborate with other business units on special projects requiring automation, cloud, or other IT systems.
• Experience in database automation provisioning, upgrades, security patches & monitoring.
• Experience in defining procedures for database backup, recovery and retention, disaster recovery.

Environment:  AWS Cloud platform, EC2, RDS. Databases - SQL Server, PostgreSQL, Document DB, Dynamo DB, Mongo DB , GitHub, Terraform, Terra grunt, JIRA, Confluence, CI/CD Tool – Octopus, Version change tool – Bitbucket, ServiceNow

Client: Woodside Energy          Sr., Lead - Enterprise Systems and databases             Jan’2021 – Jan’2023

Project: ERP - Infrastructure Hosting and Managing

Responsibilities:

• Hosting and managing the 400+ ERP environment Servers including the SAP, SQL Server and HANA Databases on Azure Cloud Platform. 
• Responsible for Database and OS patching on Azure Cloud Platform.
• Monitoring the health of ERP applications and Infrastructure servers on daily basis
• Active member of CAB Team and approve the changes on behalf of the CAB.
• Manage and Monitor the Servers on Azure Cloud Platform
• Implemented ASP.NET Core web interface (Employee Complimentary Ticket Redemption) to fetch data from new ticketing system.
• Proficient with ERP environment setup and configuration of load balancer servers
• Manage the Security of systems.
• Configure Always ON through Availability groups.
• Setup and configure the HA and HA+DR patterns on Azure Platform
• Responsible for the SOX compliance of the system.
• Hands on experience with VLDB’s of SQL Server and HANA 
• Performance tuning of the database servers (SQL Server and HANA)
• Infrastructure downsizing

Environment:  Azure Cloud, SQL Server with Always ON, .Net, React, HANA, SAP, Git, SNOW, CyberArk, SOX Audit 

Client: Thomson Reuters        Sr., Lead Engineer-Database                                       Oct’14 –Dec 2020

Project: Data Centre Operations / Data Centre Infrastructure support

Responsibilities:

• Primarily working on migration of SQL Server database servers from ON-PREM to AWS / AZURECloud environment.
• Install, maintain, administer and trouble troubleshoot issues of SQL Server for business-critical applications.
• Build and configure Always on AG groups to ensure the HA+DR designs.
• Configure the S3 bucket to perform the backup and restore and ensure the meet the agreed RTO and RPO
• Patch and maintain the SQL servers on AWS EC2 environment.
• Troubleshoot and fix the user issues raised on the new SQL Server instances of AWS EC2 environment.
• Much familiar with the Managed services of AWS and work closely with the BU/App team to fulfil their requirement. 
• Managed database changes, deployments, security enhancements, TDE, operational support,performance improvement, upgrades and application support, and DR Implementations.
• Monitor and configure the new SQL Server instances of AWS EC2 environment through DataDog monitoring tool.
• Coordinate with application owners, windows, storage, and network teams on systems during releases and fixed any connectivity issues after deployments. 
• Work with systems engineers on planned and unplanned security patches, ensured database servers are healthy, and troubleshoot any connectivity issues. 
• Participated in CAB meetings and pre deployments meetings and prepared and participated in on call schedule.   
• Participated and built SQL clusters for 2 Data Centre locations. Coordinated with application teams on schema changes. 
• Experience configuring and monitoring activity and performance for AZURE SQL at the infrastructure, server, service, and database levels.
• Identified poorly performing SQL queries and tuned and increased performance based on estimated query execution plan recommendations. 
• Implemented SQL Server transaction replication for reporting. 
• Automate tasks using power shell and python scripts.

Environment:  DCO, DCIS, NetApp, Double-Take, Data Keeper, SQL Server with Always ON, Data Replication, DR setup, Clustering, Log shipping and mirroring on AWS / AZURE environment.

Client: Wells Fargo                  Senior Database Engineer                                           AUG’12 – SEP’14

Project: Commodities Trading                                                

Environment:  SQL Server, Oracle 10g, Endur (OpenLink), WebLogic (Java, J2EE), C++, Java Scripting, Shell Scripting, XML, Microsoft Active Server Pages (ASP) and Grid Server

Client: Asurion                        Sr. SQL Server Administrator                                     MAY’10 – July’12         

Project: IT Operations - Database Administration                                                                               

Environment: SQL Server 2000, 2005, 2008 R2 (32 and 64 bit) and 2012, Windows Server 2000/2003(32 and 64 bit), SSMS, SSIS, SSRS, Enterprise Manager, T-SQL, Log shipping, Replication, Clustering, SQL Profiler, Performance Monitor (PERFMON), C++, Microsoft Active Server Pages (ASP) and Java Scripting

Education:

• Master of Computer Application (MCA), Hyderabad, Telangana, India in 2006 
• Bachelor of Computer Application (BCA), Hyderabad, Telangana, India in 2003. 

Certification:

• Microsoft certified Azure administrator associate
• Microsoft Certified IT Professional - Database Administrator 2008. 
• Microsoft Certified Technology Specialist - SQL Server 2008 - Implementation and Maintenance