Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Gowtham Kotagiri

Cloud / Database Administrator

Summary

Certified Azure Administrator with 14 years of DBA experience on Azure & AWS cloud, specializing in SQL Server databases. Skilled in supporting databases in both cloud and on-premises environments, with a strong focus on Azure administration and migration. Proficient in MongoDB and PostgreSQL database administration, as well as configuring databases in AWS and Azure cloud. Worked with world-class IT organizations including Credit-Agricole, JPMorgan & Chase, Cognizant Technology Solutions, Mphasis, and IBM. Collaborated with various US-based clients including JPMorgan Chase, Hartford Financial Services, Ace Financial Services, PRNewswire, Bristol Myers Squibb, and Fluor Corporation.

>Extensive knowledge in MSBI and Power BI technologies.

>Expertise in business communications, database design, implementation, operational management, and successful delivery of engineering projects on MS-SQL, MongoDB & Postgres.

>Subject Matter Expert in advanced MS-SQL Server database technologies such as Always On Availability Groups, Failover Clusters, SSIS & SSRS.

>Migrated on-premises workloads to Azure and AWS cloud based on specific requirements.

>Strong design and live migration experience from on-premises to Azure IaaS & PaaS and AWS RDS&EC2

>Proficient in services offered by Azure IaaS, PaaS, and SaaS.

>Installed, configured, and upgraded Oracle Database (11g/12c/19c) in production and development environments.

>Implemented database backup & recovery strategies using RMAN and Data Pump to ensure data integrity and availability.

>Managed high availability solutions such as Oracle Data Guard and Real Application Clusters (RAC) for failover and disaster recovery

Overview

14
14
years of professional experience
4
4
years of post-secondary education
5
5
Certifications

Work History

Expert DBA

Credit Agricole
03.2022 - Current
  • Company Overview: Client: Credit Agricole Corporate and Investment Bank, Singapore
  • Designed and implemented SQL Server Always On Availability Groups for mission-critical databases to ensure high availability and data redundancy across multiple data centers
  • Configured and maintained Distributed Availability Groups for cross-region data replication and disaster recovery in Azure and AWS environments
  • Set up and managed Database Mirroring for legacy systems to ensure uninterrupted application functionality during planned maintenance and failovers
  • Implemented Windows Server Failover Clustering (WSFC) to support high availability for SQL Server instances and prevent single points of failure
  • Deployed Transparent Data Encryption (TDE) to protect sensitive data at rest and ensure compliance with regulatory requirements like GDPR and PCI-DSS
  • Configured encryption protocols for data in transit using TLS/SSL to secure communication between applications and databases
  • Designed and enforced role-based access control (RBAC) policies and regularly audited user permissions for compliance
  • Performed advanced query tuning, index optimization, and partitioning for SQL Server and PostgreSQL to reduce latency and improve throughput
  • Monitored and resolved performance issues using tools like SQL Server Extended Events, Query Store, and DMVs
  • Conducted regular capacity planning to ensure database infrastructure could scale with business growth
  • Migrated on-premises SQL Server databases to Azure Managed Instances and AWS RDS, leveraging native tools like Data Migration Assistant (DMA) and AWS DMS
  • Designed hybrid cloud solutions with secure connectivity between on-premises SQL Server and cloud environments using VPN and ExpressRoute
  • Automated provisioning, backups, and disaster recovery setup using Terraform and PowerShell, reducing operational overhead by 30%
  • Implemented proactive monitoring and alerting systems using tools like Azure Monitor, AWS CloudWatch, and custom dashboards in Grafana
  • Troubleshot and resolved replication issues in Distributed Availability Groups and Database Mirroring setups
  • Diagnosed and resolved performance bottlenecks caused by disk I/O, memory pressure, and CPU saturation
  • Led a cross-functional team to deploy and manage MongoDB Atlas in AWS, configuring sharding and replica sets for scalability
  • Worked with developers to design optimal database schemas, stored procedures, and functions tailored to application workloads
  • Provided training and mentorship to junior database administrators, fostering knowledge-sharing and skill development
  • Developed comprehensive backup and disaster recovery strategies, achieving RPO and RTO of under 5 minutes for critical databases
  • Conducted regular failover and restore tests for SQL Server Always On, Distributed Availability Groups, and PostgreSQL replication
  • Client: Credit Agricole Corporate and Investment Bank, Singapore

Database Lead

