Cloud PostgreSQL DBA — Hybrid Dallas

SmartRecruiters, Inc.; Dallas (TX); Hybrid; USD 145,000 - 160,000; Full time

Benefits offered by this job

Health coverage

401(k) match

Tuition reimbursement

Mental health resources

Hybrid work arrangements

Job summary

SquareTrade in Dallas seeks a Mid-Level Database Administrator focused on PostgreSQL in a cloud-native AWS environment. You will join a dispersed DBA team maintaining high-availability, security, and performance for production, QA, and development databases.

You’ll collaborate with IT, Engineering, QA, and Data & Analytics, optimize complex SQL, manage backups, DR, and on-call rotations, while also supporting legacy SQL Server as needed.

Qualifications

• 4–6 years of PostgreSQL production experience.
• Experience with Microsoft SQL Server alongside PostgreSQL is valued.
• 4+ years managing AWS managed DB services (Aurora, RDS, EC2 hosting).
• Proficiency with backup tools like pg_dump/pg_restore and AWS Snapshots.
• Strong SQL development with joins, indexing, CTEs, window functions.

Responsibilities

• Manage PostgreSQL servers in AWS for production, QA, and development.
• Handle IAM and access control, audits for compliance.
• Oversee backup and disaster recovery procedures and testing.
• Perform maintenance, patching, and upgrades with minimal downtime.
• Configure replication (Aurora read replicas, logical replication) for durability.
• Support developers with schema design and query optimization.
• Peer-review SQL code for efficiency and security.
• Analyze performance bottlenecks and adjust indexes/server configs.
• Maintain MS SQL Server environments as needed.
• Participate in 24x7 on-call rotation.

Skills

PostgreSQL

SQL optimization

Cloud database management

Automation scripting

Analytical thinking

Collaboration

Education

Bachelor's degree in CS/IT or equivalent

Tools

AWS

Aurora

RDS

Datadog

pg_dump/pg_restore

SQL Server

Job description

SquareTrade in Dallas seeks a Mid-Level Database Administrator focused on PostgreSQL in a cloud-native AWS environment. You will join a dispersed DBA team maintaining high-availability, security, and performance for production, QA, and development databases.

You’ll collaborate with IT, Engineering, QA, and Data & Analytics, optimize complex SQL, manage backups, DR, and on-call rotations, while also supporting legacy SQL Server as needed.