Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic
Sruthi Kotte

Sruthi Kotte

Hyderabad

Summary

Accomplished SQL Database Administrator and Azure SQL DBA with over 9 years of experience in managing, migrating, and optimizing SQL Server databases across both on-premises and cloud environments (Azure, AWS). Expertise in Azure SQL Managed Instances, SQL Server migrations, high availability setups, encryption, and disaster recovery. Skilled in utilizing Terraform for Azure resource deployments, implementing TDE encryption, managing GMSA accounts for SQL services, and conducting post-migration checks. Known for strong collaboration with clients, cross-functional teams, and providing guidance on database architecture and migration strategies.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Azure SQL DBA/Database Migration Specialist/Azure Consultant

Accenture
Hyderabad
08.2021 - Current
  • Led SQL Server migrations from on-premises environments to Azure SQL Database and AWS RDS, ensuring minimal downtime, zero data loss, and meeting SLA requirements for mission-critical systems.
  • Deployed Azure resources (SQL Databases, Virtual Machines, Network Security Groups, Storage, VNET) using Terraform, significantly improving infrastructure deployment time and consistency.
  • Coordinated with cross-functional teams and client DBAs to design and execute cloud migration strategies, providing guidance on SQL Server version upgrades, performance tuning, and post-migration checks.
  • Implemented Always On Availability Groups for high availability in both on-prem and cloud environments, ensuring seamless failover and business continuity.
  • Configured TDE encryption (Transparent Data Encryption) and Column-Level Encryption using Customer Managed Keys (CMK) in Azure SQL Managed Instances, improving data security and compliance.
  • Performed SQL Server domain migrations, including transferring SQL Server authentication and Windows authentication to new domains, ensuring seamless access control during transitions.
  • Automated backup and recovery using Azure Recovery Services Vault and Azure Storage Account, enabling efficient point-in-time recovery and minimizing RTO/RPO.
  • Managed Group Managed Service Accounts (GMSA) for SQL Server services, enhancing security and simplifying password management in hybrid environments.
  • Supported the deployment of SQL Server AlwaysOn Availability Groups, mirroring, log shipping, and clustering to ensure high availability and disaster recovery capabilities.
  • Utilized Azure Data Studio, SQL Server Management Studio (SSMS), and Azure DMS for database management, migration, and troubleshooting.
  • Worked closely with clients to document migration techniques, best practices, and post-migration validation checks to ensure successful project delivery

Azure SQL DBA

Cognizant
Hyderabad
03.2021 - 08.2021
  • Managed and optimized SQL Server databases across a hybrid cloud environment, implementing high availability solutions and disaster recovery plans.
  • Led several large-scale SQL Server migrations from on-premises to Azure SQL Managed Instance and AWS RDS, ensuring smooth transitions and adherence to security standards.
  • Coordinated with client DBAs to provide regular post-migration support and troubleshooting, addressing performance issues, security concerns, and system optimizations.
  • Performed regular security audits, including configuration of TDE encryption and column-level encryption to ensure database compliance with industry standards and regulations.
  • Automated daily backup, restore, and database maintenance tasks using PowerShell, SQL Server Agent, and Azure Automation.
  • Configured Azure Virtual Network, Firewall rules, and Network Security Groups for secure cloud connectivity and SQL Server access.
  • Supported disaster recovery using Azure Site Recovery and SQL Server log shipping to ensure business continuity in the event of a failure.

SQL Database Administrator

Bank of America
Hyderabad
05.2019 - 03.2021
  • Managed and optimized SQL Server databases across a hybrid cloud environment, implementing high availability solutions and disaster recovery plans.
  • Led several large-scale SQL Server migrations from on-premises to Azure SQL Managed Instance and AWS RDS, ensuring smooth transitions and adherence to security standards.
  • Coordinated with client DBAs to provide regular post-migration support and troubleshooting, addressing performance issues, security concerns, and system optimizations.
  • Performed regular security audits, including configuration of TDE encryption and column-level encryption to ensure database compliance with industry standards and regulations.
  • Automated daily backup, restore, and database maintenance tasks using PowerShell, SQL Server Agent, and Azure Automation.
  • Configured Azure Virtual Network, Firewall rules, and Network Security Groups for secure cloud connectivity and SQL Server access.
  • Supported disaster recovery using Azure Site Recovery and SQL Server log shipping to ensure business continuity in the event of a failure.

SQL Server Database Administrator

IBM
Hyderabad
05.2015 - 03.2019

Database Administration: Administered SQL Server databases, ensuring optimal performance and reliability in a high-volume financial environment.

Backup & Recovery Solutions: Developed and implemented comprehensive backup and recovery strategies, ensuring minimal data loss and compliance with regulatory requirements.

Performance Tuning: Conducted regular database performance tuning, including index optimization and query performance analysis, resulting in improved application response times.

Security Practices: Implemented security best practices, including user access management and encryption techniques, to protect sensitive financial data.

Collaboration: Worked closely with development teams to support database requirements for new applications and enhancements, ensuring seamless integration and performance.

Incident Response: Provided 24/7 support for critical production systems, quickly troubleshooting and resolving database-related issues to maintain uptime.

Education

Btech - ECE

Tirumala Engineering College
Hyderabad
04-2014

Skills

  • Microsoft Azure colud mangement
  • Database Administration & Migration
  • Azure Managed Instance
  • Azure SQL Database
  • AWS RDS/EC2
  • High availability
  • Azure DMA/DMS/azure Data studio
  • Azure recovery service vault
  • Backup and recovery
  • Database maintenance
  • Performance tuning
  • Domain migrations
  • TDE
  • Alwayson
  • Clustering
  • Mirroring
  • Incident management
  • Change management
  • Mirroring
  • Mongodb
  • Terraform
  • Azure Devops

Certification

  • AZ 900,AZ 104,AZ 305,DP 300

Languages

Telugu
First Language
English
Proficient (C2)
C2
Hindi
Upper Intermediate (B2)
B2

Timeline

Azure SQL DBA/Database Migration Specialist/Azure Consultant

Accenture
08.2021 - Current

Azure SQL DBA

Cognizant
03.2021 - 08.2021

SQL Database Administrator

Bank of America
05.2019 - 03.2021

SQL Server Database Administrator

IBM
05.2015 - 03.2019

Btech - ECE

Tirumala Engineering College
Sruthi Kotte