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

Ssr DevOps Engineer (Brazil-based professionals)

Workana 1K-5K Internet Software & Services

Engenheiro/a DevOps Pleno na Workana para atuar na sustentação de uma infraestrutura Linux e em nuvem de missão crítica para um cliente do setor de segurança eletrônica e monitoramento.

Ansible Apache AWS Docker EC2 Linux MongoDB MQTT MySQL Nginx RabbitMQ Redis Ubuntu Zabbix
1 hour, 42 minutes ago

Junior Database Administrator - Fuze Services

Fuze Health Health Care Providers & Services

Fuze Health is hiring a Junior Database Administrator to support its global Technology Platform team in maintaining and improving cloud-based production database environments across the EU and US.

AWS Datadog GitHub Actions HIPAA PowerShell Python SQL Server Terraform
6 hours, 20 minutes ago

Senior Microsoft Windows SQL Server DBA

PartnerOne 51-250 Media

Senior Microsoft Windows SQL Server DBA role at a large enterprise, responsible for owning mission-critical database environments and improving application performance across production and disaster recovery systems.

Active Directory Encryption New Relic PowerShell SQL Server Windows Server
6 hours, 46 minutes ago

Yardi Database Analyst

Assistantly 51-250 Professional Services

Assistantly is seeking a Yardi Database Analyst to support growth-stage clients by improving data integrity, reporting, and operational decision-making through embedded work with database and leadership teams.

Power BI SQL
16 hours, 44 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