Cloud PostgreSQL DBA - AWS & HA Expert

SquareTrade; San Francisco (CA); Hybrid; USD 145,000 - 160,000; Full time

Benefits offered by this job

Medical and vision coverage

401(k) with company match

Hybrid work arrangements

Job summary

SquareTrade is seeking a Mid‑Level Database Administrator (DBA) with strong PostgreSQL and SQL optimization skills. The role focuses on managing a fully cloud‑native database environment after migrating to AWS, working with IT, Engineering, QA, and Data & Analytics teams.

The ideal candidate has 4–6 years of PostgreSQL experience, plus knowledge of SQL Server. Hybrid work with SF Bay Area offices is available and AWS monitoring is required.

Qualifications

• 4–6 years of hands‑on PostgreSQL administration in production environments.
• Experience with Microsoft SQL Server alongside PostgreSQL is valued.
• 4+ years managing managed DB services in AWS (Aurora, RDS, EC2) and monitoring with Datadog.
• Backup tooling expertise with pg_dump, pg_restore, and AWS Snapshots.
• Advanced SQL development: joins, indexing, CTEs, and window functions.
• Moderate to advanced scripting in Bash, Python, or PowerShell for automation.
• Strong database design knowledge and capacity planning in a cloud context.
• Excellent communication and ability to work independently in a fast‑growing environment.

Responsibilities

• Cloud Database Management: set up, configure, monitor, and maintain PostgreSQL servers in AWS for HA, health, and security.
• Security & Access Control: manage IAM and DB access controls, conduct audits for compliance.
• Backup & Disaster Recovery: oversee automated backups, test DR procedures regularly.
• Maintenance & High Availability: perform patching and upgrades with minimal downtime.
• Replication & Scaling: configure and monitor PostgreSQL replication, including Aurora replicas and logical replication.
• Developer Support & Optimization: assist with schema design and query optimization with engineering teams.
• Code Review: peer‑review SQL code for security and efficiency.
• Performance Tuning: diagnose bottlenecks and apply indexing or configuration fixes.
• Cross‑Platform Support: maintain Microsoft SQL Server environments as required.
• On‑Call Support: participate in 24x7 on‑call rotation.

Skills

PostgreSQL

SQL optimization

AWS cloud

Microsoft SQL Server

Advanced SQL

CTEs

Window functions

Scripting (Bash/Python/PowerShell)

Database design

On-call support

Education

Bachelor's degree in computer science or related field

Tools

AWS Aurora

RDS

EC2 database hosting

Datadog monitoring

pg_dump/pg_restore

AWS Snapshots

Job description

SquareTrade is seeking a Mid‑Level Database Administrator (DBA) with strong PostgreSQL and SQL optimization skills. The role focuses on managing a fully cloud‑native database environment after migrating to AWS, working with IT, Engineering, QA, and Data & Analytics teams.

The ideal candidate has 4–6 years of PostgreSQL experience, plus knowledge of SQL Server. Hybrid work with SF Bay Area offices is available and AWS monitoring is required.