Results for “pe”

Diagnoses and resolves slow Qdrant search performance issues including high latency, low throughput, and slow filtered searches.

Provides guidance for Oracle Database administration, SQL and PL/SQL development, performance tuning, security, ORDS, SQLcl, migrations, frameworks, and agent-safe database workflows.

Optimize SQL queries, design database schemas, and tune performance across cloud-native and hybrid OLTP/OLAP environments.

Provides expert guidance on modern SQL, cloud-native databases, and query optimization, covering performance tuning, data modeling, and hybrid analytical systems.

Optimize SQL queries, indexes, and database performance across MySQL, PostgreSQL, SQL Server, and Oracle with execution plan analysis and universal tuning techniques.

Provides expert guidance on modern SQL, cloud-native databases, query optimization, performance tuning, and data modeling for OLTP/OLAP workloads.

Optimize PostgreSQL databases with advanced features, performance tuning, and best practices for JSONB, full-text search, window functions, and indexing.

Diagnoses and resolves slow Qdrant indexing and data ingestion by optimizing batching, sharding, HNSW parameters, and payload indexing strategies.

Optimizes database queries and improves performance across PostgreSQL and MySQL systems by analyzing execution plans, designing index strategies, and tuning configurations.

Guides scaling Qdrant query throughput (QPS) through performance tuning, horizontal scaling with read replicas, and disk I/O optimization.

Provides expert guidance on modern SQL, cloud-native databases, and query optimization, covering performance tuning, data modeling, and hybrid analytical systems.

Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems.

Manages and analyzes Azure SQL databases via Azure CLI, covering DTU/vCore performance, elastic pools, geo-replication, and health monitoring.

Expert guidance for architecting, developing, and operating SurrealDB 3, covering SurrealQL, multi-model data modeling, vector search, security, deployment, performance tuning, SDK integration, and ecosystem tools.

Perform high-performance genomic interval operations and bioinformatics file I/O on Polars DataFrames, including overlap, nearest, merge, coverage, complement, subtract, and reading/writing BED, VCF, BAM, GFF, FASTA, and FASTQ formats with streaming and cloud-native support.

Guides configuring connection pooling for Postgres to prevent connection exhaustion under load.

Analyze proteomics and metabolomics mass spectrometry data with PyOpenMS: read/write MS file formats, process spectra, detect and quantify features, identify peptides and proteins, and run end-to-end LC-MS/MS pipelines using ready-to-run scripts.

Installs the Snowflake Connector for Python and builds a wheel package using PEP-517.

Manage AWS RDS relational databases: provision instances, configure backups, manage replicas, troubleshoot connectivity, and optimize performance.

Write, review, debug, test, and optimize Python Polars code with version-grounded object types, schemas, and execution boundaries.

Run SQL queries and psql meta-commands against PostgreSQL databases via the psql CLI, with options for file execution, tuples-only output, and timeouts.

Provision Bigtable instances, design performant schemas, and query data using gcloud, cbt, or client libraries.

Creates executable Polars dataframe contracts using Pandera's Polars backend for runtime validation of schemas, columns, and checks.

Guides database index selection, creation, and maintenance with SQL examples for PostgreSQL and MySQL.

Design PostgreSQL schemas with best practices for data types, indexing, constraints, and performance patterns.

Guides optimization of Qdrant query latency by tuning segments, memory, quantization, and search parameters.

Provides ClickHouse schema design, query optimization, and data ingestion patterns for high-performance analytical workloads.

Performs astronomical data analysis with astropy: coordinate transformations, unit conversions, FITS file handling, cosmological calculations, time systems, tables, and WCS.

Manage datasets, tables, and jobs in BigQuery. Run SQL queries, manage BigQuery resources, and perform basic data ingestion and analysis.

Design DynamoDB table schemas, write queries, configure indexes, manage capacity, and troubleshoot performance issues using AWS CLI and boto3 examples.