MySQL / MariaDB

Writes SQL queries: SELECT with JOIN, WHERE, GROUP BY, ORDER BY. Creates tables with correct data types and constraints. Understands foreign keys and indexes. Works with MySQL Workbench or equivalent.

Writes SELECT queries with JOINs and GROUP BY to pull reporting data from MySQL. Creates simple aggregation queries for dashboard metrics. Connects BI tools like Tableau or Power BI to MySQL data sources and builds basic visualizations from query results.

Extracts datasets from MySQL using filtered SELECT queries with WHERE, JOIN, and basic aggregation. Creates temporary tables to stage intermediate analysis results. Writes exploratory SQL queries to validate data quality and identify patterns in analytical workflows.

Performs basic MySQL operations: creating tables, writing SELECT/INSERT/UPDATE queries, working with mysql CLI. Understands data types, PRIMARY KEY, FOREIGN KEY. Can read EXPLAIN and find full table scans.

Designs normalized schemas for business domains. Optimizes queries via EXPLAIN and slow query log profiling. Uses MySQL specifics: partitioning, full-text search, JSON columns. Configures master-slave replication for read scaling.

Builds optimized reporting views and materialized summary tables in MySQL for BI dashboards. Tunes aggregation queries using composite indexes and query execution plans. Configures live and extract connections in Tableau and Power BI with proper MySQL driver settings for reliable scheduled refreshes.

Writes complex analytical SQL with window functions (ROW_NUMBER, LAG, LEAD, running totals) for trend and cohort analysis in MySQL. Builds multi-step analysis pipelines using CTEs and temporary tables. Optimizes data extraction queries by analyzing EXPLAIN output and adding targeted indexes for analytical workloads.

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.

Optimizes performance: partitioning, query optimizer hints, covering indexes. Configures master-slave replication. Analyzes slow query log. Designs schemas for high-write or high-read workloads.

Designs MySQL analytical layer architecture with pre-aggregated tables, partitioned fact tables, and star-schema views optimized for BI tool consumption. Implements row-level security patterns in MySQL that integrate with Tableau and Power BI access controls. Mentors team on writing performant analytical queries and proper use of query hints for reporting workloads.

Designs reusable analytical SQL frameworks with parameterized CTEs, recursive queries, and advanced window functions for complex statistical analysis in MySQL. Builds self-service data extraction layers with documented views and stored procedures that enable non-technical stakeholders. Optimizes MySQL for analytical workloads by configuring buffer pools, sort buffers, and temp table settings.

Designs MySQL architecture for high-load: InnoDB cluster, Group Replication, ProxySQL for connection pooling and read/write splitting. Performs online DDL, pt-online-schema-change. Configures PITR and automated failover.

Defines MySQL standards for the team: naming conventions, migration workflow, schema review. Makes decisions about sharding, read replicas for read-heavy workloads. Plans capacity.

Establishes organization-wide standards for MySQL analytical layer design including naming conventions, view hierarchies, and aggregation table refresh strategies. Coordinates cross-team BI connectivity architecture ensuring consistent Tableau and Power BI data source configurations. Evaluates MySQL vs MariaDB feature trade-offs for enterprise BI workloads and drives technology selection decisions.

Defines team standards for analytical SQL development in MySQL including query templates, CTE patterns, and temporary table lifecycle management. Mentors analysts on advanced window functions, query optimization techniques, and proper use of MySQL-specific features like generated columns. Coordinates with data engineering on MySQL schema evolution to support growing analytical requirements.

Defines organizational MySQL standards: versioning, configuration baselines, upgrade procedures. Coordinates zero-downtime major version migrations. Establishes MySQL infrastructure SLA and DR plans.

Defines organizational database strategy: MySQL vs alternatives for different services. Designs data platform: replication, backup, disaster recovery, multi-region. Evaluates managed vs self-hosted.

Defines enterprise data platform strategy positioning MySQL within the broader analytical ecosystem alongside data warehouses and lakehouse solutions. Architects multi-region MySQL deployments for global BI reporting with sub-second query latency requirements. Drives innovation in real-time BI by leveraging MySQL change data capture and streaming integration with modern BI platforms.

Defines enterprise analytical SQL standards and MySQL best practices that scale across multiple data analyst teams. Architects analytical data layers in MySQL that balance query performance with storage efficiency for petabyte-scale datasets. Drives adoption of MySQL 8+ analytical features including recursive CTEs, lateral joins, and JSON table functions to modernize organization-wide analysis capabilities.

Shapes company-wide MySQL strategy: MySQL vs Aurora vs Vitess for different workloads, multi-region replication standards, cost optimization. Defines MySQL platform development roadmap and evaluates alternative solutions.