Senior PostgreSQL Database Reliability Engineer

Overview

Senior Postgre

SQL Database Reliability Engineer

• Production Postgre
  
  SQL infrastructure across the full lifecycle: architecture, deployment, replication, monitoring, performance tuning, backup/recovery, and capacity planning
• Streaming replication and high-availability configurations that meet the uptime expectations of a regulated financial exchange
• Query and system-level performance analysis—diagnosing slow queries, optimizing execution plans, tuning , , and autovacuum, not just reading  output but knowing what to do about it
• Backup and disaster recovery strategy using tools like Barman, including point-in-time recovery testing and validation
• Data architecture evolution: modernizing data warehouse and reporting infrastructure, building ETL pipelines, and designing data flows that scale with the business
• Data services across the organization: test data management, data obfuscation, data modeling, and supporting data needs for development, QA, and business teams
• Operational support including on-call rotation for after-hours production database emergencies

• 5+ years hands-on Postgre
  
  SQL administration in production environments—not just dev/test, not just managed RDS
• Deep understanding of Postgre
  
  SQL internals: WAL mechanics, MVCC, vacuum processing, the query planner and optimizer, connection handling, and lock management
• Proven experience with physical and logical replication: setup, monitoring, failover, and troubleshooting split-brain scenarios
• Strong SQL performance tuning skills: reading EXPLAIN ANALYZE output, identifying indexing strategies, understanding join algorithms, and resolving locking contention
• Solid Linux systems administration (we run Ubuntu)—comfortable with systemd, file system performance, memory management, and networking fundamentals
• Experience with backup/recovery tools (Barman, pgBackRest, or equivalent) and tested disaster recovery procedures
• Experience building and maintaining ETL pipelines and data transformation processes
• Bachelor’s degree in Computer Science, Information Systems, Mathematics, or a related field