Working in the Exadata Storage Server Group

1. Presently working towards improving JSON query processing – internal storage of JSON documents in SQL Server in binary format for faster search/read-access query performance

2. Technical Lead for adding Backup/Restore Database support for AWS S3 Object storage – worked on the project end-to-end (design, development, testing, customer engagement, shipment) - Releasing in SQL Server v22

3. Contributed towards shipping of Big Data Cluster (SQL Server 2019 release) – Data Pool Stress Testing, Controller Server Certificate Security Validation, SSDT support for Data Pool/Storage Pool External Table/Data Sources

4. Part of BDC Life Cycle Data Management Project – Enabling HTAP support across BDC storage components

5. Served as a Mentor for junior engineers involved in Backup to S3 Object Store and HTAP projects. Assisted new-hires in project ramp-up & provided mentorship guidelines for successful contribution, delivery and technical growth

AWS Internet of Things (IoT) Data Service Group

IoT Events – detects and responds to events from IoT sensors.

1. Implemented the GDPR (General Data Protection Regulation) Component for IoT Events

2. Built the Control Plane APIs and Java SDK for creation/updation/deletion/list of detector models and inputs by customers

3. Involved in Implementation of various Console Pieces for the IoT Events Platform

IoT Analytics - perform analytics on volumes of IoT data

1. Worked on displaying customer’s IoT Raw Data Storage on the IoT Analytics Console. Involved fetching the underlying AWS S3 bucket CloudWatch metric (back end) and sending it to the Analytics Console for display (front end)

2. Wrote a blog (link below) on Using AWS IoT Analytics to Prepare Data for QuickSight Time-Series Visualizations

1. Responsible for design and maintenance of Exadata Storage Server offload features such as Smart Scan, Smart Backup and Smart File Creation, for extreme performance of the Exadata Storage Server

2. Big Data SQL: Added DB Support for Joint SQL queries between Exadata internal tables & External tables stored in HDFS

3. Columnar Cache (IMC) for uncompressed/OLTP data: Created an in-memory region heuristics data structure to monitor data blocks ineligible for IMC. Prevented IMC population retries for these blocks improving query performance

4. Oracle Database Cloud Exadata Service: Added support for listing files and directories stored in cloud servers by web clients. Worked on the entire end-to-end path from web client to the data residing in storage servers