Jagan Gaddam
Summary:
**+ to 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.
Responsible for managing and maintaining the cloud-based database infrastructure.
Experience with on-premises to cloud database migrations, including planning, executing, and troubleshooting migration projects.
Familiar with the IaC (Infrastructure as Code) and PaC (Platform as Code) standards.
Administer and maintain MS SQL Server databases in AWS EC2 and Azure environments.
Identify and take actions to improve the total cost of ownership for database solutions running in AWS.
Collaborate with development and operation teams to provide database support for application deployments, troubleshooting, and optimization.
Lead, plan and execute on-premises to cloud database migrations, including planning, testing, and executing migration strategies.
Proficient with infrastructure-as-code tools (e.g., AWS CloudFormation, Terraform)
Expertise in Networking, TCP/IP, DNS, Firewalls, Switches, Load Balancers (AWS, Azure)
Proficient in Powershell, Python, Bash or other scripting languages
Highly experienced with automation pipelines including Azure DevOps or other CI/CD platforms
Expertise in SQL Server Implementation, Administration, Database Design, Development & Support of SQL Servers latest versions in Production, Test, and Development Environments
Expertise in Infrastructure operations, supporting 365*24*7 distributed operational model.
Expertise in handling large scale complex database migration projects of SQL Servers with 2019 to 2022
Experienced on high availability SQL Server solutions, including Mirroring, Log Shipping, Always ON, Replication and SQL Server Clustering (Active-Active, Active-Passive).
Solid experience in third party SQL server backup tools such as Snap Manager for SQL, Avamar.
Experience in managing 3000+ database servers, with database sizes up to 90TB, on Physical, Virtual machines.
Design & implement complex database backup/restore strategies.
Experience on installing, configuring, and managing of SQL Server and its components. i.e., SSIS, SSRS, SSAS
Expertise in Troubleshoot, investigate and drive complex database resolution of incidents.
Expertise in Performance Data Collector, Transparent Data Encryption (TDE) and Bulk Copy Program (BCP).
Responsible for reviewing and deploying any production changes through Release for change (RFC) process
Responsible for interacting with other technical support groups to determine appropriate disk platforms, disk configuration, operating system kernel settings and database engine configurations.
Well versed with project responsibilities such as planning and implementation i.e., Migration and Up-gradation.
Proficient in meeting tight deadlines and adopting new technologies.
Monitor and troubleshoot Azure Data Factory pipelines
Experience in documenting all Database Architecture, Design Strategies and plans according to established standards.
Worked extensively on EBS Volumes, Security Configuration on cloud platform through PaC (Platform as code).
Very Good experience on Optimising Code and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
Experience in Performance Monitoring (PERFMON), Performance Tuning and Security Administration by implementing Schemas, optimizing queries, Tuning indexes and DBCC using DBCC Utilities.
Recovery of the database during crash or data Loss.
Worked closely with network and SAN teams, well versed with EMC - Semantic storage and EBS Volumes.
Technology:
Cloud Services
IT Delivery &solutions
Software engineering
Engineering Platform/ products
Agile development
People Leadership & mentoring
Database Administration
Data Center Operations
Collaboration
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
Professional Experience:
Client: Experian DevOps Sr., Lead AWS-Database 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
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, HANA, SAP, 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