Lead PostgreSQL Database Administrator
Green Dot
Senior PostgreSQL DBA We're looking for talented professionals to join us in bringing smart money management and payment solutions to everyone's fingertips. This position is classified as structured hybrid, with an expectation of three (3) days per week working in the office and flexibility to work remotely on the remaining days. On-site expectations may evolve over time to support business needs, with clear communication provided in advance. Location Requirement This position is open only to candidates who currently reside in one of the following approved locations: West Los Angeles, CA The Senior PostgreSQL DBA owns the design, availability, performance, and security of our production PostgreSQL estate hosted in Microsoft Azure. The role covers both Azure Database for PostgreSQL (flexible server) and self-managed PostgreSQL on Azure virtual machines running Red Hat Enterprise Linux, CentOS Stream, and Windows Server. This is a hands-on senior engineering role, not a supervisory one. The DBA is the final escalation point for database incidents, the architect of our high-availability and disaster-recovery topology (active-passive and active-active), and the person who keeps us current on PostgreSQL 17, 18, and the upcoming 19 release. Key responsibilities Duties marked critical are the core of the role; a candidate who cannot demonstrate them should not advance past the technical screen. 1. High availability and disaster recovery (critical) Active-passive (primary/standby): Design, deploy, and operate zone-redundant high availability on Azure Database for PostgreSQL flexible server: synchronous standby in a second availability zone, automatic failover in 60–120 seconds with zero data loss, and the 99.99% uptime SLA that configuration carries. Decide between zone-redundant and same-zone (zonal) HA per workload based on latency tolerance and zone-failure risk, and document the trade-off. Run and document planned, unplanned, and forced failover tests at least quarterly; measure downtime from the application side, not from the service side. Size max_replication_slots and max_wal_senders correctly (four reserved for HA plus one per read replica and per logical slot) so failovers never fail for lack of slots. Build equivalent active-passive clusters on self-managed Azure VMs using streaming replication with Patroni and etcd (Linux) or a supported cluster manager on Windows, fronted by HAProxy, PgBouncer, or an Azure internal load balancer. Design cross-region disaster recovery: geo-redundant backups, cross-region read replicas, and promotion runbooks with tested RPO/RTO targets. Preserve logical replication across failover: pg_failover_slots on PostgreSQL 16 and earlier, native sync_replication_slots = on with hot_standby_feedback = on on PostgreSQL 17 and later. Active-active (bi-directional / multi-master): Design and operate active-active topologies across Azure regions using the pglogical extension or native logical replication, following Microsoft's published bi-directional replication guidance for Azure Database for PostgreSQL. Define and enforce conflict-avoidance and conflict-resolution strategy: partitioned write ownership, non-overlapping sequence ranges or UUIDv7 keys, last-writer-wins rules where appropriate, and monitoring for conflict counts. Manage DDL propagation across nodes (pglogical.replicate_ddl_command() or controlled DDL rollout for native replication) and sequence synchronization (PostgreSQL 19 adds native sequence replication via ALL SEQUENCES and REFRESH SEQUENCES). Monitor replication lag, slot retention, and retain_dead_tuples settings on every node; alert before WAL retention threatens primary disk. Own the decision of when active-active is and is not appropriate, and push back on it where a well-run active-passive design meets the requirement at lower risk. 2. Azure platform administration (critical) Provision and manage Azure Database for PostgreSQL flexible server via the portal, Azure CLI, Az.PostgreSQLFlexibleServer PowerShell module, ARM/Bicep, Terraform, and REST API. Configure networking: VNet integration, private endpoints, private DNS zones, firewall rules, and migration from VNet-injected to private-endpoint servers (now supported for HA-enabled servers). Implement Microsoft Entra ID authentication, Entra group login, managed identities, customer-managed keys (including cross-tenant CMK), and SCRAM-SHA-256 as the password default. Manage compute and storage tiers, including Premium SSD v2 (GA with HA, read replicas, geo-DR, and major version upgrade support) and online storage scaling. Operate built-in PgBouncer (currently 1.25.x) for connection pooling and tune pool modes per application. Run in-place major version upgrades on flexible server (PostgreSQL 18 upgrade GA June 2026), including pre-upgrade extension and large-object checks. Manage read replicas (in-region, cross-region, cascading), promote them when required, and keep replica lag within SLA. Configure backup retention, long-term retention via Azure Backup, point-in-time restore, and recovery of deleted servers; test restores on a schedule. Evaluate and deploy elastic clusters (sharded flexible server) for horizontally scaled workloads where appropriate. Set custom maintenance windows and coordinate Azure-initiated minor version patching with application owners. 3. Self-managed PostgreSQL on Linux and Windows (critical) Install, patch, and tune PostgreSQL 15–19 on RHEL 8/9, CentOS Stream, and Windows Server 2019/2022 running as Azure VMs. On Linux: manage systemd units, SELinux contexts, firewalld, LVM/managed-disk layout, kernel and huge-page settings, and PGDG repository packaging. On Windows: manage the PostgreSQL service, NTFS permissions, Windows Firewall, scheduled tasks for maintenance, and Windows-specific installer and upgrade behavior. Operate backup tooling: pgBackRest or Barman on Linux, pg_basebackup and WAL archiving to Azure Blob Storage on both platforms, with incremental backups where supported. 4. Performance engineering Diagnose and tune queries using EXPLAIN (ANALYZE, BUFFERS, WAL, IO), pg_stat_statements, auto_explain, and Azure Query Performance Insight. Tune autovacuum per table, including PostgreSQL 19 parallel autovacuum (autovacuum_max_parallel_workers) and the new prioritization scoring, and prevent transaction-ID wraparound. Reclaim bloat without downtime using REPACK (CONCURRENTLY) on PostgreSQL 19, pg_repack on earlier versions, and VACUUM FULL only as a last resort. Tune asynchronous I/O (io_method, worker counts) introduced in PostgreSQL 18, memory parameters, checkpointing, and WAL compression. Design partitioning, indexing (B-tree, BRIN, GIN, GiST, skip-scan on PostgreSQL 18), and extended statistics strategies. Use pg_plan_advice and pg_stash_advice on PostgreSQL 19 to stabilize problem plans without permanent hints. 5. Security and compliance Enforce least-privilege roles, row-level security, and predefined roles (pg_read_all_data, pg_write_all_data); retire MD5 passwords before PostgreSQL 19 begins warning on them. Manage TLS, SNI (new in PostgreSQL 19), certificate rotation, and encryption at rest with customer-managed keys. Produce audit evidence with pgaudit and Azure Monitor diagnostic logs for SOC 2, HIPAA, or PCI as required. Respond to CVEs within the patching SLA and track Azure-applied minor version patches. 6. Monitoring and incident response Build dashboards and alerts in Azure Monitor, Log Analytics, and the Azure HA health status monitor; supplement with Prometheus/Grafana or Datadog for VM-hosted clusters. Instrument the new PostgreSQL 19 views (pg_stat_recovery, pg_stat_lock, pg_stat_autovacuum_scores) and the per-process-type log_min_messages. Green Dot
$160k - $180k
...Database Administrator Versana is seeking a Database Administrator to partner closely with our... ...operational excellence across Azure-managed PostgreSQL and Oracle environments—tuning SQL and... ...participating in an on-call rotation, leading incident triage, and writing...Postgresql- ...Database Administrator (DBA)Our direct client based in NYC (midtown) is seeking a full-time DBA to manage PostgreSQL and MSSQL databases. This is an urgent client need with immediate interviews for qualified candidates.Salary range: $125,000 - $140,000 per yearBenefits...PostgresqlFull timeImmediate start
$100k - $175k
...Database Administrator OptionMetrics, headquartered in New York, NY, is a dynamic and innovative technology company, a trusted provider of... ...Administrator with a strong background in managing MSSQL and PostgreSQL databases. The ideal candidate will have expertise in...PostgresqlWork at officeRemote work- ...Senior Database Administrator Employment Type: Full-Time, Mid Level Contact Government Services is seeking a Senior Database Administrator... ...data warehouses. Experience with AWS RDS for PostgreSQL. Experience with working in cloud environments such as Azure...PostgresqlFull timeFlexible hours
- ...the world ROLE DESCRIPTION As a Senior Database Administrator, you will be the primary stakeholder... ...database engines, specifically CloudSQL/PostgreSQL and MongoDB. Experience with MSSQL and... ...: Have the steady hand required to lead complex data migrations and schema changes...PostgresqlPermanent employmentRemote workWorldwide
- Senior Database Administrator - Work From Home We are seeking a talented and self-motivated Senior... ...routines. Work with company technical leads and development teams to create and execute... ...with Linux in conjunction with PostgreSQL and MySQL is a plus. Experience with a...PostgresqlRemote workWork from home
- ...defining, supporting, securing, and administering SQL Server databases to ensure optimal performance and availability. You will perform... ...: MS SQL SQL Server SQL Cluster Environments Maria DB MySQL PostgreSQL Oracle MS Access Experience creating and managing standalone...Postgresql
- ...brief 1 minute video about us, you can check Designation: Lead Quality Analyst Location: Irving, TX (Onsite)/ NY Job Type... ..., SoapUI, Karate DSF JMeter, LoadRunner JIRA, Zephyr SQL (MySQL, PostgreSQL, Oracle) OWASP ZAP Cucumber, SpecFlow...PostgresqlFull time
- Senior ASE Database Administrator BayNova is seeking an experienced and highly motivated Senior ASE Database Administrator to join our team in... ..., troubleshooting, data manipulation/backups of ASE and PostgreSQL database infrastructure Working with large amounts of data...Postgresql
$115k - $135k
Data Administrator We are looking for seasoned Data Administrator to work... ...for a more than just a "Database Administrator", but a technologist... ...solving. Contributions Lead and architect migration of data... ...such as Oracle, SQL Server, PostgreSQL, and others. Experience with...PostgresqlFor contractors- Job Description: Database Administrator (Remote- Top Secret Clearance) San Diego Description Please... ...and change control procedures. Lead database upgrades and migrations. Automate... .... Expertise in SQL Server, Oracle, or PostgreSQL. Experience with cloud-based DB solutions...PostgresqlRemote jobContract workImmediate start
$100.9k - $121.1k
...Court System is seeking qualified candidates for a full-time Database Administrator. If you have experience updating, supporting and... ...DevOps methodologies and tools. Preferred: 1) Experience with PostGreSQL in an enterprise environment. 2) Experience with Ansible....PostgresqlFull timeWork at officeRemote workVisa sponsorshipWork visa- ...FastAPI, Django AI Tooling: Familiarity with LangChain, LlamaIndex, or similar frameworks for agentic workflows. Databases: Strong knowledge of SQL (PostgreSQL) and NoSQL (Redis, MongoDB), plus experience with Vector Databases (Pinecone, Weaviate). Infrastructure:...Postgresql
- Practice Lead: AWSThe Practice Lead for AWS is a hands-on leader dedicated to helping... ...customers get the most out of open-source databases running on AWS and the broader AWS... ...database technologies, including MySQL, PostgreSQL, MariaDB and Valkey, with experience helping...PostgresqlWork at officeRemote workFlexible hours
- ...Management System, by Central Square) system. This person will lead and manage this project at a technical level. The migration is... ...premise, our client has complete access to both versions of the databases via SQL Server Management Studio. Requirements: SQL Server DBA...Contract workRemote work
- Responsibilities: Install, configure, administer, monitor, and maintain PostgreSQL databases across development, test, and production environments.... .... Requirements 5-7 years of hands-on PostgreSQL database administration experience in enterprise environments. Strong expertise in...PostgresqlRemote job
- ...Job Description Job Description Lead Clinical Automation & AI Systems Engineer Department: Clinical Operations & Technology... ..., GraphQL) , event-driven systems, and modern relational databases (PostgreSQL/SQL). Healthcare workflows & PHI: Demonstrated knowledge...PostgresqlRemote workDay shift
- ..., development, implementation, administration, governance, and maintenance of the firm’s databases and data platforms Support cloud... ...Fabric, Snowflake, and PostgreSQL Position Details Location... ...performance, availability, and cost Lead initiatives to improve...PostgresqlHourly payVisa sponsorshipWeekend work
- Senior Database Administrator This position is for a senior individual contributor who owns reliability... ...on-prem), Azure SQL, AWS Aurora MySQL/PostgreSQL, RDS, DynamoDB, the Snowflake... ...data virtualization platform. This role leads complex migration and modernization projects...Postgresql
- Postgres DBA We are seeking qualified Database Engineer / Administrator is responsible for independently analyzing database performance characteristics... ..., Purging and Archiving solutions in the Azure PostgreSQL ecosystem. Azure CLI and/or PowerShell. Writing PostgresSQL...Postgresql
- ...SQL Server DBA with strong hands-on experience in SQL Server administration, engineering, and production support. The candidate will be responsible... ...-critical SQL Server environments, performance tuning, database maintenance, troubleshooting, automation, and High...Contract work
- Database Administrator Essential Job Functions Manage team of Database Administrators responsible for... ...enterprise database environments. Lead operational support for multiple database... ...Microsoft SQL Server, Oracle, MySQL, PostgreSQL, and cloud-native database platforms....PostgresqlWork experience placementWork at office
$128.84k - $232.2k
...you. WHAT YOU’LL DO The MongoDB Database Administrator ( DBA ) role is part of the Platform Engineering... ..., partner cross-functionally, and lead incident response Growth-oriented —... ...with other database platforms (e.g., PostgreSQL, MySQL , DynamoDB) Familiarity...PostgresqlWork at officeLocal areaFlexible hours- ...Senior SQL Server Database Administrator (Senior DBA)Location: New York, NY (4 Irving Place)Work Arrangement: 100% Onsite – 5 Days a WeekInterview: Video followed by mandatory in-person interviewJob DescriptionSeeking an experienced Senior SQL Server DBA with strong hands...
- Senior SQL Server Database Administrator (DBA) Contract Length: 1 Year Location: New York City, NY Work Setup: On-site Senior SQL Server DBA Job Summary We are seeking an experienced Senior SQL Server DBA for a 1-year on...Contract work
- ...team to plan, design, build, deploy and maintain SQL Server databases. Provide technical and operational support to other departments... ...software including third party tools Provide basic database administration activities such as backup, recovery, monitoring and management...
$75 - $85 per hour
Job Title Database Administrator / Database Engineer (SQL Server) Pay $75-$85/hr. Location New York, NY (Remote / 100% Remote) Summary Join a stable, enterprise environment supporting mission-critical database platforms across the organization. This role...Remote work- ...development role. Key Responsibilities Work with Ruby on Rails using object-oriented and MVC fundamentals. Work with relational databases such as PostgreSQL or MySQL. Qualifications Ruby on Rails fundamentals, including object-oriented programming and MVC architecture. Basic...PostgresqlRemote work
$70 - $72 per hour
...Experience: 8+ years overall, with strong hands-on SQL Server administration and production support experience Summary: A support-... ...maintains and supports new and existing SQL Server (or equivalent) databases and the Windows servers they run on across internal networks....Hourly payContract work- Contract Based Advanced Database Administrator Role: Advanced Database Administrator Location: Nashville, Tennessee (Remote) Client: State of TN Skills Needed: MySQL, Oracle, SQL Server, Performance Tuning, Design, Security, Database Administration, Implement, AWS RDS,...Contract workRemote work
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Lead PostgreSQL Database Administrator. Be the first to apply!
- database assistant New York, NY
- database manager New York, NY
- data administrator New York, NY
- remote dba New York, NY
- remote database administrator New York, NY
- dba New York, NY
- senior database administrator New York, NY
- database administrator New York, NY
- postgresql developer New York, NY
- database coordinator New York, NY






