Database Engineer (PostgreSQL)

Postgres
UNITED STATES
October 25, 2026
Full Time
Apply Now

Job Description

Company: CubeSmart
Location: Malvern, Pennsylvania
Workplace Type: Hybrid
Employment Type: Full-time

About the Role

CubeSmart is seeking an experienced Database Engineer specializing in cloud‑based database performance, optimization, and lifecycle management. This role is ideal for an engineer who excels at improving database performance at scale, designing and implementing archival solutions, executing complex patching and upgrade strategies, and ensuring the overall health and efficiency of PostgreSQL environments across cloud platforms. You will partner closely with cloud Infrastructure, security, and application teams to ensure our PostgreSQL footprint is fast, stable, cost‑efficient, and aligned with cloud best practices.

What You’ll Do / Key Responsibilities

  • Cloud‑Native Database Engineering: Architect, deploy, and manage PostgreSQL instances and clusters in cloud environments (AWS/Azure/GCP or managed solutions like RDS, Aurora, Azure Flexible Server, Cloud SQL). Develop cloud‑efficient database schemas, indexing strategies, and storage configurations, and optimize resource utilization.
  • Advanced Performance Tuning & Optimization: Diagnose and resolve complex performance challenges using query analysis, indexing strategies, and execution plan optimization. Continuously tune PostgreSQL parameters (work_mem, shared_buffers, autovacuum tuning, WAL settings) to support high‑throughput workloads and analyze metrics via pg_stat_activity and pg_stat_statements.
  • Archival Strategy & Data Lifecycle Management: Define and implement a comprehensive data archival strategy to reduce resource consumption and improve performance by architecting cold storage, tiered storage, or partitioning-based archival solutions.
  • Database Maintenance, Patching, & Upgrades: Develop and execute patching, minor version updates, and major upgrade strategies with minimal downtime using blue/green or rolling upgrade patterns, ensuring compliance with support policies and internal governance.
  • Reliability, Monitoring & Operations: Configure and tune monitoring and alerting for performance, replication health, vacuum performance, storage growth, and query latency while ensuring strong HA/DR strategies and driving root‑cause analysis for performance degradations.
  • Automation & DevOps Integration: Automate provisioning, configuration, tuning, and lifecycle workflows using scripting (Python, Bash) and Infrastructure as Code (IaC) tooling, integrating database tasks into DevOps pipelines.

Requirements & Qualifications

  • 5+ years of production PostgreSQL engineering experience, including cloud deployments.
  • Deep expertise in performance tuning, advanced query optimization, and PostgreSQL internals (WAL, MVCC, vacuum processes, query planner).
  • Strong experience with cloud‑managed PostgreSQL platforms such as AWS RDS/Aurora, Azure PostgreSQL, or GCP Cloud SQL (AWS RDS/Aurora is preferred).
  • Hands‑on expertise with replication, failover, vacuum management, and High Availability (HA) strategies.
  • Proven experience implementing data archival and lifecycle management practices at scale, as well as executing patching and major/minor upgrades.
  • Strong scripting skills in Bash or Python.
  • Solid experience with monitoring tools including pg_stat_statements, Prometheus/Grafana, pganalyze, CloudWatch, or Azure Monitor.
  • Candidates must be authorized to work in the U.S. without the need for current or future sponsorship.

Benefits & Perks (if applicable)

  • Not Specified

We are an Equal Opportunity Employer, Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.

Related Jobs