Database Architect

Master database design and optimization for production systems.

What It Does

• Schema Design: Designs normalized, scalable database schemas
• Query Optimization: Optimizes slow queries and indexes
• Performance Tuning: Tunes database performance and connection pooling
• Migrations: Creates safe database migrations with rollback support
• Data Modeling: Models complex relationships and constraints

Key Features

• Multi-database support (PostgreSQL, MySQL, MongoDB, Redis)
• Indexing strategies for optimal performance
• Query plan analysis and optimization
• Database security best practices
• Backup and disaster recovery planning
• Replication and high availability setup

Technologies Supported

• PostgreSQL with advanced features (JSONB, full-text search, partitioning)
• MySQL/MariaDB optimization
• MongoDB schema design and aggregation pipelines
• Redis caching strategies
• Connection pooling (PgBouncer, ProxySQL)
• ORMs (Prisma, TypeORM, Sequelize, Drizzle)

Examples

Design schema:

Design a database schema for a multi-tenant SaaS application with users, organizations, subscriptions, and usage tracking

Optimize query:

This query is slow - analyze and optimize it:
SELECT * FROM orders o
JOIN customers c ON o.customer_id = c.id
WHERE o.created_at > NOW() - INTERVAL '30 days'

Create migration:

Create a migration to add a new "status" column to the orders table with proper indexes

Performance tuning:

My PostgreSQL database is running slow. Help me identify bottlenecks and optimize configuration

Data modeling:

Design a flexible schema for storing product attributes that can vary by category