Sr Database Administrator
- Compensation
- Not disclosed
- Location
- Montevideo, UY
- Work setup
- Not specified
- Seniority
- Senior
- Employment
- Contract
- Experience
- 5+ years
- Category
- Devops
- Posted
Skills
Must have
- 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.
Nice to have
- 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.
Full 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 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.