Back to jobs

Senior Database Administrator

Pay
Pay not listed
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting

This role has two primary areas of accountability.

  • Set configuration baselines and standards across RDS and Aurora databases

  • Identify and tune slow or high-cost queries and indexes

  • Forecast compute, storage, and I/O growth and recommend scaling and cost options

  • Review ORM-generated SQL and coach developers on efficient database access

  • Lead database incident response and plan backup and disaster recovery

From the employer’s posting
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 database changes with confidence.
Establish standard configuration baselines across RDS and Aurora environments
Identify, diagnose, and tune slow or high-cost queries using EXPLAIN (ANALYZE, BUFFERS)
Forecast compute, storage, and I/O growth trends across the fleet.
Review ORM-generated SQL (Hibernate, JPA, etc.) and coach developers on writing efficient, index-friendly queries
Lead database-related incident response

Before you apply

Work authorization
Must already have the right to work in the USApplicants must be authorized to work in the US

What you’ll bring

All qualifications

Core experience

  • 5+ years of hands-on PostgreSQL administration in production

Preferred experience

  • Experience tuning Java/JVM applications and reviewing ORM-generated SQL (Hibernate, JPA, MyBatis).
  • Familiarity with Datadog Database Monitoring (DBM) or comparable APM-to-database correlation tooling.
  • Experience with Terraform or other IaC tools managing RDS/Aurora resources and parameter groups.
  • Familiarity with Kubernetes-hosted application stacks (WildFly, Spring, etc.) and how connection pools behave at pod scale.
Qualification wording
5+ years of hands-on PostgreSQL administration experience in production environments.
Experience tuning Java/JVM applications and reviewing ORM-generated SQL (Hibernate, JPA, MyBatis).
Familiarity with Datadog Database Monitoring (DBM) or comparable APM-to-database correlation tooling.
Experience with Terraform or other IaC tools managing RDS/Aurora resources and parameter groups.
Familiarity with Kubernetes-hosted application stacks (WildFly, Spring, etc.) and how connection pools behave at pod scale.
Apply at Lightspeed DMS

Posting record

Report an error

Open 5 monthsWe first saw this posting 170 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
Jun 5, 2026170 days ago
Recorded sightings
70
Last seen by us
Nov 21, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 170

Up longer than most. Similar jobs usually come down between day 6 and day 56.

From 14,771 similar postings that came down. Coming down is not always a hire.

Lightspeed DMS is hiring

1 open job

  • No new data jobs since August
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Java
  • SQL
  • AWS
  • Datadog
  • Kubernetes
  • PostgreSQL
  • Terraform
Where the posting names them
Preferred Qualifications: - Experience tuning Java/JVM applications and reviewing ORM-generated SQL (Hibernate, JPA, MyBatis). - Familiarity with Datadog Database Monitoring (DBM) or comparable APM-to-database correlation tooling.
- Embed with application teams during design and code review to evaluate database access patterns before they ship. - Review ORM-generated SQL (Hibernate, JPA, etc.) and coach developers on writing efficient, index-friendly queries and avoiding common ORM anti-patterns. - Provide guidance on connection pool sizing, transaction scope, isolation levels, and PostgreSQL-specific concurrency tools (advisory locks, SKIP LOCKED).
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 database changes with confidence.
- 5+ years of hands-on PostgreSQL administration experience in production environments. - Strong working 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 transaction behavior in PostgreSQL.
- Guide minor and major version upgrades on RDS and Aurora, including extension compatibility, plan regression testing, and cutover strategy. - Build and refine Datadog dashboards, monitors, and DBM views covering query latency, lock waits, replication lag, and connection saturation. - Lead database-related incident response: deep diagnostic analysis (lock chains, long-running transactions, replication issues) and post-incident remediation.
- Experience tuning Java/JVM applications and reviewing ORM-generated SQL (Hibernate, JPA, MyBatis). - Familiarity with Datadog Database Monitoring (DBM) or comparable APM-to-database correlation tooling. - Experience with Terraform or other IaC tools managing RDS/Aurora resources and parameter groups.
- Experience with Terraform or other IaC tools managing RDS/Aurora resources and parameter groups. - Familiarity with Kubernetes-hosted application stacks (WildFly, Spring, etc.) and how connection pools behave at pod scale. Inclusion and Diversity at Lightspeed:
- Recommend schema changes — normalization, denormalization, partitioning, and table restructuring — driven by measured workload, not theory. - Guide use of PostgreSQL-native features where they fit: JSONB, full-text search, materialized views, generated columns, and relevant extensions. Application & Developer Partnership
- Review ORM-generated SQL (Hibernate, JPA, etc.) and coach developers on writing efficient, index-friendly queries and avoiding common ORM anti-patterns. - Provide guidance on connection pool sizing, transaction scope, isolation levels, and PostgreSQL-specific concurrency tools (advisory locks, SKIP LOCKED). - Author internal playbooks, query review checklists, and reference patterns so good database practices scale across engineering.
Required Qualifications: - 5+ years of hands-on PostgreSQL administration experience in production environments. - Strong working experience with AWS RDS and/or Aurora PostgreSQL, including parameter groups, snapshots, read replicas, and failover behavior.
- Strong working 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 transaction behavior in PostgreSQL. - Proven experience diagnosing application-driven performance issues in high-scale production environments.
- Familiarity with Datadog Database Monitoring (DBM) or comparable APM-to-database correlation tooling. - Experience with Terraform or other IaC tools managing RDS/Aurora resources and parameter groups. - Familiarity with Kubernetes-hosted application stacks (WildFly, Spring, etc.) and how connection pools behave at pod scale.

Your next step

