Gowri Sankar Patam

Dynamic Cloud Database Administrator with extensive experience at HCL Tech and Tata Consultancy Services. Expert in Azure SQL and AWS RDS, driving database performance and reliability. Proven ability to lead data migration projects while fostering collaboration within teams. Adept at utilizing advanced backup tools and troubleshooting complex issues efficiently.

• MCP 70-764, Administering a SQL Database Infrastructure
• DP-300, Administering relational databases on Microsoft Azure
• Oracle Administration, Trained and certified through Beasant Technologies
• Silver Club Membership, HCL Technologies
• Achievers League, Excellent performance in consecutive years

I am an experienced IT professional with a strong background in database administration. I have successfully managed and maintained databases for leading companies such as TCS and HCL Tech. I have 8 years of experience in SQL Server, Azure & AWS., Currently serving as an I.T Analyst at Tata Consultancy Services, responsible for overseeing database operations and ensuring optimal performance. Played a key role as a Senior Analyst at HCL Tech, contributing to the successful implementation of state-of-the-art database solutions. Holds a B.Tech degree in Computer Science from AITS Tirupati, bolstering technical expertise. Seeking an exciting opportunity as a Database Administrator to leverage acquired skills and experience in optimizing and securing database operations.

Installation

• Experienced in installing MS SQL Server on stand-alone and cluster servers
• Experienced in configuring Windows failover clusters: Active<->Active, Active<->Passive
• Experienced in creating virtual machines and SQL Azure databases in the Microsoft Azure environment

Upgrade and Migration

• Experienced in in-place upgrade, side-by-side upgrade, and upgrade to new hardware
• Involved in various migration projects
• Log shipping database to mirroring
• Standalone instance migration
• On-prem server to Azure databases
• High availability and disaster recovery
• Implemented and supported Always On Availability Groups, clustering, database mirroring, log shipping, and replication
• Experienced in creating maintenance plans, backing up databases, and restoring databases
• Creating jobs and experienced in rebuilding master database and restoring Master database and user databases.

Automations:

• Automated Instant Blocked Process Alerts.
• Automated Deadlock Alerts.
• Automated Low Disk Space Alerts.
• Created triggers to capture new logins with sysadmin access.

Monitoring and performance Tuning

Experienced in implementing the database mail, operator and implementing the alerts

Monitor the production server using tools like SQL Profiler, Windows Performance Counters and SQL server logs for Monitoring and Tuning SQL Server.

Experienced in performance tuning by using DBCC commands, Execution plans, system stored procedures, DMV’s and tools like DTA and SQL profiler.

Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Integration Services(SSIS).

SQL Azure

• Excellent knowledge in Migrations from on premise to Azure IAAS and PAAS servers
• Having very good knowledge on Pricing models of DTU/eDTU vs Vcore Model
• Having good experience into Geo-Replication, Availability Group(s) and Data Sync
• Configured Maintenance jobs through MultiServer Administration in Azure servers. We have added more than 100 + plus servers to Master server and it’s easy to monitor and maintain on daily basis
• Configure SQL server databases backups to Azure recovery service vault for IAAS SQL server databases.
• Having very good knowledge on saving the cost on Azure models
• Deploy, Configure, Maintain Compute on Azure IAAS and PAAS serversCreate and configure Logical SQL servers, databases, elastic pools in Azure Cloud.
• Having good knowledge in Elastic Jobs and Run Books.
• Having good knowledge on External tables and Elastic Pool Model(s)

Oracle

• User creation, password reset and assigning roles in Oracle databases.
• Creating table space and managing table space alerts in Oracle databases.
• Verifying blocking sessions and backups from OEM .
• Export and import, gathering stats, Compiling invalid objects and other L1 tasks in Oracle databases.