Yashwanth Kotari
Frisco
Summary
Creative and Experienced Professional with excellent communication skills and novel approach, persevering towards an architect role. Extensive technical experience and expertise to design, deploy, automate and administer mission-critical SQL and NoSQL environments with 11+ Years of relevant experience
Overview
12
12
years of professional experience
Work History
Director - Database Reliability Engineer
Angel One Limited
2021.11 - Current
- Manage a team of 15 members for Database Reliability
- Design SOPs and strategies for Business Continuity and stability
- Accountable for the uptime of all the database instances(SQL Server, PostgreSQL and RDS)
- Assist with day-to-day operations, working efficiently and productively with all team members
- Design automation frameworks for Patch Management and Vulnerability assessment
- Automate daily health checks and reports using Powershell, Slack, and Python, decreasing manual work by 10 hours per week
- Design HADR strategies for Database instances
- Design migration strategies from On-Premise to Cloud
- Setup monitoring and alerting for critical performance issues and resource constraints
- Architect deployment of the Applications and dependencies to cloud eco-system
- Deployment of PostgreSQL clusters with HADR capabilities On-premise
Senior Software Engineer (DevOPs)
Walmart Global Technology Services
2018.08 - 2021.11
- Provide consultation and design for new and existing database environments
- Design High Availability and Disaster Recovery solutions for pivotal Database environments
- Automate mundane tasks and self-service utilities using Powershell, Azure Functions, and Runbooks, reducing operational overhead
- Deploy and manager over 4000 databases in both Public and Private clouds
- Drive initiatives for holiday preparedness cost savings, and operation excellence
- Publish documentation and deliver Organization level Tech talks on various Database designs and tools
- Troubleshooting persistent issues, in tandem with Microsoft Support team where required
- Proactively analyzing performance trends of crucial databases, providing meticulous recommendations for seamless customer experience
- Handling Homogeneous and Heterogeneous migrations, leveraging several tools at hand
Advanced Database Administrator
ABCO
2017.04 - 2018.08
- MS SQL Server 2005, 2008, 2008 R2, 2012, 2014 and 2016 Roles and Responsibilities:.
- Automate frequent and regular activities using PowerShell and Stored Procedures.
- Installing, Migrating and Upgrading Database servers to SQL 2014 or above, efforts including sizing and planning.
- Managing SQL Cluster Servers and configuring Monitoring.
- Addressing disk space issues.
- Identifying bottlenecks and providing solutions.
- Troubleshooting Deadlocks and Blockings.
- Benchmarking SQL server performance for Migrations and deployments.
- Creating and managing SSRS reports for in-house reports, including but not limited to Server status, Backup status.
- Orchestrating DBA activities for Monthly Maintenance.
- Automating fix for Orphan users using SQL Alerts.
- Capturing and Fixing SPN issues post reboots and activities.
- Planning for data growth and new server deployments.
Systems Engineer
TCS
2012.06 - 2017.04
- SQL Version : MS SQL Server 2005, 2008, 2008 R2, 2012, 2014
- Experience in database migration from SQL Server 2000 to 2005 and SQL Server 2005 to SQL Server 2008 and henceforth.
- Daily checking issues like backup failures, failed logins, and resolving DB issues.
- Resolving disk space issues and database growth issues.
- Database installation and administration of MS SQL Server 2005, 2008 R2, 2012, and 2014.
- Implementation, maintaining, and troubleshooting of Transactional Replication
- Performing data refresh activities from production to Dev/Test on need basis
- Resolves database performance issues, database capacity issues, and other data issues related to database.
- Maintain database consistency check using DBCC command on weekly basis.
- Performing Failover and Fail-back operations in cluster environment and adding new Disks and troubleshooting activities.
- Perform Server level tuning, performance monitoring, Index Tuning, Query Tuning.
- Migration and up-gradation of servers and databases.
- Repetitive issues analysis and proposals for permanent resolutions
- Perform Server level tuning, performance monitoring, Index Tuning, Query Tuning
Education
B.Tech - ECE
SRM University
Chennai, TN2012
Skills
- MS SQL Server, PostgreSQL
- Azure SQL (PaaS)
- Amazon RDS
- Azure Cloud
- T-SQL
- Powershell
- ComosDB and MongoDB
- YAML and Python
Tool
- ServiceNow
- Atlasssian Stack
- GIT
- Azure Monitoring
- Nagios
- Solarwinds
Timeline
Director - Database Reliability Engineer
Angel One Limited
2021.11 - Current
Senior Software Engineer (DevOPs)
Walmart Global Technology Services
2018.08 - 2021.11
Advanced Database Administrator
ABCO
2017.04 - 2018.08
Systems Engineer
TCS
2012.06 - 2017.04
B.Tech - ECE
SRM University
Similar Profiles
Anindo Sinha ChowdhuryAnindo Sinha Chowdhury
Customer Service Associate at Angel One LimitedCustomer Service Associate at Angel One Limited
Pradnya WanmaliPradnya Wanmali
Senior Executive KYC at Angel One LimitedSenior Executive KYC at Angel One Limited
Harshada R HaldankarHarshada R Haldankar
Specialist at Angel One LimitedSpecialist at Angel One Limited