Vivek Billore

Background

About Vivek Billore

Specialties: Snowflake SME 1. Snowflake Automations 2. Data Migration 3. Database Creation 4. Schema Creation/Management 5. Roles Creation/management 6. External Table Creation 7. Management of Access Rights 8. Stages Creation & Management 9. SQL Tuning 10. File Format Creation/Management 11. Procedures/UDF Creation and Management 12. Warehouse Creation & Management 13. Resource Monitor Creation Management 14. Share house Creation and Management 15. Utilizing Time Travel,Undrop,Cloning features as per the requirement 16. Managing Credit Quota 17. Performance Monitoring and ensuring that the query response times are within service level goals 18. Tuning the queries having performance Problems 19. Identifying the bottlenecks in the query and implementing the changes to eliminate the bottleneck 20. Analyzing data, identifying gaps,issues,patterns and trends 21. Creating and Managing Integrations 22. Automating Day to Day Activities using Python and Shell 23. Dynamic Data Masking Implementation 24. Worked on Database Replication in Snowflake 25. Implementing and Testing Secondary Roles in Snowflake 26. Worked on Snowpipe,Streams,Tasks & Automating Snowpipe for Microsoft Azure Blob Storage 27. Experience in Using Git,Jenkins Teradata: Teradata Administrator/ Teradata SQL- Creating/Modifying/Dropping Teradata objects like Databases,Tables,Users,Profiles,Roles etc. Space Movement,Viewpoint,PDCR,DBQL,BTEQ,MultiLoad,FastLoad,Teradata SQL Assistant, Performance Management,SQLTuning,Statistics Collection, Space Management, ETL Support(Troubleshooting loading issues in FLOAD,MLOAD),Monitoring/Resolving Session Blocking,EDW Support, Migration. Roles and Responsibilities : 24*7 Production Support. Performance Monitoring and ensuring that the query response times are within service level goals. Preparation of backup and restore scripts and monitoring (TARA GUI and DSA). Tuning the queries having performance Problems. Advise Structural changes and give STATS collection recommendations wherever required. Recreating the tables with new PI for resolving Skew/Space issues. Identifying the bottlenecks in the query and implementing the changes to eliminate the bottleneck. Execution of adhoc queries. Backup Tools: TaraGUI,ARCmain,DSA Oprating Systems:Unix,Windows Server,Windows XP, Windows Vista,Linux Databases:Teradata 14/15/16 Responsible for Upgrades, Migrations, Patches, Remote console CNS utilities, BLC, Checktable, Packdisk, Scandisk, DBScontrol, Viewpoint,TASM,Backup/Restores/policies BAR,Netbackup, capacity planning.Good Exposure to Python.