{"schemaVersion":"jobsearcher.job.v1","id":"e5fc366a81a8ad1fdeecd968","url":"https://jobsearcher.com/jobs/e5fc366a81a8ad1fdeecd968","canonicalUrl":"https://jobsearcher.com/jobs/e5fc366a81a8ad1fdeecd968","title":"Senior PostgreSQL Database Reliability Engineer","description":"Senior PostgreSQL Database Reliability Engineer\nResponsibilities:\nProduction PostgreSQL infrastructure across the full lifecycle: architecture, deployment, replication, monitoring, performance tuning, backup/recovery, and capacity planning\nStreaming replication and high-availability configurations that meet the uptime expectations of a regulated financial exchange\nQuery and system-level performance analysis—diagnosing slow queries, optimizing execution plans, tuning shared_buffers, work_mem, and autovacuum, not just reading pg_stat output but knowing what to do about it\nBackup and disaster recovery strategy using tools like Barman, including point-in-time recovery testing and validation\nData architecture evolution: modernizing data warehouse and reporting infrastructure, building ETL pipelines, and designing data flows that scale with the business\nData services across the organization: test data management, data obfuscation, data modeling, and supporting data needs for development, QA, and business teams\nOperational support including on-call rotation for after-hours production database emergencies\n\nSkills, Knowledge and Expertise\nRequired\n5+ years hands-on PostgreSQL administration in production environments—not just dev/test, not just managed RDS\nDeep understanding of PostgreSQL internals: WAL mechanics, MVCC, vacuum processing, the query planner and optimizer, connection handling, and lock management\nProven experience with physical and logical replication: setup, monitoring, failover, and troubleshooting split-brain scenarios\nStrong SQL performance tuning skills: reading EXPLAIN ANALYZE output, identifying indexing strategies, understanding join algorithms, and resolving locking contention\nSolid Linux systems administration (we run Ubuntu)—comfortable with systemd, filesystem performance, memory management, and networking fundamentals\nExperience with backup/recovery tools (Barman, pgBackRest, or equivalent) and tested disaster recovery procedures\nExperience building and maintaining ETL pipelines and data transformation processes\nBachelor’s degree in Computer Science, Information Systems, Mathematics, or a related field\nIND4","company":"Cherry Bekaert","rawCompany":"cherry bekaert","city":"McLean","state":"VA","isRemote":false,"isActive":false,"createdAt":"2026-07-16T17:59:17.570Z","occupations":[{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541519","title":"Other Computer Related Services","slug":"other-computer-related-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Senior PostgreSQL Database Reliability Engineer","description":"Senior PostgreSQL Database Reliability Engineer\nResponsibilities:\nProduction PostgreSQL infrastructure across the full lifecycle: architecture, deployment, replication, monitoring, performance tuning, backup/recovery, and capacity planning\nStreaming replication and high-availability configurations that meet the uptime expectations of a regulated financial exchange\nQuery and system-level performance analysis—diagnosing slow queries, optimizing execution plans, tuning shared_buffers, work_mem, and autovacuum, not just reading pg_stat output but knowing what to do about it\nBackup and disaster recovery strategy using tools like Barman, including point-in-time recovery testing and validation\nData architecture evolution: modernizing data warehouse and reporting infrastructure, building ETL pipelines, and designing data flows that scale with the business\nData services across the organization: test data management, data obfuscation, data modeling, and supporting data needs for development, QA, and business teams\nOperational support including on-call rotation for after-hours production database emergencies\n\nSkills, Knowledge and Expertise\nRequired\n5+ years hands-on PostgreSQL administration in production environments—not just dev/test, not just managed RDS\nDeep understanding of PostgreSQL internals: WAL mechanics, MVCC, vacuum processing, the query planner and optimizer, connection handling, and lock management\nProven experience with physical and logical replication: setup, monitoring, failover, and troubleshooting split-brain scenarios\nStrong SQL performance tuning skills: reading EXPLAIN ANALYZE output, identifying indexing strategies, understanding join algorithms, and resolving locking contention\nSolid Linux systems administration (we run Ubuntu)—comfortable with systemd, filesystem performance, memory management, and networking fundamentals\nExperience with backup/recovery tools (Barman, pgBackRest, or equivalent) and tested disaster recovery procedures\nExperience building and maintaining ETL pipelines and data transformation processes\nBachelor’s degree in Computer Science, Information Systems, Mathematics, or a related field\nIND4","datePosted":"2026-07-16T17:59:17.570Z","dateModified":"2026-07-16T17:59:17.570Z","hiringOrganization":{"@type":"Organization","name":"Cherry Bekaert","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"McLean","addressRegion":"VA","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"e5fc366a81a8ad1fdeecd968"},"url":"https://jobsearcher.com/jobs/e5fc366a81a8ad1fdeecd968"}}