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
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
Similar Profiles
Julie STASIACKJulie STASIACK
CONSEILLER DES PARTICULIERS at CREDIT AGRICOLECONSEILLER DES PARTICULIERS at CREDIT AGRICOLE
KRISHNA BULLAVJAYKRISHNA BULLAVJAY
Information Technology Manager at Credit AgricoleInformation Technology Manager at Credit Agricole
ABDELALI TARTOURIABDELALI TARTOURI
Internal Controller at Credit AgricoleInternal Controller at Credit Agricole