Senior PostgreSQL Reliability Engineer (Remote, AWS)

Appsierra Group; Österreich; Vor Ort; EUR 104.000 - 129.000; Vollzeit

Zusammenfassung

Appsierra Group seeks a Senior Database Reliability Engineer to architect, optimize, and maintain PostgreSQL environments at scale in a remote setup. You will leverage AWS RDS, Aurora PostgreSQL, and HA strategies to ensure highly available data services for mission-critical workloads.

The role emphasizes performance tuning, disaster recovery, and collaboration with cross-functional teams. Candidates with 5+ years in PostgreSQL production environments and strong replication/backup skills are

Qualifikationen

• 5+ years of experience managing and optimizing PostgreSQL databases in production.
• Expert-level knowledge of PostgreSQL internals, query tuning, indexing, partitioning, and replication.
• Proven hands-on experience with AWS RDS and Aurora PostgreSQL, including backup, recovery, and high availability.
• Strong analytical and troubleshooting skills involving slow queries, execution plans, locks, deadlocks, and bottlenecks.
• Experience maintaining large-scale, high-traffic databases with millions of rows.
• Clear, proactive written and verbal communication; able to work autonomously in a remote team.

Aufgaben

• Design, implement, and manage highly available PostgreSQL architectures using AWS RDS and Aurora PostgreSQL.
• Optimize performance via query execution plans, indexing, and partitioning strategies.
• Ensure disaster recovery readiness with backup, replication, recovery, and failover processes.
• Diagnose and resolve slow queries, locks, deadlocks, and bottlenecks in large-scale databases.
• Automate maintenance tasks and promote operational excellence across environments.
• Collaborate on data migrations and application scaling; maintain docs.

Kenntnisse

PostgreSQL

AWS RDS

Aurora PostgreSQL

DB reliability

High availability

Query optimization

Replication

Backup & Recovery

Disaster recovery

Failover

Terraform

CI/CD

Cloud-native infra

Locks & Deadlocks

Execution plans

Jobbeschreibung

Appsierra Group seeks a Senior Database Reliability Engineer to architect, optimize, and maintain PostgreSQL environments at scale in a remote setup. You will leverage AWS RDS, Aurora PostgreSQL, and HA strategies to ensure highly available data services for mission-critical workloads.

The role emphasizes performance tuning, disaster recovery, and collaboration with cross-functional teams. Candidates with 5+ years in PostgreSQL production environments and strong replication/backup skills are