Shivanand Naik Email and Phone Number

Relevant Teradata Consulting EngagementsApple Inc. USA - =============Performance Tuning DBA (Onsite & Offshore) 05/2012 – Till DateWorked as an Onsite (Austin, Tx) and Offshore consultant for Apple IncWith proficient skills in designing, writing and Tuning convoluted stored procedures and job scripts for business users, I am responsible for re writing the high resource consuming codes to run in more efficient manner. My role also includes troubleshooting issues… Show more Relevant Teradata Consulting EngagementsApple Inc. USA - =============Performance Tuning DBA (Onsite & Offshore) 05/2012 – Till DateWorked as an Onsite (Austin, Tx) and Offshore consultant for Apple IncWith proficient skills in designing, writing and Tuning convoluted stored procedures and job scripts for business users, I am responsible for re writing the high resource consuming codes to run in more efficient manner. My role also includes troubleshooting issues related to Querygrid, Analyzing and implementing new features into production environment to better utilize system resources, Create interactive charts in Tableau and present the same to the Client during BRM meetings. Played a major role during Teradata Upgrades and Expansion at Apple.Technologies Deployed: Teradata 16.20, TPT, TD Vantage.CVS Pharmacy=============Teradata Production DBA 12/2011 – 04/2012As a Production DBA, I was involved in the day to day administration and architecture CVS data warehouse. This included Daily/Weekly Backups and Restore using TARA and Netvault, monitoring and performance tuning of the CVS user adhoc queries and standard reporting queries coming from BI query tool. Created several TD system usage reports for monitoring and capacity planning and for the higher management.Cleaned up the unused Profiles and Roles, eliminated redundant security rights to eliminate user level security.Performed Space Management for Perm & Spool Space. Query Analysis using Explain for unnecessary product joins, confidence factor, join type, order in which the tables are joined.Technologies Deployed: Teradata 13.10, PMON, Netbackup, TARA etc. Show less