Senior PostgreSQL Database Reliability Engineer

Senior PostgreSQL Database Reliability Engineer

Responsibilities:

• Production PostgreSQL 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 analysisdiagnosing slow queries optimizing execution plans tuning sharedbuffers workmem and autovacuum not just reading pgstat 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

Skills Knowledge and Expertise

Required

• 5 years hands-on PostgreSQL administration in production environmentsnot just dev/test not just managed RDS
• Deep understanding of PostgreSQL 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 filesystem 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
• Bachelors degree in Computer Science Information Systems Mathematics or a related field