Aruna Gotety
Marietta,GA
Summary
- Senior Database Administrator with 11 years of experience in SQL Server, PostgreSQL, and NoSQL (Elasticsearch and DynamoDB). Extensive experience managing various databases on Amazon Web Services (AWS) as well as on-premises. Ability to influence without authority architects and managers across departments and geos on a cost reduction effort resulting in over $1M / year of cloud savings.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Senior Database Administrator
VMware Carbon Black
10.2021 - Current
- Responsible for optimizing DynamoDB COGS which resulted in 50% savings (approx
- 1M/year)
- Coordinated with various senior engineering architects and managers to plan and execute database changes, ensuring compliance with best practices and cost reduction strategies, including:
- Enabling Time To Live (TTL) on DynamoDB tables, resulting in significant reduction of stored data
- Defined appropriate backup solutions (PITR vs AWS backup) and table classes (Standard vs Infrequently accessed class) based on table usage and intent
- Calculated and determined number of reservations for DynamoDB tables that resulted in 30% of COGS savings
- Developed Python script to identify unused DynamoDB tables and terminated approx
- 300 tables, leading to significant COGS savings
- Responsible for optimizing RDS/Aurora costs across over 100 production and non-production databases through capacity and performance analysis, right-sizing, resulting in approximately $600k/year in savings
- Developed and deployed Python scripts to automate COGS report generation for PostgreSQL, DynamoDB, OpenSearch, and Kinesis, which reduced manual effort by 80% and resulted in improved accuracy and timely insights for decision-making
- Responsible for setting up PostgreSQL RDS/Aurora on AWS, including configuration, backup and restore procedures, performance tuning, access restrictions, encryption, and minor version upgrades
- Implemented creative solution to efficiently handle large data volumes in PostgreSQL table with over 2 TB of data/rows by employing truncate and re-create approach instead of deletion
- Developed SQL script for cross-referenced data clean-up in PostgreSQL databases, involving 20+ tables to ensure GDPR compliance
- Developed Python script to consolidate configuration details from multiple PostgreSQL Aurora/RDS instances across various AWS accounts and regions, simplifying visibility of hundreds of databases. Subsequently, constructed user-friendly visual interface using Wavefront to aggregate all PostgreSQL information into comprehensive view
- Implemented Amazon EventBridge to notify stakeholders about critical security vulnerabilities on various products Carbon Black uses
- Created best practice document for PostgreSQL RDS and implemented it across all environments
- Responsible for 24/7 on-call production support for mission-critical SQL Server, PostgreSQL, and Elasticsearch databases, ensuring high availability and minimal impact on customers.
Elastic Stack Architect
VMware, Inc
03.2018 - 10.2021
- Designed, planned, and implemented Elastic Stack on VMware vSphere and AWS EC2
- Partnered with senior leadership to plan, coordinate, execute, and integrate various business teams with Elastic Stack usage
- Managed various versions of Elastic Stack clusters from 6.0 to 6.3.2
- Performed POC of Elastic Stack on AWS EC2 and on-premises for log aggregation
- Responsible for design, build, capacity planning, and deployment of Elastic Stack clusters on VMware vSphere Stage and Production
- Configured Active Directory and X-pack for monitoring and security on Elasticsearch-6.0 and 6.3.2 clusters
- Integrated various plugins and extensions viz
- Slack, Elasticsearch-head, and various maintenance jobs
- Customized and deployed various database and application alerts as per business requirements
- Automated deployment of Elastic Stack using shell scripting
- Created and customized various dashboards for Kibana
- Subject matter expert on Elastic Stack and helped Developers/SREs troubleshoot issues related to Elastic Stack
- Documented various operating procedures (run books for troubleshooting production issues and deployment and configuration of Elastic Stack)
- Mentored other team members in various Elastic Stack procedures
- Responsible for 24/7 on-call production support for Elastic Stack.
Senior SQL Server DBA
VMware, Inc
03.2013 - 10.2021
- Database Administration for large and complex production databases on SQL Server 2016, SQL Server 2012, and SQL Server 2008 R2
- Implemented numerous Always-ON (AAG) on SQL Server 2012 and 2016
- Setup and configured SQL Server Log Shipping (Disaster Recovery)
- Resolved various performance-related bottleneck issues
- Performed numerous SQL server cluster installations
- Performed SQL Server and Windows Operating System patching to keep product up to date (security and bug fixes)
- Performed SQL Server upgrades for various versions
- Performed SQL Server database deployment
- Migrated SQL Server databases from On-premises to SaaS and SaaS to AWS GovCloud
- Installed and configured SQL Server Clustering
- Created SSRS Reports, imported data into database, and exported data from database
- Developed customized reports to support customers’ one-off requests
- Performed Query optimization to improve performance of slow-running queries
- Responsible for setting up SQL Server backups and restoring backups
- Responsible for creation of various documents (run books for troubleshooting production issues and deployment and configuration of SQL Server)
- Developed PowerShell script for backup of all SQL Server databases
- Mentored junior team members
- Responsible for 24/7 on-call production support for SQL Server.
Education
Master of Science in Information Technology -
Kennesaw State University
Marietta, GA05.2017
Bachelor’s degree in Science -
Osmania University
Hyderabad, India04.2001
Skills
- Databases: Aurora, RDS, PostgreSQL, DynamoDB, SQL Server 2012 - 2022, Elasticsearch, OpenSearch, Oracle 11i
- AWS Services: EC2, S3, RDS, Lambda, IAM, CloudWatch, Cost Explorer, EventBridge, SNS
- Operating Systems: Linux, RHEL/CentOS/7x, Windows Server 2012, Solaris, Unix
- Virtualization/Cloud Technologies: Kubernetes, VMware vSphere 4x, AWS, Docker
- Languages: SQL, Python, T-SQL, PowerShell, Shell
- Tools: Boto3, Terraform, GitLab, Athena, Vivid Cortex, pgAdmin, JIRA, Shavlik, SQL Sentry, Commvault, SolarWinds, OpenSSL, KeyStore Explorer, Pager Duty, Device42
- Visualization Technologies: Wavefront, Tableau
Employment Eligibility
US Citizen
Certification
Administering Microsoft SQL Server Database - 2012, 04/2001
Timeline
Senior Database Administrator
VMware Carbon Black
10.2021 - Current
Elastic Stack Architect
VMware, Inc
03.2018 - 10.2021
Senior SQL Server DBA
VMware, Inc
03.2013 - 10.2021
Master of Science in Information Technology -
Kennesaw State University
Bachelor’s degree in Science -
Osmania University