Lightspeed DMS
Cloud-based software
SrDatabaseAdministrator
Neural analysis suggests this role is
optimal for Senior candidates.
“Sr Database Administrator at Lightspeed DMS. Skills: PostgreSQL administration, AWS RDS/Aurora, Performance tuning, Schema management. Establish standard configuration baselines. Drive consistency through automation”
What You'll Achieve.
Fleet runs to consistent standards; Fleet scales predictably; Fleet recovers cleanly; Support engineers shipping changes with confidence
Industry & Context.
Diagnose performance issues; Root cause analysis
What They're Looking For.
Must Have
5+ years PostgreSQL administration, 5+ years AWS RDS/Aurora PostgreSQL, Deep understanding of MVCC, Deep understanding of autovacuum, Deep understanding of bloat, Deep understanding of locking, Deep understanding of isolation levels, Deep understanding of transaction behavior, Proven experience diagnosing performance issues, Ability to read EXPLAIN plans, Experience implementing zero-downtime schema migration, Experience with backward-compatible deployment strategies, Written communication skills, Verbal communication skills
Nice to Have
Tuning Java/JVM applications, Reviewing ORM-generated SQL, Familiarity with Datadog DBM, Experience with Terraform, Managing RDS/Aurora resources, Familiarity with Kubernetes-hosted stacks, Connection pools at pod scale
What You'll Do.
Establish standard configuration baselines
Drive consistency through automation
Evaluate fleet health
Remediate systemic issues proactively
Define operational standards
Maintain operational standards
Develop database health scorecards
Forecast compute growth
Forecast storage growth
Evaluate scaling strategies
Provide cost/performance recommendations
Manage parameter groups
Manage engine settings
Manage autovacuum strategy
Diagnose slow queries
Diagnose high-cost queries
Tune high-cost queries
Detect N+1 query patterns
Remediate N+1 query patterns
Recommend schema changes
Guide use of PostgreSQL-native features
Embed with application teams
Evaluate database access patterns
Review ORM-generated SQL
Coach developers on efficient queries
Coach developers on index-friendly queries
Coach developers on ORM anti-patterns
Provide guidance on connection pool sizing
Provide guidance on transaction scope
Provide guidance on isolation levels
Provide guidance on concurrency tools
Author internal playbooks
Author query review checklists
Author reference patterns
Partner with Software Engineers on compatibility
Apply N-1 compatibility strategy
Use expand/migrate/contract sequences
Enable safe rolling deploys
Enable safe rollbacks
Establish safe migration workflow
Enforce safe migration workflow
Review schema changes
Validate schema changes in staging
Plan rollback for schema changes
Implement zero-downtime patterns
Guide minor version upgrades
Guide major version upgrades
Test extension compatibility
Plan regression testing
Define cutover strategy
Build Datadog dashboards
Build Datadog monitors
Build Datadog DBM views
Lead database incident response
Perform deep diagnostic analysis
Perform post-incident remediation
Define backup strategies
Validate backup strategies
Define point-in-time recovery strategies
Validate point-in-time recovery strategies
Define cross-region replication strategies
Validate cross-region replication strategies
Perform periodic DR exercises
Enforce least-privilege role design
Support audit requirements
Support SOC requirements
Support compliance requirements
Ensure fleet is secure by default
Implement appropriate access restrictions
Implement encryption at rest
Implement encryption in transit
How You'll Work.
Team & Collaboration
Partner with Software Engineers; Partner with Cloud Engineers; Embed with application teams; Partner with security team
Communication Scope
Explain database tradeoffs
Full Job Description
Company Overview: Lightspeed is the leading provider of cloud-based software for dealerships, serving the Powersport, Marine, RV, Trailer, and Golf Car industries adding hundreds of dealerships to the Lightspeed community each year. Lightspeed’s Dealer Management Solution (DMS) enables dealerships to optimize their end-to-end business operations, including Sales, Parts, Service, Rentals, Payments, Accounting, and Customer Relationship Management (CRM). When implemented into their daily operations, Lightspeed helps dealers increase their profitability by selling more units, service, and parts, all while creating a more streamlined experience for customers. Lightspeed is the most complete and integrated DMS in the industry with over 500 integrations with Original Equipment Manufacturers (OEMs), aftermarket parts and accessory distributors and dozens of other software tools that a dealership may use to run their business. Uniquely designed by dealers for dealers, and refined over the past 4 decades, Lightspeed empowers over 4,500+ dealers across North America with the tools and technology they need to manage their dealerships. Position Summary Lightspeed DMS is seeking a Senior PostgreSQL Database Administrator to own the fleet of database servers running on AWS (RDS and Aurora PostgreSQL): setting configuration baselines, defining operational standards, driving capacity and cost planning, and ensuring every database in the fleet is healthy, observable, and ready to scale with the business. This role has two primary areas of accountability. First, you will partner with Software Engineers on database schema, query tuning, and system‑wide best practices that shape how the application interacts with the database. Second, you will partner with Cloud Engineers on cost efficiency, capacity planning, fleet health, observability, and performance. Success looks like a fleet that runs to consistent standards, scales predictably, recovers cleanly, and supports engineers shipping
Applying for this Sr Database Administrator role?
Most applicants get filtered before a human reads their resume. See if yours makes the cut.
How to Apply on Greenhouse
- Create a Greenhouse profile before applying — it saves time across multiple applications.
- Upload your resume as a PDF; the parser handles it better than Word.
- Answer all knockout questions carefully — wrong answers auto-reject before a human sees you.
- Enable email notifications to track application status in real time.
ANONYMOUS · UNFILTERED
What do employees actually say about Lightspeed DMS?
Real rants from real employees. Read before you apply.