Responsibilities
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.
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 PostgreSQL parameters (work_mem, shared_buffers, autovacuum tuning, WAL settings) to support high‑throughput workloads.
Analyze pg_stat_activity, pg_stat_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 PostgreSQL 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 & DevOps Integration
Automate provisioning, configuration, tuning, and lifecycle workflows using scripting (Python, Bash) and IaC tooling.
Integrate database tasks into DevOps pipelines to support continuous deployment and automated patching.
Build internal tools to improve operational consistency and visibility.
Qualifications
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 HA strategies.
Experience implementing data archival and lifecycle management practices at scale.
Proven experience executing patching and major/minor PostgreSQL upgrades.
Strong scripting skills in Bash or Python.
Solid experience with monitoring tools (pg_stat_statements, Prometheus/Grafana, pganalyze, CloudWatch, Azure Monitor).
Candidates must be authorized to work in the U.S. without the need for current or future sponsorship.
We are an Equal Opportunity Employer, Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity
#LI-Hybrid
#LI-MT1
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.
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 PostgreSQL parameters (work_mem, shared_buffers, autovacuum tuning, WAL settings) to support high‑throughput workloads.
Analyze pg_stat_activity, pg_stat_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 PostgreSQL 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 & DevOps Integration
Automate provisioning, configuration, tuning, and lifecycle workflows using scripting (Python, Bash) and IaC tooling.
Integrate database tasks into DevOps pipelines to support continuous deployment and automated patching.
Build internal tools to improve operational consistency and visibility.
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 HA strategies.
Experience implementing data archival and lifecycle management practices at scale.
Proven experience executing patching and major/minor PostgreSQL upgrades.
Strong scripting skills in Bash or Python.
Solid experience with monitoring tools (pg_stat_statements, Prometheus/Grafana, pganalyze, CloudWatch, Azure Monitor).
Candidates must be authorized to work in the U.S. without the need for current or future sponsorship.
We are an Equal Opportunity Employer, Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity
#LI-Hybrid
#LI-MT1
