Rajesh Bodagala

- 18 years of IT experience, working as Solution Architect & Data Engineer. - Expert in designing MPP Data warehouses and complex OLTP workloads. - Designing solutions to migrate On-prem warehouse to Cloud. - Working on cutting edge technologies on Data ingestion using Spark,Kafka,HVR. - Excellent hands on with Snowflake,Teradata, Vertica,DB2, Greenplum & Sybase. - Expert knowledge on internal Architecture of all above database technologies. - Developed ETL infrastructure to move data between various database systems. - Developed Various performance monitoring/reconciliation tools. - Heavy Automation tools development using Perl & Python. - Expert in CI/CD pipelines using Jenkins and Azure Devops. - Performance Tuning and CPU,IO,Memory optimization on all database technologies. - Very good hands on long running query optimizations in any database. - Developed Automatic data Archive/Purge solutions. - Database maintenance on Backup,Statistics,Reorg,Partitions,Tablespaces,Storage. - Defining Work Load/Resource pool Management on various database technologies. - Expert in eliminating Join & Storage/data Skew. - Query analysis and proposes Join Indexes & projection optimizations. - Project planning ,regular meetings with teams and works on Scrum/kanban methods. - Outage handling, postmortem analysis and prevention techniques. Certifications/Badges: - Snowflake - Hands On Essential - Data warehouse. - Snowflake - Hands On Essential - Data Sharing. - Vertica Certified Professional