Ravindra Dhanisetty

Teradata DBA :

High-performing professional with 12+ years extensive experience managing large-scale, complex databases. Skilled in Teradata SQL and database management systems. Strong understanding of database design and data modeling with excellent troubleshooting skills. Smart and committed to staying up-to-date with new technologies and advancements.

• Expertise in Teradata tools & utilities like SQL Assistant, Teradata Studio, Viewpoint, BTEQ, Fastload, Mload, Backup and Recovery Tools With ARCMAIN & DSA, Stats Manager, Checktable, Recovery manager, scandisk, Showlocks, DBSControl, FERRET, PACKDISK.
• Experience in User Access Management, Data Lab setup, Columnar, Temporal, Compression (BLC & MVC).
• Good Experience on Roles and Profiles Management.
• Expertise in Teradata Database design, Query optimization, Performance Tuning, DBQL & Access logging, PDCR and having good Teradata DBA troubleshooting. Strong logical building and problem-solving skills.
• Performed pre and post upgrade activities for Teradata software version control updates.
• Good Knowledge on cloud databases like AWS/AZURE.
• Well-versed on Service Management tools and handling Incidents and problem tickets within organisation and Teradata vendor support team.
• Proficiency in Customer Interaction and Proficiency in Documentation.
• Demonstrates strong analytical, communication, and teamwork skills, with proven ability to quickly adapt to new environments. Eager to contribute to team success and further develop professional skills. Brings positive attitude and commitment to continuous learning and growth.

Snowflake DBA :

Driven Database Admin with 3 years of proven success designing and implementing database solutions. Analytical and skilled in understanding business problems to develop systems that improve functionality. Talented at working effectively in collaborative and self-motivated environments.

• Creation & Management of Snowflake objects like Database/Schema /Tables/Views/MVs /Pipes, Streams, Task Creation & Management.
• Account level Objects like Warehouse, Resource Monitor, Network Policies, Integration (Storage, Notification), Shares Connectivity issues resolution with ODBC, JDBC, Python Connecters.
• Create replication and failover groups and restore data from Fail safe or from time travel data.
• Troubleshoot data loading issues, connection issues and Snow pipe issues.
• User management, Implementation of RBAC best practices.
• Access Rights Management, experience with privileged roles Accountadmin, Sysadmin and Securityadmin.
• Analyzing and Planning the Workload, Warehouses with Multi-clusters, Scaling policies and Application Specific warehouse creation and management for efficient Compute consumption.
• Generate, manage and analyze Cost/credits Consumption reports and identify cost optimization areas.

• Teradata Vantage Certified Associate.
• Teradata Vantage Certified Administrator.

Involved in Migration/upgrades Event:

• Replicating the prod systems for migration of bankA to bankB in year 2011.
• Database Version upgrades TD13 to TD14 in year 2013.
• Non Prod Databases Hardware upgrades in year 2014.
• Database Version upgrades TD14 to TD15 in year 2015.
• Database Version upgrades TD14 to TD16.20 in year 2019.
• Database Version upgrades TD16 to TD17.10 in year 2021.
• Cloud Migration from on perm Teradata database to Snowflake database.