{"product_id":"oleg-database-engineer","title":"Oleg — Ingegnere Database Skill AI","description":"\u003cdiv style=\"font-family: 'DM Sans', sans-serif; color: #1A1A18; max-width: 680px;\"\u003e\n\n  \u003cp style=\"font-size: 16px; font-weight: 600; color: #1A1A18; line-height: 1.5; margin: 0 0 8px 0;\"\u003e\n    Inserisci Oleg in Claude e ottieni un Senior Database Engineer che scrive SQL ottimizzato, progetta schemi che non si sgretolano su larga scala e spiega i piani di query così smetti di indovinare perché le cose sono lente.\n  \u003c\/p\u003e\n\n  \u003cp style=\"font-size: 13px; font-weight: 400; color: #555550; line-height: 1.7; margin: 0 0 28px 0;\"\u003e\n    Niente query black-box. Oleg legge l’output di EXPLAIN\/ANALYZE, individua gli indici mancanti, riscrive SQL generato da ORM che rallenta silenziosamente le prestazioni e gestisce migrazioni senza downtime che non ti svegliano alle 3 di notte. PostgreSQL, MySQL, MongoDB, Redis — tutto coperto in un unico file di competenze.\n  \u003c\/p\u003e\n\n  \u003cdiv style=\"background: #E6F1FB; border-radius: 12px; padding: 24px 28px; margin-bottom: 24px;\"\u003e\n    \u003cp style=\"font-size: 10px; font-weight: 600; color: #185FA5; letter-spacing: 0.08em; text-transform: uppercase; margin: 0 0 16px 0;\"\u003eCosa ottieni\u003c\/p\u003e\n    \u003cul style=\"margin: 0; padding: 0; list-style: none;\"\u003e\n      \u003cli style=\"font-size: 13px; color: #1A1A18; padding: 7px 0; border-bottom: 1px solid rgba(24,95,165,0.12); display: flex; align-items: flex-start; gap: 10px;\"\u003e\n        \u003cspan style=\"color: #185FA5; font-weight: 600; flex-shrink: 0;\"\u003e→\u003c\/span\u003e\n        \u003cspan\u003eProgettazione dello schema — schemi normalizzati in 3NF, strategie di denormalizzazione, modellazione OLTP vs OLAP, modelli gerarchici e progettazione documenti MongoDB\u003c\/span\u003e\n      \u003c\/li\u003e\n      \u003cli style=\"font-size: 13px; color: #1A1A18; padding: 7px 0; border-bottom: 1px solid rgba(24,95,165,0.12); display: flex; align-items: flex-start; gap: 10px;\"\u003e\n        \u003cspan style=\"color: #185FA5; font-weight: 600; flex-shrink: 0;\"\u003e→\u003c\/span\u003e\n        \u003cspan\u003ePadronanza di SQL — CTE, funzioni finestra, query ricorsive, join LATERAL, operatori JSONB, ricerca full-text, transazioni con livelli di isolamento adeguati\u003c\/span\u003e\n      \u003c\/li\u003e\n      \u003cli style=\"font-size: 13px; color: #1A1A18; padding: 7px 0; border-bottom: 1px solid rgba(24,95,165,0.12); display: flex; align-items: flex-start; gap: 10px;\"\u003e\n        \u003cspan style=\"color: #185FA5; font-weight: 600; flex-shrink: 0;\"\u003e→\u003c\/span\u003e\n        \u003cspan\u003eOttimizzazione delle query — interpretazione di EXPLAIN\/ANALYZE, strategie con B-tree, GIN, GiST, indici parziali e coprenti, rilevamento N+1, correzione SQL generato da ORM\u003c\/span\u003e\n      \u003c\/li\u003e\n      \u003cli style=\"font-size: 13px; color: #1A1A18; padding: 7px 0; border-bottom: 1px solid rgba(24,95,165,0.12); display: flex; align-items: flex-start; gap: 10px;\"\u003e\n        \u003cspan style=\"color: #185FA5; font-weight: 600; flex-shrink: 0;\"\u003e→\u003c\/span\u003e\n        \u003cspan\u003eMigrazioni senza downtime — modello espandi e contrai, DDL online, migrazioni dati batch con Prisma, Alembic, Flyway o SQL grezzo\u003c\/span\u003e\n      \u003c\/li\u003e\n      \u003cli style=\"font-size: 13px; color: #1A1A18; padding: 7px 0; border-bottom: 1px solid rgba(24,95,165,0.12); display: flex; align-items: flex-start; gap: 10px;\"\u003e\n        \u003cspan style=\"color: #185FA5; font-weight: 600; flex-shrink: 0;\"\u003e→\u003c\/span\u003e\n        \u003cspan\u003eRedis — modelli di caching (cache-aside, write-through, prevenzione stampede), pub\/sub, set ordinati, stream e configurazione di Redis Cluster\u003c\/span\u003e\n      \u003c\/li\u003e\n      \u003cli style=\"font-size: 13px; color: #1A1A18; padding: 7px 0; border-bottom: 1px solid rgba(24,95,165,0.12); display: flex; align-items: flex-start; gap: 10px;\"\u003e\n        \u003cspan style=\"color: #185FA5; font-weight: 600; flex-shrink: 0;\"\u003e→\u003c\/span\u003e\n        \u003cspan\u003eAffidabilità e operazioni — strategie di backup, replica in streaming, PgBouncer, logging delle query lente, allerta sul ritardo di replica e disaster recovery\u003c\/span\u003e\n      \u003c\/li\u003e\n      \u003cli style=\"font-size: 13px; color: #1A1A18; padding: 7px 0; display: flex; align-items: flex-start; gap: 10px;\"\u003e\n        \u003cspan style=\"color: #185FA5; font-weight: 600; flex-shrink: 0;\"\u003e→\u003c\/span\u003e\n        \u003cspan\u003eDatabase cloud — AWS RDS, Aurora, DynamoDB, ElastiCache, GCP Cloud SQL, BigQuery — dimensionamento, selezione dello storage e ottimizzazione dei costi\u003c\/span\u003e\n      \u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/div\u003e\n\n  \u003cdiv style=\"display: flex; align-items: center; gap: 20px; background: #FFFFFF; border: 1px solid #E8E6E0; border-radius: 8px; padding: 14px 20px; margin-bottom: 24px;\"\u003e\n    \u003cspan style=\"font-size: 11px; color: #888780; font-family: monospace;\"\u003e📄 claude-database-engineer.md\u003c\/span\u003e\n    \u003cdiv style=\"width: 1px; height: 16px; background: #E8E6E0;\"\u003e\u003c\/div\u003e\n    \u003cspan style=\"font-size: 11px; color: #888780;\"\u003eInstallazione in meno di 2 minuti\u003c\/span\u003e\n    \u003cdiv style=\"width: 1px; height: 16px; background: #E8E6E0;\"\u003e\u003c\/div\u003e\n    \u003cspan style=\"font-size: 11px; color: #888780;\"\u003eFunziona con Claude Sonnet 4 \u0026 Claude Code\u003c\/span\u003e\n  \u003c\/div\u003e\n\n  \u003cdiv style=\"border-left: 3px solid #185FA5; padding-left: 16px;\"\u003e\n    \u003cp style=\"font-size: 10px; font-weight: 600; color: #185FA5; letter-spacing: 0.08em; text-transform: uppercase; margin: 0 0 6px 0;\"\u003eCome installare\u003c\/p\u003e\n    \u003cp style=\"font-size: 12px; color: #555550; line-height: 1.7; margin: 0;\"\u003e\n      Scarica il file .md → apri Claude → incolla il contenuto del file nel prompt del sistema o nelle istruzioni del progetto → descrivi il problema dei tuoi dati → Claude lo progetta e lo ottimizza. Tutto qui.\n    \u003c\/p\u003e\n  \u003c\/div\u003e\n\n\u003c\/div\u003e","brand":"Kissmyskills","offers":[{"title":"Default Title","offer_id":56897443070216,"sku":null,"price":19.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1036\/1444\/7880\/files\/08_database-engineer.png?v=1776686525","url":"https:\/\/kissmyskills.com\/it\/products\/oleg-database-engineer","provider":"KissMySkills","version":"1.0","type":"link"}