Sandeep Mehta

Background

About Sandeep Mehta

20+ Years of IT experience with proven expertise as Database Administrator/Data Architect/ Data Engineer and Automation Engineer on both OLAP,OLTP and Data Warehouse systems, out of which 15+ years of experience in DB2 UDB FOR UNIX administration + AWS Sysops Administrator and Snow Flake with expertise in Analytic databases starting from V8.1, V9.1, V9.7, V10.1, V10.5, v11.1, v11.5, Vertica v11.1, Snow Flake, Postgres SQL and Cassandra. • Experience in using Snowflake's Stage,Integration, Stream, Pipe and task objects in Multi Clustered environment. • Developing and optimizing ETL processes for loading data into Snowflake using S3 bucket and different file formats(CSV,JSON, PARQUET etc). • Loading data into snowflake tables from internal stage using snowsql. • Used COPY, LIST, PUT and GET commands for validating the internal stage files. • Used FLATTERN table function to produce a lateral view of VARIENT, OBJECT, and ARRAY column. • Used Snow Pipe for continuous data ingestion from S3 bucket. • Experience in using Snow Flake time travel, Clone objects. • Performed various automation workflows leveraging Unix Shell script, Python, Ansible playbooks, Splunk, BladeLogic. • Expertise in Database Architecture, Engineer, Administration, Automation, Design, Migration, High Availability, Sustainability, Development, Maintenance on different database platforms including DB2 11.5, Postgres SQL, Cassandra. • Deep knowledge in Database performance tuning and SQL Optimization. • Database maintenance, backup, recovery, performance monitoring, tuning, maintenance of logs, problem identification and resolution, security, and disaster recovery planning. • Lead & managed Vertica upgrade projects from v9.x to 11.1.x. • Worked/implemented DB2 features compression, High Availability solutions (HADR), Multiple Read only HADR. • Experienced in configuring Health Monitors, setting up event monitors, and performance tuning using utilities like VMSTATS, IOSTATS, PS, NMON, TOPAS, DB2TOP, MONREPORT modules, MON_GET* functions. • Exposure to Amazon Web Services like RDS PostgreSQL, Redshift, Lambda, CFT (Cloud Formation Templates), EC2, S3 Bucket, Glacier, Cloud Watch, managing security groups, VPC, Route53. • Experienced in supporting 24/7 production environments and change management tools. • Proven interpersonal, communication, problem solving skills and technical analysis.