Skills

Designs and optimizes database schemas, queries, and performance across PostgreSQL, MongoDB, and Redis with expert precision.

Implements a lightweight, in-memory database with basic CRUD operations and support for JSON-based data storage and retrieval.

Assists developers in seamlessly migrating database schemas, transforming data structures, and handling complex database transition processes across different database systems.

Assists developers in automating database schema migrations, generating migration scripts, and managing database version control across different database systems.

Optimizes database performance by analyzing query patterns, indexing strategies, and resource utilization for improved efficiency.

Validates and enforces safety constraints for database operations to prevent harmful queries and unauthorized data access.

Designs optimal database schemas by creating ER diagrams, applying normalization, generating DDL, and optimizing performance across various database technologies.

Automates database testing by generating test cases, writing SQL queries, and validating database schema and query performance.

Automates Databricks workspace configuration, managing clusters, secrets, and infrastructure-as-code for consistent and reproducible data environments.

Extracts and analyzes AI/LLM visibility metrics, brand mentions, and response signals using the DataForSEO AI Optimization API.

Performs SEO research by retrieving competitive insights, keyword ideas, and market analysis using DataForSEO Labs API endpoints.

Performs comprehensive website crawling and technical SEO audits using DataForSEO OnPage API, identifying performance, indexing, and structural issues.