All technologies

Advanced

PostgreSQL / MySQL / Redis

Schema design, query tuning, and row-level security across PostgreSQL, MySQL, MSSQL, Oracle, and Redis.

6+ yrs
PostgreSQL / MySQL / Redis

Proficiency

6+yrs

ProficientAdvancedExpert

Major concepts

01Query optimisation

Reading plans, fixing N+1s, and indexing to predicate shape — the work that took a slow product's response times down 30%.

02Row-level security

PostgreSQL RLS enforcing access rules at the database level, so an HR platform's salary and personal data stay scoped no matter what the app layer does.

03Multi-engine fluency

MySQL and PostgreSQL day to day, MSSQL on Windows/IIS banking stacks, and Oracle where the enterprise required it.

04Caching with Redis

Redis for sessions, caching, rate-limiting, and queue backends — turning expensive reads and async work into cheap, reliable operations.

Advantages · 04

Core advantages

  • PostgreSQL's RLS pushes authorization down to the safest possible layer
  • Redis absorbs traffic spikes and offloads the database for free
  • Relational integrity and constraints are documentation that can't go stale
  • Boring, proven engines with well-understood failure modes

Highlights · 04

Work highlights

  • Designed PostgreSQL RLS for an employee-management platform's sensitive data
  • Cut response times 30% by optimising queries and adding the right indexes
  • Ran MSSQL on a Windows/IIS corporate banking stack with REST APIs and SFTP
  • Used Redis for caching, sessions, and queued email across multiple apps

Skills · 06

Competencies

  • PostgreSQL & RLS
  • MySQL / MSSQL / Oracle
  • Query plan analysis
  • Indexing & schema design
  • Redis caching & queues
  • Data migration

Projects · 06

Used in projects