Cloud PostgreSQL DBA (AWS) – Hybrid, Bay Area

SmartRecruiters, Inc.; San Francisco (CA); Hybrid; USD 145,000 - 160,000; Full time

Benefits offered by this job

Medical, dental and vision coverage

401(k) match

Tuition reimbursement

Hybrid work arrangements

Flexible time off

Job summary

SquareTrade, a member of the Allstate family with headquarters in San Francisco, is seeking a Mid‑Level Database Administrator to own cloud database management and SQL optimization in a fully cloud‑native environment.

The role focuses on PostgreSQL in AWS, with valued experience in Microsoft SQL Server. You will collaborate with IT, Eng, QA, and Data & Analytics to modernize data architecture and ensure reliability.

Qualifications

• 4–6 years of hands‑on PostgreSQL production experience.
• Experience with Microsoft SQL Server alongside PostgreSQL is valued.
• 4+ years managing AWS managed DB services (Aurora, RDS) and cloud monitoring with Datadog.

Responsibilities

• Manage PostgreSQL on AWS with high availability, security, and performance.
• Audit IAM and access controls across environments.
• Oversee backups, DR testing, and disaster recovery procedures.
• Perform maintenance, patching, and major version upgrades with minimal downtime.
• Configure replication (Aurora Read Replicas, logical replication) and monitor performance.
• Collaborate with engineers on schema design and query optimization.
• Peer-review SQL code for efficiency and security.
• Lead on-call duties for enterprise reliability.
• Support and maintain Microsoft SQL Server environments as needed.

Skills

SQL optimization

Cloud database management

Scripting (Bash, Python, PowerShell)

IAM and access control

Backup and DR planning

Advanced SQL development

Cross-functional collaboration

Education

Bachelor's degree in computer science/IT or related field

Tools

PostgreSQL

Microsoft SQL Server

AWS (Aurora/RDS)

Datadog

Job description

SquareTrade, a member of the Allstate family with headquarters in San Francisco, is seeking a Mid‑Level Database Administrator to own cloud database management and SQL optimization in a fully cloud‑native environment.

The role focuses on PostgreSQL in AWS, with valued experience in Microsoft SQL Server. You will collaborate with IT, Eng, QA, and Data & Analytics to modernize data architecture and ensure reliability.