Designs table schemas balancing partition size and read performance in Cassandra. Configures compaction strategies and manages tombstone accumulation. Monitors cluster metrics and resolves hotspot and latency issues.

Documents database architecture: ER diagrams, table and relationship descriptions, data flow diagrams. Maintains documentation for database configurations, backup procedures, connection details per environment.

Designs comprehensive backup strategies combining full, incremental, and continuous archiving (WAL, binlog). Implements automated backup verification with restore testing. Configures cross-region replication for disaster recovery. Optimizes backup performance and storage costs.

Independently designs database benchmark suites simulating real-world workload patterns. Configures TPC-C, TPC-H, and custom benchmarks for capacity planning. Analyzes benchmark results to identify bottlenecks in query execution, I/O subsystem, and connection pooling configurations.

Monitors database resource utilization: disk space trends, connection count, memory usage. Creates forecasting based on current data growth. Plans storage expansion and instance upgrades.

Administers ClickHouse: configuring MergeTree partitioning, TTL for retention, materialized views for aggregation. Optimizes queries via EXPLAIN PIPELINE. Configures system table monitoring.

Independently designs schemas and optimizes queries with CockroachDB. Understands indexing and query execution plans. Uses ORM effectively.

Tunes buffer pool size, connection pool parameters, and write-ahead log configuration for production workloads. Performs detailed query plan analysis to eliminate inefficient joins, sequential scans, and suboptimal index usage. Configures automated vacuum schedules and analyzes replication lag to ensure read replicas stay within acceptable thresholds for application SLAs.

Participates in DR processes: performs backup verification, tests restore procedures per runbooks. Configures automated snapshots and cross-region backup copying. Monitors replication lag and backup status.

Independently designs schemas and optimizes queries with DynamoDB. Understands indexing and query execution plans. Uses ORM effectively.

Designs CI/CD pipelines from scratch. Configures caching for faster builds. Uses matrix builds for testing across different versions. Sets up deployment pipelines (staging → production). Works with secrets and environment variables.

Independently profiles database I/O patterns using pg_stat_io, dm_io_virtual_file_stats, or innodb_metrics. Correlates disk throughput and IOPS with query execution plans. Optimizes tablespace placement, WAL configuration, and buffer pool sizing to reduce I/O bottlenecks in OLTP and OLAP workloads.

Independently designs MongoDB schemas optimized for application query patterns and data access. Understands aggregation pipelines, index strategies, and query execution plans using explain output. Configures replica sets, manages user roles, and performs capacity planning for growing datasets.

Administers MySQL in production: configuring innodb_buffer_pool_size, query cache, slow query log. Works with master-slave replication, configures monitoring via Performance Schema. Optimizes queries through profiling.

Independently designs schemas and optimizes queries with Neo4j. Understands indexing and query execution plans. Uses ORM effectively.

Independently designs schemas and optimizes queries with Vitess. Understands indexing and query execution plans. Uses ORM effectively.

Configures custom database health metrics including slow query rates, index efficiency, and storage growth trends. Creates Grafana dashboards with alerts for replication lag and deadlock frequency. Participates in on-call rotation.

Configures and manages database replication topologies: primary-replica, multi-source, and cascading replication. Optimizes replication performance through parallel apply, filtering, and conflict resolution. Implements automated failover with tools like Patroni, Orchestrator, or native HA solutions.

Independently manages transaction behavior across database systems, tuning isolation levels for specific workload patterns. Diagnoses and resolves deadlocks using execution plans and lock monitoring tools. Implements advisory locks, two-phase commits, and transaction log management for high-throughput environments.