> Markdown version of [/jobs/ext/3204454-postgresql-database-administrator](https://www.wearedevelopers.com/jobs/ext/3204454-postgresql-database-administrator). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # PostgreSQL Database Administrator - **Company:** Sectigo, Inc. - **Location:** Manchester, NH, United States (Remote available) - **Experience:** Experienced - **Salary:** $50,000.0 - $54,000.0 - **Contract:** Permanent contract - **Skills:** Amazon Web Services, Bash Shell, Information Systems, Databases, System Configuration, File Systems, Memory Management, Failover, Github, Identity and Access Management, Python (Programming Language), PostgreSQL, Linux System Administration, MariaDB, MySQL, Performance Tuning, Quorum, Reliability Engineering, Ansible, Prometheus, Shell Script, SQL Databases, Data Streaming, Virtual Machines, Cloud Platform System, Cloud Monitoring, System Availability, Grafana, Git, Information Technology, Hardware Infrastructure, Terraform, Software Version Control - **Published:** September 9, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=8be5ea5a20a850dd ## About the Role * Bachelor's degree in information systems, computer science, technology, or a related field is strongly preferred. In lieu of degree, 2+ years of relevant and/or equivalent experience is acceptable., * Minimum of 5+ years of hands-on PostgreSQL administration in production environments, including both routine operations and complex troubleshooting is required. * Hands-on production experience with EDB Postgres, EFM, Barman, PEM, and TPA, along with PostgreSQL monitoring using Prometheus and Grafana. * Strong understanding of PostgreSQL HA design, streaming replication, failure detection, switchovers, failovers, quorum or witness concepts, split-brain prevention, and node rejoin procedures. * Demonstrated experience with backup validation, WAL archiving, retention management, point-in-time recovery, and full restore or disaster-recovery testing. * Strong knowledge of PostgreSQL internals, including WAL, MVCC, vacuum and autovacuum, checkpoints, memory management, locking, and transaction behavior. * Strong SQL performance-tuning skills, including EXPLAIN (ANALYZE, BUFFERS), index design, query-plan analysis, and diagnosis of blocking or resource contention. * Solid Linux administration and troubleshooting skills, including CPU, memory, filesystem, storage I/O, systemd services, networking, and shell scripting. * Strong hands-on experience with Ansible, Git, and GitHub, including playbooks, inventories, pull requests, peer review, conflict resolution, and version-controlled TPA configuration. * Hands-on experience configuring, administering, and troubleshooting PgBouncer. * Experience with GCP and/or AWS, including virtual machines, networking, storage, identity and access management, and cloud monitoring. * Clear written and verbal communication, disciplined documentation, sound production judgment, and willingness to participate in an on-call rotation. Ideal Candidate Profiles, Talents, and Desired Qualifications: * Experience with comparable PostgreSQL tools such as Patroni, repmgr, pgBackRest, or pgWatch. * Experience with Terraform and automation using Bash or Python. * Previous involvement in large PostgreSQL migrations, major-version upgrades, database consolidation, or hybrid on-premises/cloud environments. * Experience administering MariaDB or MySQL. * You are a practical, accountable DBA who balances availability and data protection with delivery needs. You investigate carefully, communicate risk clearly, automate repeatable work, test recovery procedures rather than assuming they work, and remain calm during production incidents. ## Description We are looking for a hands-on PostgreSQL DBA to help manage database services across our on-premises infrastructure and GCP. The role combines production operations with project work, including migration from Community PostgreSQL to EDB Postgres, high-availability standardization, database consolidation, and operational automation. You will work closely with DBAs, SRE, infrastructure, application, and security teams. We need someone who can assess the current environment, identify risks and improvements, recommend practical solutions, and follow them through to stable production operations. Here are the core functions, responsibilities, and expectations for this role: * PostgreSQL and EDB administration. Administer the full database lifecycle, including installation, configuration, patching, upgrades, capacity planning, security, monitoring, incident response, and decommissioning. * High availability with EFM. Configure, operate, monitor, and troubleshoot EDB Failover Manager clusters; perform planned switchovers and failover tests; validate application connectivity; and safely reintegrate failed or former primary nodes. * Backup and recovery with Barman. Configure and monitor base backups and WAL archiving or streaming, manage retention, execute point-in-time recovery, and conduct documented restore and disaster-recovery tests against agreed RPO and RTO targets. * Monitoring and alerting with PEM. Register and manage servers and agents, configure meaningful metrics and alert thresholds, investigate alerts and performance trends using graphs, and maintain notification and escalation integrations. * Automation and version control. Use TPA and Ansible/Spacelift to build repeatable PostgreSQL/EDB environments and maintain playbooks and configuration in Git and GitHub using branches, pull requests, and peer review. * Replication and recovery. Configure and troubleshoot physical streaming and logical replication, replication slots, WAL retention, lag, and timeline issues; use pg_rewind when appropriate to resynchronize a node after timelines diverge. * Performance engineering. Analyze execution plans and wait or lock behavior, tune SQL and indexes, and optimize PostgreSQL and operating-system settings, including autovacuum, memory, storage, and checkpoint or WAL behavior. * Connectivity and security. Operate PgBouncer and manage roles, privileges, authentication, pg_hba.conf, TLS, secrets, and least-privilege access in line with organizational standards. * Migrations and consolidation. Plan and execute major and minor version upgrades, Community PostgreSQL-to-EDB migrations, and database consolidation with validated rollback, testing, and minimal downtime. * Operational ownership. Create runbooks and architecture documentation, participate in change and incident processes, collaborate with engineering teams, and join an on-call rotation for production emergencies. * Additional tasks associated with this position may be assigned in response to company initiatives and business needs. ## Related Videos - [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search) - [Why chain abstraction is the best way to build successful web3 solutions for users](https://www.wearedevelopers.com/videos/876-why-chain-abstraction-is-the-best-way-to-build-successful-web3-solutions-for-users) - [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Branch your database like your code: How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand) - [We Gave Every Tenant a Postgres Connection String](https://www.wearedevelopers.com/videos/1951-we-gave-every-tenant-a-postgres-connection-string) ## Related Articles - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Dev Digest 168: Hacking Postgres, Blocking Meta and Fixing CSS](https://www.wearedevelopers.com/magazine/588-dev-digest-168-hacking-postgres-blocking-meta-and-fixing-css) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Effortlessly Scale Prometheus With The Telemetry Data Platform – And Keep your Grafana Dashboards, Too!](https://www.wearedevelopers.com/magazine/3-effortlessly-scale-prometheus-with-the-telemetry-data-platform-and-keep-your-grafana-dashboards-too) - [Dev Digest 121 - AI goes offline](https://www.wearedevelopers.com/magazine/456-dev-digest-121-ai-goes-offline) - [20 Essential Tools For Backend Development](https://www.wearedevelopers.com/magazine/218-20-essential-tools-for-backend-development)