Contact person: Laravel + Google Cloud MySQL Developer Needed – Build Backup/Restore & Bulk Delete Feature (Google Certified preferred)

Phone:Show

Email:Show

Location: Way, United States

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"Overview:
Looking for a Laravel 10 / PHP 8 developer with experience in Google Cloud SQL (MySQL) and Google App Engine to build a Bulk Delete with Backup/Restore feature for our admin panel. The feature must include full database backup to Google Cloud Storage, a safe restore option (15-day window), progress/status messages, and automatic cleanup of old backups. Google Cloud Certified developers preferred.

Required Skills:
- Laravel 10 / PHP 8
- MySQL 8 (with experience handling large datasets)
- Google Cloud SQL (MySQL)
- Google App Engine / Compute Instance deployment
- Google Cloud Storage integration
- Familiarity with building REST API endpoints in Laravel (for status updates, trigger delete/restore jobs).

Deliverables:
- Clean, tested Laravel 10 (PHP 8) code integrated into the admin panel.
- MySQL operations optimized for large datasets (chunk deletes, indexes).
- Google Cloud Storage integration for backup/restore.
- UI components for status bar, progress messages, and confirmation flows.

1. Bulk Delete Function o:
- All reading data is stored in one large database table shared by all groups.
-The delete operation must target only records matching all of the following in table: The selected group/property,, date range filter, and specific record status (e.g., Pending or Approved).
- **Other records in the table must remain untouched **
- Include a dry-run option to preview how many records will be deleted and display list.

2. Full Backup Before Delete:
- Before deletion, generate a full backup of the all database tables.
- Store backup in Google Cloud Storage, tagged with timestamp and reference ID (user entered)
- Show progress messages during the process

3. Restore from Backup :
- Add a Restore button for the backup created at the start of the delete job. Available for 15 days after creation, then auto-hidden.
- Restore process: pause writes, restore, refresh summaries, log result.
- Progress messages: Restoring Records → Refreshing Summaries → Restore Completed/Failed.

4. Automatic Cleanup of Old Backups: When the Bulk Delete feature is accessed, the system should automatically:
- Identify backups older than 15 days. Delete those files from Google Cloud Storage.


*** Preferred Qualifications: Google Cloud Certified Developer **" (client-provided description)