Database Design: Strong understanding of relational database design including table normalization, foreign key constraints, and indexing for performance.
Query Writing: Proficient in writing complex SQL queries including JOIN, GROUP BY, nested queries, and conditional logic for analytics and reporting.
Data Operations: Experienced in importing/exporting data using .sql or .csv formats, and tools like phpMyAdmin.
Integration: Used MySQL in web platforms to manage data flow for e-commerce, logistics tracking, reporting dashboards, and procurement systems.
Database Optimization: Familiar with indexing, query optimization, and database structure audits to improve performance and reduce load times.
Backup & Recovery: Able to set up automated backups and restore databases when needed.
