
Jagan Gaddam
Technology / Internet
About 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.
Experience
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
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
Professionals in the same Technology / Internet sector as Jagan Gaddam
Professionals from different sectors near Austin, Travis
Other users who are called Jagan
Jobs near Austin, Travis
-
Cockroach DBA
1 day ago
Teamware Solutions AustinAbout this role · This is an exciting opportunity for an experienced Cockroach DBA to join our team at Teamware Solutions. · Key Responsibilities: · Design, deploy, operate and scale multi-region CockroachDB clusters in production environments. · Ensure high availability, fault t ...
-
Mongo DBA
1 week ago
Inherent Technologies AustinMongo DBA responsible for configuring Mongodb replica set and sharded clusters. · ...
-
Cockroach DBA in Sunnyvale, CA or Austin, TX
1 week ago
Smart IT Frame LLC AustinCockroach DBA responsible for designing, deploying, operating and scaling multi-region CockroachDB clusters in production environments. · Troubleshoot complex database and infrastructure issues including Node failures Network partitions Leaseholder and range imbalance Replication ...