JPMorgan & Chase
01.2018 - 03.2022
  • Company Overview: Client: JPMorgan & Chase
  • Managing SQL Server instances hosted on AWS RDS, EC2, and Aurora
  • Automating database backups, retention policies, and disaster recovery setups using AWS Backup and S3
  • Configuring multi-AZ deployments for high availability and read replicas for scaling read workloads
  • Managing PostgreSQL databases on-premises, AWS RDS
  • Monitoring query performance using AWS Performance Insights and SQL Server Extended Events
  • Optimizing indexing strategies, execution plans, and partitioning to enhance query performance
  • Managing IOPS and optimizing storage usage on EBS volumes for maximum performance
  • Implemented Always on High Availability across multi subnet and Read scale replicas
  • Worked in planning and migration/upgrade of On-premises databases to Azure Cloud
  • Working on planning the migration of SQL Server databases to PostgreSQL
  • Applying latest CU & Service pack to MS-SQL instances
  • Automating routine maintenance tasks such as VACUUM, ANALYZE, and autovacuum tuning
  • Worked on migrating end of life support SQL Servers 2008/R2 to SQL Server 2016/2019
  • Develop scripts and other forms of automation for routine DBA tasks
  • Establishing guidelines for a defined database architecture and database builds
  • Setup replication for Always on Databases
  • Implemented several data collection jobs in order to analyze database issues, such as missing and unused indexes, deadlocks, disk space, scheduled jobs/durations, plan cache optimization
  • Tracked Server Activity, Query Performance and Disk usage activity statistics via Performance Data Collection
  • Configuring replication strategies including logical replication, streaming replication, and cascading replication
  • Analyzing and optimizing query execution plans using EXPLAIN and EXPLAIN ANALYZE
  • Managed Azure Site Recovery (ASR) and AWS Backup for seamless cross-region failovers during disaster scenarios
  • Client: JPMorgan & Chase

Database Lead

Cognizant Technology Solutions
12.2014 - 01.2018
  • Company Overview: Client: PRNewswire
  • Worked on datacenter consolidation activities which include 1000+ SQL Servers
  • Conducted technical evaluation and proof of concept programs evaluating and implementing Azure Cloud
  • Configured SSIS & SSRS packages for BI reporting
  • Designed and Implemented SQL server Disaster Recovery Solutions using Always ON Availability Groups, Log Shipping & Mirroring
  • Responsible for round the clock monitoring and maintenance of more than 1000+ SQL Server systems in a fault tolerant production environment
  • Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to new version of SQL Server like to 2008 and 2008 R2 to 2012,2014
  • Applied SP (Service Pack)/ Hot Fixes on SQL Server Instances to address security and upgraded related issues
  • Automated regular tasks using PowerShell there saving lot of team working hours
  • Configured database mail, notification services, scheduled jobs & alerts
  • Client: PRNewswire

Database Administrator

Mphasis
01.2013 - 11.2014
  • Company Overview: Client: Bristol Myers Squibb
  • Develop and implement system level DB architecture, coordinate efforts in DB structure design and implementation, performance optimization and other development for global platforms
  • Setup and performed SQL Fail over cluster scenarios in Test and Prod environments
  • Database point-in-time refreshes to support enhancements in lower environments before implementation in production landscapes
  • Work with third party vendors to securely transfer data for resolution of performance issues with the application
  • Proactively managing database storages structures and working with storage teams when necessary to allocate storage
  • Database upgrades and migration to new platforms & new versions
  • Installation MS-SQL server instances & databases
  • Backup & Restore of MS-SQL server databases
  • Applying patches & Service pack to MS-SQL instances
  • Migrated SQL 2005 instances to 2008R2 and 2012
  • Client: Bristol Myers Squibb

Database Administrator

IBM India
12.2010 - 01.2013
  • Company Overview: Clients: Hartford, Ace, Flour
  • Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012
  • Migrated SQL server2008 to SQL Server2012 in MS Windows Server 2012 Enterprise Edition
  • Installed and administered Four-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment
  • Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
  • Expert in Using DMVs, Performance dashboard, Mirroring, database snapshots and tracking Performance Counters
  • Rebuilding / Monitoring the indexes at regular intervals for better performance
  • Recovering the databases from backup in disasters
  • Implementing Point-In-Time Recovery solutions
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
  • Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files
  • Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA)
  • Expert in implementing the snapshot isolation and DDL triggers
  • Responsible for monitoring and making recommendations for performance improvement in hosted databases
  • This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases
  • Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE)
  • Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers)
  • Proactively reacting to alerts with regards to memory, CPU and disk utilization to maintain optimal access to the databases
  • Successfully created scripts in order to monitor the Hit Ratios, Buffer Gets, Explain Plan to identify the hogging sql queries
  • Unit Testing the SSIS packages with respect to its flow and performance issues
  • Solving the Bugs Reflected by the Testing team
  • Clients: Hartford, Ace, Flour

Education

Bachelor of Science - Information Technology

Jawaharlal Nehru Technological University
India
06.2004 - 05.2008

Skills

  • Azure Cloud

  • SQL Server

  • MongoDB

  • Postgres

  • Oracle

  • AWS Aurora

  • AWS Cloud

  • MySQL

Certification

Microsoft Azure Administrator AZ-104
Administering Relational Databases on Microsoft Azure DP-300
AWS Certified Solution Architect – Associate
Administering Microsoft SQL Server 2012 Databases – 462
Querying Microsoft SQL Server 2012 - 461

Timeline

Expert DBA

Credit Agricole
03.2022 - Current

Database Lead

JPMorgan & Chase
01.2018 - 03.2022

Database Lead

Cognizant Technology Solutions
12.2014 - 01.2018

Database Administrator

Mphasis
01.2013 - 11.2014

Database Administrator

IBM India
12.2010 - 01.2013

Bachelor of Science - Information Technology

Jawaharlal Nehru Technological University
06.2004 - 05.2008
Microsoft Azure Administrator AZ-104
Administering Relational Databases on Microsoft Azure DP-300
AWS Certified Solution Architect – Associate
Administering Microsoft SQL Server 2012 Databases – 462
Querying Microsoft SQL Server 2012 - 461
Gowtham KotagiriCloud / Database Administrator