Parcourir les catégories
Explorer
Fiverr Pro
Français
$
USD
I will review and improve your database performance
Database Engineer, Delphi Programmer
• 25 years of experience in the field of database engineering and optimization
• Oracle, Postgres and MySQL/MariaDB
• DB developer + DBA
• DB installations and upgrades (Win, AWS, Supabase, Linux)
• D...
À propos de ce service
i. Connecting to your DB
ii. Inspecting the structure (number of tables, views, triggers and stored procedures)
a) Monitoring processes and sessions
b) Gathering various stats from your database
c) Building list of anomalies detected
d) Gathering query stats
- Saving the "before" stats and numbers
- Planning and suggesting improvement proposal
- Client demo on DEV env.
- Deploying the improvement solution
- Saving the "after" stats and numbers
Documenting all details of work completed
Plateforme:
mariadb
•
mySQL
•
Oracle
•
PL/SQL
•
PostgreSQL
FAQ
What type of databases do you support ?
Oracle, PostgreSQL, MySQL/MariaDB.
Do you need data in tables ?
Real data is welcomed but not necessary. I dont expect I'll be given the R/W access to PROD right away. What I will need is an estimate of your PROD table row counts and sizes and ideally the schema DDLs.
I dont want to do anything on my PROD database before I see some results first, how do you make this happen ?
Dont worry, if you send me your schema DDLs, I can create an empty database structure on your DEV env. (or even my own local) and populate it with dummy data to make it as realistic as possible. I can demo my solution on DEV first.
