Lightspeed DMS

Lightspeed DMS

Lightspeed DMS, based in Salt Lake City, Utah, specializes in dealership management software solutions for the Powersports, Marine, and RV industries. Their flagship product, Lightspeed®EVO, is the #1 DMS in the Recreation industry, offering a unified ...

Automotive
51-250

Description

  • Own the AWS RDS and Aurora PostgreSQL database fleet and set configuration baselines and operational standards.
  • Monitor fleet health, including replication, failover readiness, storage growth, bloat, and scalability.
  • Forecast compute, storage, and I/O growth and recommend cost and performance improvements to leadership.
  • Tune slow or high-cost queries using PostgreSQL performance tools and database diagnostics.
  • Work with engineers to identify and fix N+1 and other application-driven query patterns.
  • Review and improve index strategy, schema design, and PostgreSQL-native feature usage based on workload needs.
  • Partner with software engineers during design and code review to evaluate database access patterns before release.
  • Support safe schema and data change workflows, including zero-downtime migration and rollback planning.
  • Lead database-related incident response, post-incident remediation, and disaster recovery exercises.
  • Build observability dashboards, scorecards, and monitors for latency, locks, replication lag, and connection saturation.
  • Enforce least-privilege access, secure database configurations, and compliance logging and retention requirements.

Requirements

  • 5+ years of hands-on PostgreSQL administration experience in production environments.
  • Strong experience with AWS RDS and/or Aurora PostgreSQL, including parameter groups, snapshots, read replicas, and failover behavior.
  • Deep understanding of MVCC, autovacuum, bloat, locking, isolation levels, and PostgreSQL transaction behavior.
  • Proven experience diagnosing application-driven performance issues in high-scale production environments.
  • Ability to read EXPLAIN plans and translate analysis into query, index, or schema changes.
  • Experience implementing zero-downtime schema migrations and backward-compatible deployment strategies.
  • Strong written and verbal communication skills for technical and non-technical audiences.
  • Experience tuning Java/JVM applications and reviewing ORM-generated SQL such as Hibernate, JPA, or MyBatis is preferred.
  • Familiarity with Datadog Database Monitoring or similar APM-to-database correlation tooling is preferred.
  • Experience with Terraform or other IaC tools managing RDS/Aurora resources and parameter groups is preferred.
  • Familiarity with Kubernetes-hosted application stacks and connection pool behavior at pod scale is preferred.
  • Applicants must be authorized to work in the U.S.

Benefits

  • The posting does not list compensation details.
  • The posting does not list health insurance or PTO details.
  • Opportunities to work on a mission-critical platform supporting thousands of dealerships across North America.
  • A role with broad ownership across fleet operations, performance, reliability, and security.
  • The chance to influence database standards, tooling, and engineering practices across the organization.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Sample Management Specialist

Precision For Medicine 1K-5K Pharmaceuticals

The Specialist, Sample Management at Precision Medicine Group supports sample management operations across data operations and biorepository workflows, with a focus on discrepancy resolution, quality control, and study-level database support.

HIPAA
1 hour ago

OIC Oracle Developer - LATAM remote

Workstate 51-250 Internet Software & Services

Workstate is hiring a remote-friendly ET OIC Oracle Developer to support enterprise integrations across Oracle Cloud platforms for Oracle Fusion Financials, Oracle HCM Cloud, Oracle Integration Cloud, Oracle Autonomous Transaction Processing, and connected systems.

JSON REST API SOAP SQL XML
1 hour, 15 minutes ago

Remote Database Administrator Cloud

MariaDB.org 11-50 Internet Software & Services

MariaDB is hiring a Remote DBA for its SkySQL cloud platform to support customers worldwide by managing, monitoring, and improving MariaDB database environments.

Bash Docker Go Kubernetes Linux MariaDB MongoDB MySQL Oracle PostgreSQL Python SQL SQL Server SSH
1 hour, 15 minutes ago

Remote Database Administrator Cloud

MariaDB.org 11-50 Internet Software & Services

MariaDB is hiring a Remote DBA for its SkySQL cloud platform to support customers worldwide by managing database operations, troubleshooting issues, and improving performance and reliability.

Bash Docker Go Kubernetes Linux MariaDB MongoDB MySQL Oracle PostgreSQL Python SQL SQL Server SSH
1 hour, 15 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers