Amit Kanojia

Experience

• 

  Teradata

  Aug 2018 - Jul 2023

  • Spearheaded performance analysis and optimization initiatives through indexing, statistics, optimized joins, spool usage, and query rewriting resulting in a 40% enhancement of system performance for daily load jobs• Investigated and provided SQL tuning recommendations for Business and ETL queries saving approximately 1 billion CPU seconds with an average improvement of approximately 90 percent in query performance• Developed Python, SQL, and Shell scripts for performing daily batch loads into new environments on the production server• Analyzed 100 million+ rows of performance data using SQL to assess and improve database performance• Visualized database performance metrics using Excel, Tableau and Power BI, and presented actionable insights to clients through weekly, bi-weekly, and monthly reports• Led discussions with clients to understand business needs and provided tailored solutions, bridging technical insights with client goals to build long-term relationships Show less • Administered, supported, and monitored Teradata on-premises and cloud databases by resolving complex database issues such as server restarts, ETL job failures, space optimization and maintaining servers• Managed Database permissions for 1000+ users across Business and ETL teams, ensuring data security and access control• Analyzed backup failures and developed robust backup and recovery scripts thereby reducing monthly backup failures by 70% and increasing backup reliability on the Teradata DSA• Supervised quarterly maintenance activities such as Teradata database version upgrades, software patches, migrations, memory replacements, server restarts by coordinating with cross-functional teams to ensure seamless execution Show less

  • Teradata Data Engineer

    Dec 2020 - Jul 2023

  • Teradata Database Specialist

    Aug 2018 - Nov 2020
• 

  Amazon

  May 2024 - Aug 2024

  Business Intelligence Engineer

  • Developed and deployed a global spare parts metadata dashboard using Amazon QuickSight, SQL, and AWS Glue, providing real-time visibility across 1,824 sites, reducing manual data extraction• Accelerated query performance in Redshift by 90% through indexing, distribution keys, and optimized joins, eliminating timeouts for mission-critical dashboards• Developed a sourcing dashboard leveraging QuickSight & SQL, driving procurement efficiency and enabling data-driven tracking of supplier performance KPIs• Created CI/CD data pipelines using Datanet, AWS S3, and Glue to enable automated refreshes and query history tracking Show less