ARUNA GOTETY
MARIETTA,USA
Summary
Senior Database Administrator with 12+ years of experience managing SQL Server, PostgreSQL, and diverse NoSQL databases including MongoDB and Cassandra. Expert in complex database migrations, high-availability configurations, and infrastructure optimization across cloud and on-premises environments. Proven ability to drive cost savings and operational efficiency, delivering over $1M/year in cloud cost reductions through strategic architectural recommendations.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Principal Systems Engineer
U.S Bank
07.2024 - Current
- Leading MongoDB RHEL 7 to RHEL 8 on-premises server migration project, serving as SME for MongoDB and Cassandra databases
- Design and implement MongoDB cluster configuration with high availability across 5-node infrastructure
- Develop and execute comprehensive backup, restore, and Initial sync strategies for NoSQL databases
- Conduct regular Disaster Recovery (DR) failover testing, validating system resilience and ensuring minimal downtime during potential production disruptions
- Implement robust security measures including role-based access control, encryption at rest and in transit, and regular security audits
- Optimize MongoDB performance through effective indexing strategies, query optimization, and data model refinement
- Collaborate with cross-functional teams to resolve complex migration issues and ensure seamless integration with applications
- Implement log management policies, including retention and rotation, to support security investigations and compliance requirements
- Provide 24/7 on-call support for MongoDB-related issues, ensuring high availability and quick problem resolution
- Leverage extensive database migration expertise to streamline infrastructure modernization efforts
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 - Information Technology
Kennesaw State University
Marietta, GA05.2017
Bachelor's degree - Science
Osmania University
04.2001
Skills
- Databases: Aurora, RDS, PostgreSQL 96 to 13, MongoDB, Cassandra, DynamoDB, SQL Server 2012 to 2022, Elasticsearch, OpenSearch
- AWS Services: EC2, S3, 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
Timeline
Principal Systems Engineer
U.S Bank
07.2024 - Current
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
Bachelor's degree - Science
Osmania University
Administering Microsoft SQL Server Database - 2012
Master of Science - Information Technology
Kennesaw State University
Similar Profiles
Diyana ArabuDiyana Arabu
Assistant Branch Manager, Operations at U.S BankAssistant Branch Manager, Operations at U.S Bank
TIFFANY BROWNTIFFANY BROWN
Collections and Service Representative at U.S BankCollections and Service Representative at U.S Bank
Corinthia BrandonCorinthia Brandon
Credit Card Representative at U.S BankCredit Card Representative at U.S Bank