Lead PostgreSQL Database Administrator
$109.3k - $163.9kGreen Dot
Were looking for talented professionals to join us in bringing smart money management and payment solutions to everyones 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.
<<>><<>><<>><<>><<>><<>><<>><<>><<>><<>>
JOB DESCRIPTION
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 60120 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 maxreplicationslots and maxwalsenders 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: pgfailoverslots on PostgreSQL 16 and earlier native syncreplicationslots on with hotstandbyfeedback 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 Microsofts 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 (() 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 retaindeadtuples 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 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 1519 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 pgbasebackup 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) pgstatstatements autoexplain and Azure Query Performance Insight.
- Tune autovacuum per table including PostgreSQL 19 parallel autovacuum (autovacuummaxparallelworkers) and the new prioritization scoring and prevent transaction-ID wraparound.
- Reclaim bloat without downtime using REPACK (CONCURRENTLY) on PostgreSQL 19 pgrepack on earlier versions and VACUUM FULL only as a last resort.
- Tune asynchronous I/O (iomethod 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 pgplanadvice and pgstashadvice on PostgreSQL 19 to stabilize problem plans without permanent hints.
5. Security and compliance
- Enforce least-privilege roles row-level security and predefined roles (pgreadalldata pgwritealldata); 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 (pgstatrecovery pgstatlock pgstatautovacuumscores) and the per-process-type logminmessages.
- Lead Sev-1 database incidents write blameless post-mortems and drive the resulting fixes to closure.
7. Migrations and upgrades
- Plan and execute migrations into Azure from on-premises or other clouds using Azure Database Migration Service pgdump/pgrestore logical replication or pgcreatesubscriber.
- Lead major version upgrades on both flexible server and VMs with rollback plans and application regression testing.
- Replace deprecated features ahead of removal: MD5 auth RADIUS (removed in 19) standardconformingstrings off.
8. Automation and engineering practice
- Keep all database infrastructure in code (Terraform Bicep Ansible PowerShell) with CI-tested changes.
- Write runbooks for every failover restore and upgrade procedure and keep them current.
- Mentor junior DBAs and developers on PostgreSQL best practices and review schema changes in pull requests.
Required qualifications
All items in this section are must-haves. Azure hosting experience is non-negotiable: candidates whose PostgreSQL experience is only on-premises or on another cloud will not be considered.
Experience
- 7 years administering PostgreSQL in production with at least 3 years on PostgreSQL 14 or later.
- 3 years hosting and operating PostgreSQL in Microsoft Azure including at least 2 years on Azure Database for PostgreSQL flexible server (not Single Server which was retired in March 2025).
- Demonstrated ownership of a production active-passive HA cluster including at least one real (not test) failover.
- Demonstrated design or operation of a production active-active / bi-directional replication topology with a clear explanation of how conflicts were avoided or resolved.
- Administered PostgreSQL on both Linux (RHEL or CentOS) and Windows Server in production.
Azure
- Azure Database for PostgreSQL flexible server: HA modes read replicas PITR and geo-restore major version upgrade server parameters extensions allow-list PgBouncer maintenance windows.
- Azure networking for databases: VNet integration private endpoints private DNS NSGs.
- Microsoft Entra ID authentication for PostgreSQL and managed identities.
- Azure Monitor Log Analytics (KQL) and Azure Advisor for PostgreSQL.
- Infrastructure as code for Azure: Terraform or Bicep plus Azure CLI and PowerShell.
PostgreSQL
- Streaming replication replication slots logical replication (publications and subscriptions) and pglogical.
- Patroni or an equivalent cluster manager; etcd or Consul; HAProxy or PgBouncer.
- Backup and recovery with pgBackRest or Barman WAL archiving to object storage and incremental backups.
- Deep query tuning: reading execution plans index design statistics partitioning autovacuum tuning and bloat management.
- Major version upgrades via pgupgrade logical replication and pgcreatesubscriber.
- Working knowledge of PostgreSQL 18 features (asynchronous I/O UUIDv7 virtual generated columns temporal constraints OAuth data checksums on by default) and awareness of what changes in PostgreSQL 19.
Operating systems and tooling
- RHEL/CentOS: systemd SELinux LVM package management from the PGDG repository shell scripting (bash).
- Windows Server: service management NTFS permissions PowerShell scripting Windows-specific PostgreSQL installation and upgrade behavior.
- Git-based workflows CI/CD pipelines and configuration management (Ansible preferred).
Professional
- Experience leading Sev-1 incident response and writing post-mortems.
- Clear written communication: runbooks architecture decision records and change requests that non-DBAs can follow.
- Ability to participate in a 24x7 on-call rotation.
Preferred qualifications
None of these are required but each one strengthens a candidates case.
- Microsoft Certified: Azure Database Administrator Associate (DP-300) or Azure Solutions Architect Expert (AZ-305).
- Red Hat Certified System Administrator (RHCSA) or equivalent Linux certification.
- Hands-on testing of PostgreSQL 19 betas or release candidates especially REPACK CONCURRENTLY parallel autovacuum WAIT FOR LSN and sequence replication.
- Experience with Azure Database for PostgreSQL elastic clusters (Citus-based sharding) or with Citus on self-managed clusters.
- Experience with EDB Postgres Distributed pgEdge or another commercial multi-master product with a clear view of what native tooling can and cannot replace.
- Experience with Azure Database Migration Service for online migrations from Oracle SQL Server or other PostgreSQL sources.
- Experience operating pgvector pgdiskann or Apache AGE on flexible server for AI or graph workloads.
- Kubernetes-hosted PostgreSQL on AKS using CloudNativePG Crunchy Postgres Operator or Zalando Postgres Operator.
- Contributions to the PostgreSQL community: patches extensions conference talks or documentation.
- Familiarity with Oracle SQL Server or MySQL for cross-platform migration work.
- Security and compliance background: SOC 2 HIPAA PCI DSS or FedRAMP audits involving database controls.
**Ability to work in the U.S. without sponsorship**
**Ability to meet the location requirement outlined above**
POSITION TYPE
ContractorPAY RANGE
The targeted full-time base salary for this position is $109300 to $163900 per year. The final compensation will be determined by a number of factors such as qualifications expertise and the candidates geographical location.
<<>><<>><<>><<>><<>><<>><<>><<>><<>><<>>
Were Here to Support YouAccommodations Upon Request
Green Dot is committed to providing an inclusive and accessible hiring experience for all candidates. If you require a reasonable accommodation during any part of the application or interview process we encourage you to let us know. We will work with you to meet your needs in a way that respects your privacy and ensures equal opportunity. Our goal is to support every applicant in showcasing their talents and potential.
Work Authorization Requirement
At Green Dot Corporation we value diversity and strive for fair and inclusive hiring practices. However we are currently unable to offer visa sponsorship. All applicants must be legally authorized to work in the United States at the time of application and throughout the duration of employment without the need for current or future sponsorship.
Important Notice on Application Accuracy
We value integrity in our hiring process. Please ensure that all information provided in your resume and application is accurate and authentic. Submissions found to be fraudulent or misleading will result in disqualification from consideration and any offers extended may be rescinded.
Required Experience:
Unclear Seniority
- Job Description Seeking a hands-on DBA/Database Engineer to administer PostgreSQL and Oracle databases across AWS and on-prem environments. The primary... ...Production Oracle DBA experience AWS database administration On-prem Oracle administration Database performance tuning...Postgresql
- Senior Database Administrator II Employment Type: Full-Time, Mid Level Department: Information Technology Contact Government Services is seeking... ...maintaining data warehouses. - Experience with AWS RDS for PostgreSQL. - Experience with working in cloud environments such as...PostgresqlFull timeFlexible hours
- Position: PostgreSQL DBA Architect Location: Pasadena, CA (Only Locals... ...Key Responsibilities: Database Architecture & Design: Architect... ...database architecture and administration. Database Administration &... ...Migration & Cloud Integration: Lead complex database migration...PostgresqlContract workLocal area
- Senior PostgreSQL DBA Blackstone Talent Group, an award-winning technology... ...high availability on Azure Database for PostgreSQL flexible... ...risk. 2. Azure platform administration (critical) Provision and manage... ...process-type log_min_messages. Lead Sev-1 database incidents,...PostgresqlPermanent employmentFlexible hours
- ...Job Description Position Details: Job title: SQL Server Database Administrator Duration: 12-month contract Location: Remote, Downey... ...conversions and migrations of Client SQL, MySQL, and PostgreSQL databases between on premise data centers and Azure, Amazon...PostgresqlContract workRemote work
$95k - $120k
...developing the technologies to make this possible, with the ultimate goal of enabling human life on Mars.DATABASE ADMINISTRATORSpaceX is looking for a Database Administrator with strong technical knowledge in Microsoft SQL/ PowerBI technologies as well as excellent...Permanent employmentTemporary workRemote workFlexible hoursWeekend work$55 per hour
...Senior PostgreSQL DBA Location: West Los Angeles, CA Local... ...performance, security, and administration of its production PostgreSQL... ...requiring strong expertise in Azure Database for PostgreSQL Flexible... ...where applicable. Lead critical database incidents,...PostgresqlContract workLocal areaFlexible hours3 days per week$75 - $80 per hour
...native development, distributed systems, containerization, and database technologies. Proven ability to work in Agile environments and... ...performance backend solutions. Work with databases such as PostgreSQL, MySQL, MongoDB, or DynamoDB. Integrate applications with...PostgresqlContract work$142.1k - $192.85k
Discovery Database Administrator Los Angeles, CA San Francisco, CA Top Secret Polygraph Unspecified Senior Level Career (10+ yrs experience) $142,100 - $192,850 Job Description Legal CGS is seeking a dedicated Discovery Database Administrator to join a fast-paced and hard...For contractorsFlexible hours$100k - $110k
...programming (OOP) principles Experience with relational databases and SQL (MySQL, PostgreSQL, or similar) Familiarity with version control systems, particularly... ...by providing IT infrastructure and software platforms. Lead by experts in the IT industry with a proven record of...PostgresqlInternship- Oracle Database Engineer - DBA (12c, OEM, EBS) The client builds software and cloud-based technologies used by many of Hollywood's... ...delivering. Experience and skills include proven Oracle Database Administration experience - minimum of 5 years, Oracle 12c Mulitenant...
- ...provider of high-performance, distributed SQL databases Industry Computer Software Type... ...kubernetes distributed sql postgresql open source and scalable About... ...is seeking a Vice President of Sales to lead a regional enterprise sales organization...Postgresql
- ...effective, scalable solutions. Create and maintain SQL‑based reports and analytics to support data accuracy and decision‑making. Lead and contribute to projects that enhance HR operations, ensuring timely delivery and alignment with compliance and business objectives...
$180k - $240k
...experience working on scalable and performant systems.Proficiency in python or c++.Experience with relational and NoSQL databases, such as PostgreSQL, MySQL, MongoDB.Familiarity with cloud platforms like AWS, Azure, or GCP.Strong knowledge of API design and development....PostgresqlWork experience placement- Database Administrator WELCOME TO SANTA MONICA COLLEGE! This critical position will perform lead, expert level professional work in administering, planning, developing, and implementing strategic data models to ensure the availability, optimum performance, accessibility...Permanent employmentFull timeTemporary workPart timeWork at officeRemote work1 day per week
- ...ensure our users and creators a high quality experience on the platform. This role will be based in Los Angeles, CA.Responsibilities:- Lead and develop a team to balance enforcement effectiveness with creator experience, minimizing unnecessary disruption to LIVE creators-...
$110.7k - $218.3k
...landscape, driving productivity, and streamlining operations for leading organizations. If you are passionate about innovation and... ...available.A Bachelor's degree in Accounting, Finance, Business Administration, Economics, Information Systems, or another related field...Local areaVisa sponsorship- ...experience with Next.js, TypeScript, and Python. Experience with PostgreSQL and Drizzle ORM and/or SQLAlchemy ORM. Strong knowledge... ...architecture. Experience working with SQL and NoSQL databases. Experience with Azure and/or Google Cloud Platform (GCP...Postgresql
$170k - $220k
...to serve front-end applications and third-party integrations.Database Management: Design and manage database schemas, ensure efficient... ...java.Experience with relational and NoSQL databases, such as PostgreSQL, MySQL, MongoDB.Familiarity with cloud platforms like AWS, Azure...PostgresqlWork experience placement$139.9k - $199.3k
...including multi step transformations Ensures database features and capabilities are... ...settlement and reconciliation frameworks Leading and coordinating the design and... ...experience with Relational DBs (MS SQL Server PostgreSQL Oracle etc.); experience with complex stored...PostgresqlFull timeWork at officeImmediate startRemote work3 days per week- ...About the Job Company Overview: GigXR is a leading provider of immersive learning solutions... ..., including front-end, back-end, and database components. Ensure data integrity and performance... ...databases (SQL Server, MySQL, PostgreSQL, MongoDB, etc.). Understanding of cloud...PostgresqlFull timeContract workRemote workFlexible hours
$132.23k - $176.31k
...ownership, deliver meaningful impact, and help shape the future of AI‑ready connectivity, join us today. The Role The Senior Lead Marketing Data Platform Architect is responsible for defining, governing, and evolving Lumen's marketing data platform architecture....Full timeTemporary work$20k
...with Python, Java, or C#Experience with containerized solutions such as Docker and KubernetesExperience with relational databases (SQL, PostgreSQL, MySQL, or Oracle) Strong skills in debugging, performance optimization, data throughput analysis, and unit testingStrong...PostgresqlPermanent employmentTemporary workImmediate startWeekend work$197.3k
General Information Job Title Lead, Full-Stack Data Scientist Job ID 112255 Work Areas Technology & Engineering... ...pipelines for modeling Working knowledge of SQL or NoSQL databases (e.g., PostgreSQL, SQL Server, Oracle, MySQL, Redis, MongoDB, Elasticsearch,...PostgresqlPermanent employmentFull timeApprenticeshipWork at officeLocal areaWork from homeHome office3 days per week$60 per hour
...Science (or a related discipline) 3+ years' experience in Microsoft Visual Studio (C#/VB.NET) 3+ years' experience in database development (SQL Server / PostgreSQL) Knowledge of Azure Function Apps a Plus Strong understanding of object-oriented programming Familiar with...PostgresqlLocal area$174.1k - $233.5k
...Networks, National Geographic and the Disney Channels; Hotstar, the leading over-the-top streaming service in India; and the Company's... ...architecture. ~ Experience with both relational (e.g., PostgreSQL/MySQL) and NoSQL data stores, along with caching layers (e.g.,...Postgresql$105.79k - $141.05k
...deliver meaningful impact, and help shape the future of AI‑ready connectivity, join us today. The Role The GTM Growth Strategy Lead develops and implements bottom-of-funnel strategies that convert targeted accounts into qualified sales opportunities. The role...Full timeTemporary work$200k - $250k
Position SummaryThe Risk Lead will direct the TCW's Portfolio Risk Management function within the Investment Risk & Quantitative Research (IRQR) department. Reporting to the Global Head of Investment Risk, this individual will oversee the identification, measurement, and...Full timeWork at officeRemote work$105.79k - $141.05k
...connectivity, join us today. The Role Lumen is expanding its product packaging. We are hiring a Consumption Pricing Monetization Lead with deep expertise in consumption-based pricing to lead the strategy and end-to-end execution for bringing Lumen products to a...Full timeContract workTemporary workRemote workFlexible hours- ...platform. You will work with our SRE team, delivery teams and lead projects related to infrastructure automation, scaling,... ...languages such as Go or Python. Familiarity with relational databases (e.g., PostgreSQL, MySQL) and non-relational databases (e.g., DynamoDB). Experience...PostgresqlFull timeWork experience placementFlexible hours
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Lead PostgreSQL Database Administrator. Be the first to apply!
- database assistant Los Angeles, CA
- database manager Los Angeles, CA
- data administrator Los Angeles, CA
- dba Los Angeles, CA
- database administrator Los Angeles, CA
- postgresql developer Los Angeles, CA
- database coordinator Los Angeles, CA
- remote database management Los Angeles, CA
- senior database analyst Los Angeles, CA
- sql database Los Angeles, CA




