• Designed and implemented a three-tier architecture to support real-time user interaction and scalable role-based workflows.

• Built RESTful APIs and integrated access controls for different user roles.

• Tuned PostgreSQL queries and backend endpoints to optimize performance.

• Deployed containerized microservices using Kubernetes and Docker to support high-availability backend services.

• Collaborated in Agile sprints with UI, frontend, and backend teams.

Responsibilities:

• Maintained and optimized production-grade Oracle 19c and MySQL 8.x databases powering GrubMarket’s AI-driven supply chain management platform.

• Conducted SQL performance tuning, index optimization, and partition management to support real-time procurement, inventory, and logistics workflows.

• Designed and implemented automated backup, recovery, and monitoring solutions using Python scripts integrated with AWS CloudWatch and RDS snapshots

• Migrated legacy on-prem Oracle instances to AWS RDS for Oracle, and restructured MySQL deployments for microservice workloads with improved fault tolerance and scalability.

• Collaborated with product and infrastructure teams to design normalized schemas and stored procedures tailored for microservice-based architectures (Java Spring Boot).

• Developed tooling and dashboards to monitor query latency and IOPS, helping reduce critical API response time by 50% during high-volume order processing.

• Supported secure data synchronization across multi-environment (dev/staging/prod) setups using schema versioning tools like Liquibase.

Tech Stack:

• Oracle 19c, MySQL 8.x, PostgreSQL, AWS RDS, AWS Lambda, CloudWatch, Python, Bash

• Performance tuning, partitioning, slow query profiling, index design

• Java Spring Boot microservices integration, RESTful APIs

• Infrastructure-as-code for database provisioning and alerting

Key Achievements:

• Improved data throughput across Oracle/MySQL services by 30%, enabling real-time insights into inventory and vendor logistics.

• Reduced system downtime risk by implementing robust backup/restore automation, contributing to >99.99% availability for core services.

• Enabled seamless backend scaling by aligning database design with evolving microservices architecture.

• Supported hotel management systems and internal IT infrastructure.

• Conducted database updates and data integrity checks.

• Provided automation support using Python scripts.

• Visualized sales and inventory.

Local Greens is a hydroponic farm based on controlled environment agriculture (CEA) now launching the first facility in Berkeley, CA. It uses no soil, minimal water, low energy - using specialized growing techniques that mimic nature. Local Greens will serve commercial customers such as Whole Foods and Safeway as well as institutions, such as hospitals and schools.

• Analyzed sales volume data and generated sales and inventory projections using Excel and SQL

• Created visualizations of sale-volume data per store using Tableau in order to optimize the delivery of products to customers.

• Organized and managed daily data through Smartsheet.

• Deal with daily invoices through Quickbook.

• Built its auto office system in order to improve its workflow.

• Increased yearly sales 25% to 15 million RMB.

• Expanded marketing promotion events from 12 per year to 28.

• Developed 2 new online sales channels, increasing sales by more than 2 million RMB.

• Investigated market demand by collecting market information, informing the creation of the next series of books.

• Wrote more than 30 trade marketing articles on newspaper and digital media.