PostgreSQL Database Engineer

Overview

Cube Smart is seeking an experienced Postgre

SQL 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 Postgre

SQL environments across cloud platforms.

You will partner closely with cloud Infrastructure, security, and application teams to ensure our Postgre

SQL footprint is fast, stable, cost‑efficient, and aligned with cloud best practices.

Who we are:

At Cube Smart, we’re intentional about culture. You can experience it everywhere from our mission statement of “genuine care” to our “It’s What’s Inside That Counts” tagline to calling each other “teammates” rather than employees. This spirit fosters a fun and collaborative environment that has resulted in our rapid growth and being recognized amongst the top in our industry.

Cube Smart’s award‑winning team is made up of people who genuinely care. Teammates care about our customers and the life events and/or business needs they are facing. Teammates are passionate, responsible and understanding. The Cube Smart team is made up of people who have a can‑do attitude, are committed to their own success and the success of the company, and lead by example.

If this sounds like a team and culture that matches your personal values and motivations, we want to hear from you.

Key Responsibilities

Cloud‑Native Database Engineering

• Architect, deploy, and manage Postgre
  
  SQL 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.
• Optimize resource utilization (I/O, compute, storage tiers) to balance performance and cost.

Advanced Performance Tuning & Optimization

• Diagnose and resolve complex performance challenges using query analysis, indexing strategies, and execution plan optimization.
• Continuously tune Postgre
  
  SQL parameters (, , autovacuum tuning, WAL settings) to support high‑throughput workloads.
• Analyze _activity, _statements, and cloud native performance metrics to proactively detect and fix performance issues.
• Work closely with developers to optimize queries and improve data access patterns.

Archival Strategy & Data Lifecycle Management

• Define and implement a comprehensive data archival strategy to reduce resource consumption and improve performance.
• Architect cold storage, tiered storage, or partitioning‑based archival solutions (e.g., native partitioning, time‑based partition strategies).
• Automate archival, retention, and purging processes while ensuring compliance and auditability.
• Ensure archival strategies align with cloud cost optimization and long‑term retention needs.

Database Maintenance, Patching, & Upgrades

• Develop and execute patching
  , minor version updates
  , and major upgrade strategies with minimal downtime.
• Implement blue/green or rolling upgrade patterns where supported.
• Ensure all Postgre
  
  SQL versions adhere to cloud provider support policies and internal governance.
• Maintain robust upgrade automation (Ansible, Terraform, CI/CD pipelines, or cloud-native tools).

Reliability, Monitoring & Operations

• Configure and tune monitoring and alerting for performance, replication health, vacuum performance, storage growth, and query latency.
• Ensure strong HA/DR strategies leveraging built‑in or cloud-native replication and failover mechanisms.
• Conduct capacity planning and performance forecasting to keep ahead of workload trends.
• Troubleshoot database incidents and drive root‑cause analysis for performance degradations.

Automation & Dev Ops Integration

• Automate provisioning, configuration, tuning, and lifecycle workflows using scripting (Python, Bash) and IaC tooling.
• Integrate database tasks into Dev Ops pipelines to support continuous deployment and automated patching.
• Build internal tools to improve operational consistency and visibility.

Qualifications

• 5+ years of production Postgre
  
  SQL…