SQL Database Records Updating

I maintain an SQL-based system that receives new records every week, and I need those incoming values inserted, amended, or deleted accurately in the live tables. The work is pure data entry—no query design or analytics—just ensuring that the data I provide in CSV format is reflected exactly in the SQL database.

You will connect through a secure VPN to a MySQL instance (PostgreSQL skills are equally welcome; the syntax is nearly identical for the commands you’ll run). The job involves:

• Importing each CSV file to a temporary table.
• Running the supplied UPDATE, INSERT, and DELETE statements or executing them manually if needed.
• Verifying row counts against the source file to confirm nothing is missed.
• Sending me a quick confirmation log once the session is finished.

Acceptance criteria
1. All rows from the source file appear in the correct production tables.
2. No duplicate primary keys or foreign-key violations.
3. Confirmation log shows start/finish time and affected row counts.

I provide clear CSVs, credentials, and a short SQL script outline; you provide accuracy and a fast turnaround.