Browse JobsCareer BlogJob Search ResourcesAI Interview PreparationWorkzil HomeJob ListingsPricing PlansContact UsCreate AccountHiring SolutionsSecurity & PrivacyAffiliate ProgramFree CV BuilderAI CV ReviewerFree Resume BuilderAI Resume ReviewerSalary CalculatorSalary Comparison ChartsLayoff TrackerLayoff NewsHiring Trends 2026Startup Funding TrackerCompany Expansion TrackerVisa Sponsorship CompaniesBest Companies to Work ForBlog ArticlesCareer ResourcesAI Interview PrepTerms of ServicePrivacy PolicyCookie PolicyPost a JobAI Candidate ScreeningEmployer PricingEnterprise SolutionsJobs in New YorkJobs in San FranciscoJobs in AustinJobs in SeattleJobs in ChicagoJobs in Los AngelesJobs in BostonJobs in DenverJobs in AtlantaJobs in MiamiJobs in DallasJobs in Washington DCJobs in San JoseJobs in RaleighJobs in NashvilleSoftware Engineer JobsData Scientist JobsProduct Manager JobsData Analyst JobsUX Designer JobsFrontend Developer JobsDevOps Engineer JobsMarketing Manager JobsFinancial Analyst JobsCybersecurity Analyst JobsSoftware Engineer Salary GuideData Scientist SalaryProduct Manager SalaryUX Designer SalaryDevOps Engineer SalaryCloud Architect SalarySoftware Engineer Salary CalculatorData Scientist Salary CalculatorProduct Manager Salary CalculatorSoftware Engineer Salary San FranciscoSoftware Engineer Salary New YorkData Scientist Salary SeattleProduct Manager Salary AustinDevOps Engineer Salary CalculatorUX Designer Salary CalculatorSoftware Engineer Interview QuestionsProduct Manager Interview QuestionsData Scientist Interview QuestionsUX Designer Interview QuestionsFrontend Developer Interview QuestionsRemote Software Engineer JobsRemote Product Manager JobsRemote Data Analyst JobsRemote UX Designer JobsRemote Frontend Developer JobsElectrician JobsPlumber JobsHVAC Technician JobsRegistered Nurse JobsTruck Driver JobsWarehouse Worker JobsCarpenter JobsWelder JobsRestaurant Manager JobsConstruction Manager JobsDental Hygienist JobsReal Estate Agent JobsElectrician Salary GuidePlumber Salary GuideRegistered Nurse SalaryTruck Driver SalaryHVAC Technician SalaryWelder Salary GuideElectrician Interview QuestionsNursing Interview QuestionsTruck Driver Interview QuestionsRestaurant Manager Interview QuestionsLayoffs 2026Layoffs 2025Layoffs 2024Layoffs 2023Google LayoffsMeta LayoffsAmazon LayoffsMicrosoft LayoffsSoftware Engineer Resume BuilderData Scientist Resume BuilderProduct Manager Resume BuilderRegistered Nurse Resume BuilderMarketing Manager Resume BuilderTechnology Industry JobsFinance Industry JobsHealthcare Industry JobsConstruction & Trades JobsRetail & E-Commerce JobsSoftware Engineer vs Data ScientistSoftware Engineer vs Product ManagerData Scientist vs Data AnalystFrontend vs Backend DeveloperProduct Manager vs Project ManagerElectrician vs Plumber
    WorkzilWorkzil
    Find Jobs
    Pricing
    Sign inGet Started
    • Find Jobs
    • Companies
    • AI Interview Prep
    • For Employers
    • Intelligence
    • Pricing
    • Support
    • Free Tools
      • CV / Resume Builder
      • CV / Resume Reviewer
      • Salary Calculator
      • Salary Comparison
    • Company Intelligence
      • Layoff Tracker
      • Hiring Trends
      • Funding Tracker
      • Expansion News
      • Visa Sponsorship
      • Layoff News
    • Career Research
      • Best Companies
      • Industry Guides
      • Compare Roles
      • Salary Guides
      • Interview Questions
      • Remote Jobs
    • Resources
      • Blog
      • Resources
      • Community
    • Post a Job
    • Sign Up
    • Sign In
    • Contact
    WorkzilWorkzil
    Find Jobs
    Pricing
    Sign inGet Started
    • Find Jobs
    • Companies
    • AI Interview Prep
    • For Employers
    • Intelligence
    • Pricing
    • Support
    • Free Tools
      • CV / Resume Builder
      • CV / Resume Reviewer
      • Salary Calculator
      • Salary Comparison
    • Company Intelligence
      • Layoff Tracker
      • Hiring Trends
      • Funding Tracker
      • Expansion News
      • Visa Sponsorship
      • Layoff News
    • Career Research
      • Best Companies
      • Industry Guides
      • Compare Roles
      • Salary Guides
      • Interview Questions
      • Remote Jobs
    • Resources
      • Blog
      • Resources
      • Community
    • Post a Job
    • Sign Up
    • Sign In
    • Contact
    Saltar al contenido principal
    Buscar empleosRemotoPráctica de entrevistas
    Qué es WorkzilIniciar sesiónEmpezar
    EmpleosMontevideoSr Database Administrator · Lightspeed DMS
    L
    Lightspeed DMS500-1000 empleados

    Sr Database Administrator

    Montevideo, UY · Publicado el 4 jun 2026

    Salario
    Salario no publicado
    Ubicación
    Montevideo, UY
    Nivel
    No indicado
    Publicado
    4 jun 2026
    Fecha de la fuente

    Sobre el puesto

    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!

    Empleos similares

    Ver todos los resultados
    OSenior Database AdministratorOnafriqJohannesburg, GautengSalario no publicado
    Visto por primera vez hace 3 d
    TSenior Database Administratortbi bankSofia, Sofia, BulgariaSalario no publicado
    Visto por primera vez hace 3 d
    BSenior Database Administrator (Microsoft SQL Server)BIQHAmersfoort, Utrecht, NetherlandsSalario no publicado
    Visto por primera vez hace 3 d
    Postular en el sitio del empleadorEntrevista con IA

    Abre la página de solicitud del empleador en una pestaña nueva.

    Entrevista con IA

    Practica esta entrevista con IA

    Una entrevista de práctica para este puesto exacto, con comentarios que puedes aplicar.

    Workzil

    Workzil es un solo ciclo: encontrar trabajo, entender el mercado que lo rodea y contratar. Cada cifra indica su fuente y su fecha.

    Volver a Workzil

    Sitios de Workzil

    • WorkzilLo que hacemos: un solo ciclo, desde encontrar trabajo hasta contratar.
    • Workzil JobsOfertas abiertas con fecha de publicación real y salario publicado.
    • Workzil MarketSalarios y contratación para tu puesto y tu zona, con fuentes.
    • Workzil EmployersPáginas de empresa con ofertas activas, verificadas con correo corporativo.
    © 2026 WorkzilPrivacidadTérminos