Complete your application on job-boards.greenhouse.io. The employer’s form will show what is required.

Applying through Greenhouse

  • No account needed: the form is one page, with an “Autofill my application” option that reads your resume.
  • Greenhouse doesn’t read resumes over 2.5 MB, or details placed in a header, footer, text box, table or second column. The file still attaches, but a recruiter has to type you in by hand.

Already applied? Track this application

Job description

View original posting ↗

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 database changes with confidence.

Key Responsibilities

Fleet Operations, Health & Capacity

  • Establish standard configuration baselines across RDS and Aurora environments, and drive consistency through automation and Infrastructure as Code.
  • Continuously evaluate fleet health — replication, failover readiness, storage growth, and bloat — and remediate systemic issues proactively.
  • Define and maintain operational standards for observability, backup validation, maintenance windows, upgrades, and disaster recovery.
  • Develop database health scorecards and KPIs covering latency, saturation, replication health, cache efficiency, and resource utilization.
  • Forecast compute, storage, and I/O growth trends across the fleet.
  • Evaluate scaling strategies — instance sizing, storage type, read replica topology, RDS vs. Aurora — and provide cost/performance recommendations to leadership.
  • Manage parameter groups, engine settings, and autovacuum strategy tuned to actual workload.

Query & Schema Performance

  • Identify, diagnose, and tune slow or high-cost queries using EXPLAIN (ANALYZE, BUFFERS), pg_stat_statements, auto_explain, and Performance Insights.
  • Detect and remediate N+1 and other application-driven query patterns in collaboration with engineers.
  • Tune index strategy — create, consolidate, or drop indexes based on workload analysis and bloat.
  • Recommend schema changes — normalization, denormalization, partitioning, and table restructuring — driven by measured workload, not theory.
  • Guide use of PostgreSQL-native features where they fit: JSONB, full-text search, materialized views, generated columns, and relevant extensions.

Application & Developer Partnership

  • Embed with application teams during design and code review to evaluate database access patterns before they ship.
  • Review ORM-generated SQL (Hibernate, JPA, etc.) and coach developers on writing efficient, index-friendly queries and avoiding common ORM anti-patterns.
  • Provide guidance on connection pool sizing, transaction scope, isolation levels, and PostgreSQL-specific concurrency tools (advisory locks, SKIP LOCKED).
  • Author internal playbooks, query review checklists, and reference patterns so good database practices scale across engineering.
  • Partner with Software Engineers on every Lightspeed DMS release to apply an N‑1 compatibility strategy. Schema changes use expand / migrate / contract sequences so the database supports both the new and prior release simultaneously, enabling safe rolling deploys and rollback.

Reliability, Change Management & Incident Response

  • Establish and enforce a safe migration workflow for schema and data changes: review, staging validation, rollback planning, and zero-downtime patterns (CONCURRENTLY, online column adds, dual-write, expand/contract).
  • Guide minor and major version upgrades on RDS and Aurora, including extension compatibility, plan regression testing, and cutover strategy.
  • Build and refine Datadog dashboards, monitors, and DBM views covering query latency, lock waits, replication lag, and connection saturation.
  • Lead database-related incident response: deep diagnostic analysis (lock chains, long-running transactions, replication issues) and post-incident remediation.
  • Define and validate backup, point-in-time recovery, and cross-region replication strategies through periodic DR exercises.

Security & Compliance

  • Enforce least-privilege role and grant design across application, replica, and analytics access patterns.
  • Support audit, SOC, and compliance requirements through proper logging, retention, and access controls (pgaudit, CloudWatch, parameter group enforcement).
  • Partner with the security team to ensure the fleet is secure by default: least privilege, appropriate access restrictions, and encryption at rest and in transit.
Required Qualifications:
  • 5+ years of hands-on PostgreSQL administration experience in production environments.
  • Strong working 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 transaction behavior in PostgreSQL.
  • Proven experience diagnosing application-driven performance issues in high-scale production environments.
  • Strong ability to read EXPLAIN plans and turn analysis into concrete query, index, or schema changes.
  • Experience implementing zero-downtime schema migration and backward-compatible deployment strategies in production systems.
  • Strong written and verbal communication, with the ability to explain database tradeoffs clearly to both engineers and non-technical stakeholders.
Preferred Qualifications:
  • Experience tuning Java/JVM applications and reviewing ORM-generated SQL (Hibernate, JPA, MyBatis).
  • Familiarity with Datadog Database Monitoring (DBM) or comparable APM-to-database correlation tooling.
  • Experience with Terraform or other IaC tools managing RDS/Aurora resources and parameter groups.
  • Familiarity with Kubernetes-hosted application stacks (WildFly, Spring, etc.) and how connection pools behave at pod scale.

 

 

Inclusion and Diversity at Lightspeed:

At Lightspeed, we celebrate the uniqueness of every individual and encourage diverse perspectives. We believe that inclusion drives innovation and fosters meaningful connections. We are committed to building an environment where everyone feels valued and empowered to make an impact.

Equal Employment Opportunity Statement:

Lightspeed is an Equal Opportunity Employer and is dedicated to building a diverse and inclusive workforce. All qualified applicants will be considered for employment without regard to race, color, creed, ancestry, national origin, gender, sexual orientation, gender identity, gender expression, marital status, religion, age, disability, veteran status, or any other protected category.

Important Note:

Applicants must be authorized to work in the U.S.

Ready to apply?

Take the next step in your career—apply today and join a team where your skills will make an impact!

 

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Montevideo, UY

Working pattern and location restrictions need checking in the full posting.

Work authorization
Important Note: Applicants must be authorized to work in the U.S. Ready to apply?

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.