06/01/2025 updated
BM
100 % available
Snowflake cost and performance tunning
Cuttack, India
Only remote
BE in Computer ScienceQuery PerformanceData ModelingData WarehousingDatabase ApplicationDebuggingMaintenanceOracle ApplicationsPerformance TuningPL-SQLSQL DatabasesSnowflakeDatabase Administration
Snowflake Optimization
Expertise in Snowflake optimizations with proven track record of improving query performance and optimizing data warehouse processes. Implemented partitioning strategies and clustering keys to improve query performance.
Last year my team has saved 13M$ for client Apple by optimizing SQL and Jobs under my guidance.
It needs expertise of analysis and debugging the issue hinnde inside the SQL and JOB and suggest a good desing for low cost and it comes with experience only.
SQL/Database Management
Advanced skills in SQL, PL/SQL, and Oracle. Experience in database application development and maintenance. Expertise in processing huge data volumes in real-time using SQL and PL/SQL.
Data Warehouse Development
Extensive experience in designing and implementing data models to optimize storage and processing efficiency. Led teams to optimize Snowflake data warehouse, resulting in 30% reduction in costs.
Performance Tuning
Expertise in conducting performance tuning and troubleshooting to enhance overall system performance. Familiar with resolving issues like Flip-join, join-explosion, join push-down, and pruning.
Expertise in Snowflake optimizations with proven track record of improving query performance and optimizing data warehouse processes. Implemented partitioning strategies and clustering keys to improve query performance.
Last year my team has saved 13M$ for client Apple by optimizing SQL and Jobs under my guidance.
It needs expertise of analysis and debugging the issue hinnde inside the SQL and JOB and suggest a good desing for low cost and it comes with experience only.
SQL/Database Management
Advanced skills in SQL, PL/SQL, and Oracle. Experience in database application development and maintenance. Expertise in processing huge data volumes in real-time using SQL and PL/SQL.
Data Warehouse Development
Extensive experience in designing and implementing data models to optimize storage and processing efficiency. Led teams to optimize Snowflake data warehouse, resulting in 30% reduction in costs.
Performance Tuning
Expertise in conducting performance tuning and troubleshooting to enhance overall system performance. Familiar with resolving issues like Flip-join, join-explosion, join push-down, and pruning.
Experience
Professional experience0 - 5 years
Freelancer since2025
Languages
EnglishFluent
Project history
Leading the Snowflake Platform Team for Apple. Optimized Snowflake data warehouse resulting in 30% reduction in storage costs. Implemented partitioning strategies and clustering keys to improve query performance. Developed monitoring dashboards to track system performance.
Managed multiple projects for Apple including GSDR Automation, iOS Unbrick Redesign, IIMM, and iOS Quote Ladder. Led development teams for data warehouse projects focusing on Oracle ODS systems. Implemented solutions that made processes up to 10 times faster.
Worked for Deutsche Bank on GMARS project. Responsible for data loading and cube building in SQL/PLSQL environment.