Document database schemas, ERD diagrams, table relationships, indexes, and constraints. Use when documenting...
Data & Analytics
Data processing, analysis, visualization, and ML pipelines
623 Skills
Design database schemas with normalization, relationships, and constraints. Use when creating new database schemas,...
Improve database query performance through indexing, query optimization, and execution plan analysis. Reduce...
Monitor database performance and health. Use when setting up monitoring, analyzing metrics, or troubleshooting...
Manage database migrations and schema versioning. Use when planning migrations, version control, rollback...
Design and implement database indexing strategies. Use when creating indexes, choosing index types, or optimizing...
Implement backup and restore strategies for disaster recovery. Use when creating backup plans, testing restore...
Create effective visualizations using matplotlib and seaborn for exploratory analysis, presenting insights, and...
Set up database replication for high availability and disaster recovery. Use when configuring master-slave...
Create safe, reversible database migration scripts with rollback capabilities, data validation, and zero-downtime...
Implement strong encryption using AES, RSA, TLS, and proper key management. Use when securing data at rest, in...
Plan and execute cloud migrations with assessment, database migration, application refactoring, and cutover...
Implement efficient caching strategies using Redis, Memcached, CDN, and cache invalidation patterns. Use when...
Implement backup strategies, disaster recovery plans, and data restoration procedures for protecting critical...
Deploy and manage relational databases using RDS with Multi-AZ, read replicas, backups, and encryption. Use for...
Implement efficient pagination strategies for large datasets using offset/limit, cursor-based, and keyset...
Implement advanced filtering and sorting capabilities for APIs with query parsing, field validation, and...
Expert in automating Excel workflows using Node.js (ExcelJS, SheetJS) and Python (pandas, openpyxl).
Use when user needs SQL development, database design, query optimization, performance tuning, or database...
Expert in quantitative finance, algorithmic trading, and financial data analysis using Python (Pandas/NumPy),...
Use when user needs PostgreSQL database administration, performance optimization, high availability setup,...
Expert in Apache Kafka, Event Streaming, and Real-time Data Pipelines. Specializes in Kafka Connect, KSQL, and...
Use when user needs database query optimization, performance tuning, index strategies, execution plan analysis, or...
Senior Database Administrator with expertise in PostgreSQL, MySQL, MongoDB, and enterprise database systems....