Senior PostgreSQL Database Reliability Engineer

📋 Description

• Manage the PostgreSQL production infrastructure throughout its entire lifecycle, including architecture, deployment, replication, monitoring, performance tuning, backup/recovery, and capacity planning.

• Implement streaming replication and high-availability configurations to fulfill the uptime requirements of a regulated financial exchange.

• Conduct query and system-level performance analyses by diagnosing slow queries, optimizing execution plans, and tuning parameters such as shared_buffers, work_mem, and autovacuum; this includes not only reading pg_stat output but also knowing the necessary actions to take.

• Develop a backup and disaster recovery strategy utilizing tools like Barman, which encompasses point-in-time recovery testing and validation.

• Drive the evolution of data architecture by modernizing the data warehouse and reporting infrastructure, constructing ETL pipelines, and designing scalable data flows that align with business growth.

• Provide data services across the organization, including test data management, data obfuscation, data modeling, and addressing data needs for development, QA, and business teams.

• Offer operational support, including participating in an on-call rotation for after-hours production database emergencies.

⛳️ Requirements

• A minimum of 5 years of hands-on experience in PostgreSQL administration within production environments—not limited to development/testing or managed RDS.

• In-depth knowledge of PostgreSQL internals, including WAL mechanics, MVCC, vacuum processing, the query planner and optimizer, connection handling, and lock management.

• Demonstrated experience with both physical and logical replication, including setup, monitoring, failover, and troubleshooting split-brain scenarios.

• Proficient SQL performance tuning capabilities, including interpreting EXPLAIN ANALYZE output, identifying effective indexing strategies, understanding join algorithms, and addressing locking contention.

• Strong Linux systems administration skills (we use Ubuntu), with familiarity in systemd, filesystem performance, memory management, and networking basics.

• Experience with backup/recovery tools such as Barman, pgBackRest, or similar, along with validated disaster recovery procedures.

• Proven experience in constructing and maintaining ETL pipelines and data transformation processes.

• Capability to work independently within a small team, taking ownership of issues from identification through to resolution.

• Bachelor’s degree in Computer Science, Information Systems, Mathematics, or a related discipline.

🏝️ Benefits

• Nodal Employee Benefits and Perks: https://nodalexchange.pinpointhq.com

• Nodal Exchange participates in E-verify.