Resolving Complex Database Issues

Leland Rogers

Senior Technical Support Engineer @ SingleStore

I specialize in helping customers solve highly technical problems across the entire stack. I am highly adaptable—whether I'm reading Go code to uncover a root cause, researching complex enterprise integrations, or working directly with customers to provide thorough support and guidance.

My engineering approach is holistic: I'm just as comfortable tuning bare-metal Linux hardware and debugging intricate pipeline logs as I am architecting cloud-native Kubernetes deployments and building modern web interfaces.

Core Engineering & Support

Distributed Databases

Expertise in SingleStore (MySQL-compliant) alongside deep relational database knowledge (MySQL, PostgreSQL). I drive resolution for mission-critical database issues by analyzing query execution plans, profiling SQL performance, and troubleshooting data skew and memory bottlenecks.

SingleStore MySQL / Postgres Query Profiling

Kubernetes & Cloud Infra

Deep experience managing stateful workloads using various Kubernetes Operators. I troubleshoot complex deployments across managed cloud environments (AKS, EKS, GCP) and configure external data pipelines and ETL integrations utilizing AWS S3 and Apache Spark.

K8s Operators AKS / EKS / GCP S3 & Spark

Enterprise Security & Auth

Architecting and troubleshooting secure access protocols within enterprise infrastructure. Deep knowledge of directory services, isolating complex LDAP filter synchronization issues, managing strict RBAC policies, and resolving Kerberos auth failures.

LDAP / AD RBAC Kerberos

Linux Systems & Performance

Deep expertise across various Linux distributions and bare-metal environments. Comfortable diving into source code to uncover root causes, analyzing logs for OoM and connection errors, and tuning advanced CPU schedulers for performance optimization.

Cross-Distro Linux Log Analysis Hardware Tuning

Full Stack Web Development

Modern Frontend & Tooling

Outside of my backend systems work, I have a passion for frontend development. I learned React and Redux to build out personal web applications, which is supported by a strong foundation in core web technologies and scripting languages.

React.js & Redux
HTML, CSS & LESS
JavaScript (ES6+)
Responsive UI

Technologies & Toolkit

Linux & Systems Architecture

Linux (Cross-Distro) Bash Scripting Kernel Scheduling Docker Hardware Tuning Pipeline Analysis

Languages & Frontend

Go Python C JavaScript (ES6+) React.js & Redux HTML/CSS

Databases & Data

SingleStore MySQL PostgreSQL Apache Spark Query Optimization SQL Profiling

Cloud, Security & DevOps

Kubernetes K8s Operators AWS / Azure / GCP LDAP & Active Directory Kerberos / RBAC CI/CD Pipelines