Sql Server Cloud Platform
Resume:
Jagan Gaddam
**********@*****.*** 832-***-****
Summary
14+ Years of SQL Server DBA experience in Implementation, Administration, Database Design, Development & Support of SQL Servers 2008, 2012, 2014, 2016, 2019 and 2022 in Production, Test, and Development Environments includes 5 years of hands-on Cloud environment of AWS and Azure.
Expertise in Infrastructure operations, supporting 365*24*7 distributed operational model.
Expertise in handling large scale complex database migration projects of SQL Servers with 2012, 2014, 2016, 2019 and SQL Server 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 Dell MC, NetApp, Carbonite, Rubrik, 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.
Much familiar with Azure Cloud platform and Cosmos DB.
Experience on installing, configuring, and managing of SQL Server and its components. i.e., SSIS, SSRS, SSAS.
Expertises in Troubleshoot, investigate, and drive complex database resolution of incidents.
Expertise in Performance Data Collector, Transparent Data Encryption (TDE) and Bulk Copy Program (BCP).
Configure and maintain HA plus DR through Rubrik
Sound knowledge on Operation CIRT Handling and Major incident Team responsibility.
Familiar with All Clustered Environments. Monitoring the Nodes and Volumes.
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.
Worked extensively on EBS Volumes through Terraform.
Responsible for Security Configuration on cloud platform through Terraform.
Proficient in meeting tight deadlines and adopting new technologies.
Experience in using Service Desk application, used to assign/track/document all requests for work impacting the nature.
Monitored and troubleshoot Azure Data Factory pipelines
Monitoring the servers by accessing remotely and analysing the databases.
Experience in Active directory user management, replication, and monitoring.
Very Good experience on Optimising Code and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
Installation, configuration, and maintenance of MS SQL Servers.
Checking the status of Backup, troubleshooting the failed backups and Restoration of databases.
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.
Experience in Documenting all Database Architecture according to established standards.
Worked closely with network and SAN teams, well versed with EMC - Semantic storage and EBS Volumes.
Technology:
Cloud – AWS and Azure
DB – SQL Server, Mongo
OS – Windows, Linux
DevOps – CI/CD and ADF
Service Desk - Service Now, JIRA
and Confluence,
Change Mgmt – GitHub, Sprint
Monitoring – SiteScope, IMon,
Splunk, DataDog, Nagios
Programming Languages –
T-SQL, PowerShell and Java
Backup Tools – Litespeed,
SnapManager, Avamar and
Double-Take
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 Sr., Lead – Database (cloud) Jan’2023 – Dec’2024
Location : Costa Mesa, CA(Remote)
Project: Database Operations and Infrastructure Hosting and Managing.
Responsibilities:
Responsible for Installation and maintenance of SQL Server software on production / development / QA
Handling Very Large databases ranging in sizes from 1TB to 4 TB
Provide L2/L3 support as the primary point of contact for all technical and operational issues
On call support
Tuning data & performance of the servers, and working with development teams to identify & suggest Optimization enhancements
Configure and manage database Replication, Log shipping, Availability Groups, Disaster Recoverysolutions for databases.
Design and implemented backup, HA, DR (Disaster recovery) Strategies through backup tool Rubrik, Dell MC, NetApp, Carbonite, Rubrik
Collaborate closely with application development teams to provide database support.
Implement security measures through TDE and TLS for protecting sensitive data
Configure monitoring on the DB servers.
Maintain integrity and consistency of the databases,
Analyzed Traces from the SQL Profiler to troubleshoot database and used DBCC consistency checks for other database maintenance aspects.
Prepare steady state documentation and cutover scripts for the entire SQL Server processes
migration of SQL Server database servers from ON-PREM to AWS
Environment: SQL Server 2022, 2019 and 2017. Windows 2022, SQL Sentry, ServiceNow, AWS Cloud platform with EC2, GitHub, Terraform, Terra grunt, JIRA, Confluence, CI/CD Tool – Octopus, Version change tool – Bitbucket, Dell MC, NetApp, Carbonite, Rubrik,SQL, Avamar
Client: Woodside Energy Sr., Lead - Enterprise Systems and databases (cloud) Jan’2021 – Jan’2023
Location : Houston, TX
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
Design and implemented backup, HA, DR(Disaster recovery) Strategies through backup tool Rubrik, Dell MC, NetApp, Carbonite, Rubrik
Design, implement and maintain database systems with SQL and NoSQL technologies.
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, Dell MC, NetApp, Carbonite, Rubrik,SQL, Avamar
Client: Thomson Reuters Sr., Lead Engineer-Database Oct’14 –Dec 2020
Location : Carallton, TX
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
Design and implemented backup, HA, DR(Disaster recovery)Strategies through backup tool Rubrik, Dell MC, NetApp, Carbonite, Rubrik
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.
Experience in managing 3000+ database servers, with database sizes up to 90TB, on Physical, Virtual machines.
Design, implement and maintain database systems with SQL and NoSQL technologies.
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.
Involved in pre and post migration activities from DB2 udb 9.7 to SQL Server 2005/2008
Experience carried out on all phases of Migration activities from DB2, Oracle to SQL server.
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, anddatabase 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 Serverwith Always ON, Data Replication, DR setup, Clustering, Log shipping and mirroring on AWS / AZURE environment, Dell MC, NetApp, Carbonite, Rubrik,SQL, Avamar
Client: Wells Fargo Senior Database Engineer AUG’12 – SEP’14
Location : Charlotte, NC
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,Dell MC, NetApp, Carbonite, Rubrik,SQL, Avamar
Client: Asurion Sr. SQL Server Administrator MAY’10 – July’12
Location : TN
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,
Dell MC, NetApp, Carbonite, Rubrik, SQL, Avamar
Contact this candidate