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,767 similar postings that came down. Coming down is not always a hire.
Montevideo, UY
Open 5 months, first seen by us 170 days agoThis 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
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
Applicants must be authorized to work in the US
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.
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.
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
Day 170
Up longer than most. Similar jobs usually come down between day 6 and day 56.
From 14,767 similar postings that came down. Coming down is not always a hire.
1 open job
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.
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.
Complete your application on job-boards.greenhouse.io. The employer’s form will show what is required.
Already applied? Track this application
Company Overview:
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
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!
New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.
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.
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.
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.
Selected passages from the saved posting. Check the full description for conditions and exceptions.
No pay amount identified in the saved description.
Montevideo, UY
Working pattern and location restrictions need checking in the full posting.
Important Note: Applicants must be authorized to work in the U.S. Ready to apply?