Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Sr PostgreSQL DBA

Blackstone Restaurant

Senior PostgreSQL DBA Blackstone Talent Group, an award-winning technology consulting and talent agency is seeking a Sr PostgreSQL DBA to join our client's team. 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) 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 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 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, 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. 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, pg_dump/pg_restore, logical replication, or pg_createsubscriber. 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), standard_conforming_strings = 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 Blackstone Restaurant

Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Sr PostgreSQL DBA in Los Angeles, CA vacancy
  • $65 - $70 per hour

    job summary: Our client is looking for a Senior PostgreSQL DBA for a 6 month contract opportunity located in Los Angeles, CA. This position is classified as structured hybrid, with an expectation of three (3) days per week working in the office and flexibility to work... 
    Postgresql
    Senior
    Hourly pay
    Permanent employment
    Contract work
    Temporary work
    Work experience placement
    Work at office
    Local area
    Remote work
    Flexible hours
    3 days per week
    Los Angeles, CA
    14 days ago
  • Job Description Seeking a hands-on DBA/Database Engineer to administer PostgreSQL and Oracle databases across AWS and on-prem environments. The primary focus is PostgreSQL in AWS, along with database automation, monitoring, DevOps practices, and Oracle-to-PostgreSQL migration... 
    Postgresql
    Senior

    Insight Global

    Los Angeles, CA
    2 days ago
  • Position: PostgreSQL DBA Architect Location: Pasadena, CA (Only Locals) Job type: Contract Key Responsibilities: Database Architecture & Design: Architect and implement highly available, scalable, and secure PostgreSQL database solutions. Design and optimize database... 
    Postgresql
    Contract work
    Local area

    Equiliem

    Pasadena, CA
    2 days ago
  •  ...processes. Ideally, you will also have: - Experience implementing and maintaining data warehouses. - Experience with AWS RDS for PostgreSQL. - Experience with working in cloud environments such as Azure and/or AWS. - Prior professional services or federal consulting experience... 
    Postgresql
    Senior
    Full time
    Flexible hours

    Contact Government Services LLC

    Los Angeles, CA
    2 days ago
  • About the job Sr Alfresco Developer Sr. Alfresco Developer Location: Onsite Local Candidates Only (No Remote Option) - 6 month contract...  ...integration with Alfresco. -Proficient in Oracle, MySQL, or PostgreSQL databases. -Experience working with Apache Tomcat , Spring Boot... 
    Postgresql
    Senior
    Full time
    Contract work
    Local area
    Remote work
    Relocation
    Relocation package

    Global Placement Firm

    Culver City, CA
    2 days ago
  • $165k - $265k

     ...possible, with the ultimate goal of enabling human life on Mars.SR. FULL STACK SOFTWARE ENGINEER (COMPONENTS)The Components Engineering...  ...or other container and deployment toolsDatabase experience with PostgreSQL, SQL Server, or similar database technologiesCOMPENSATION AND... 
    Postgresql
    Senior
    Permanent employment
    Temporary work

    SpaceX

    Hawthorne, CA
    3 days ago
  • $165k - $265k

     ...possible, with the ultimate goal of enabling human life on Mars.SR. SOFTWARE ENGINEER (AI DATA ENGINEERING)Be a member of the Artificial...  ...internal tools and data sourcesWorking knowledge of relational (PostgreSQL), non-relational, and vector databases, with strong SQL... 
    Postgresql
    Senior
    Permanent employment
    Temporary work
    Weekend work

    SpaceX

    Hawthorne, CA
    2 days ago
  • Sr. Data Engineer Employment Type: Full-Time, Mid-level CGS is seeking a passionate and driven Data Engineer to support a rapidly growing...  ...to apply them. Experience with relational database, such as, PostgreSQL. Work comfortably in version control systems, such as, Git... 
    Postgresql
    Senior
    Full time
    Flexible hours

    Contact Government Services LLC

    Los Angeles, CA
    2 days ago
  • $165k - $265k

     ...possible, with the ultimate goal of enabling human life on Mars.SR. SOFTWARE ENGINEER, FULL STACK (DATA & VIDEO ANALYSIS)The Vehicle...  ...with the Python data stack (Pandas, NumPy, SciPy) and PostgreSQL.Experience with time-series or other signal data, including cleaning... 
    Postgresql
    Senior
    Permanent employment
    Temporary work

    SpaceX

    Hawthorne, CA
    1 day ago
  • $165k - $265k

     ...possible, with the ultimate goal of enabling human life on Mars.SR. SOFTWARE ENGINEER, NETWORK OBSERVABILITY (STARLINK)At SpaceX we...  ...comparable JavaScript framework.Experience with relational databases (PostgreSQL, CockroachDB, etc.) and/or distributed data systems.Experience... 
    Postgresql
    Senior
    Permanent employment
    Temporary work
    Worldwide
    Weekend work

    SpaceX

    Hawthorne, CA
    2 days ago
  •  ...permission control, and data security compliance are core requirements. We are looking for an experienced Bilingual (English/Mandarin) DBA expert to join us in building a stable, secure, and auditable data infrastructure. **We will sponsor a candidate for this role.**... 
    Senior
    Local area

    Jobot

    Montebello, CA
    2 days ago
  •  ...Expertise building backend systems in Node.js + TypeScript (1-2+ years) ~ Hands-on experience designing and working with SQL databases (PostgreSQL preferred) ~ Demonstrated ability to architect scalable, performant, and secure systems - not just implement within them ~... 
    Postgresql
    Senior
    Full time
    Work at office
    Flexible hours
    Shift work

    axle-health

    Santa Monica, CA
    8 days ago
  •  ...experience with C#, .NET, and backend T-SQL, along with strong database application support experience across SQL Server, Sybase, and PostgreSQL. As a Senior Support Engineer specializing in SQL within FTSE Engineering, you will lead and oversee day-to-day production... 
    Postgresql
    Senior
    Temporary work
    Flexible hours

    EPAM Systems Inc

    Los Angeles, CA
    2 days ago
  • $140k - $175k

     ...applications using serverless architectures (preferably AWS Lambda, API Gateway, and managed services). Proficiency with SQL, preferably PostgreSQL. Solid understanding of event sourcing and event-driven architecture patterns, including experience with message brokers or... 
    Postgresql
    Senior
    Full time
    Shift work

    VYNYL

    Los Angeles, CA
    2 days ago
  • $110.7k - $218.3k

     ...similar)5+ years of in-depth understanding of database platforms including relational and non-relational data engines (MS SQL, MySQL, PostgreSQL, MongoDB, Snowflake, BigQuery, Redshift, and similar)5+ years of experience with data processing (ETL) tools and methodologies3+... 
    Postgresql
    Senior
    Local area
    Visa sponsorship

    Deloitte

    Los Angeles, CA
    4 days ago
  • $184.7k - $324.8k

     ...strategiesExtensive experience building systems that integrate with distributed and high-performance data stores — Snowflake, Trino, Spark, PostgreSQL, or equivalentProficiency with Kubernetes, deployment, HPA, StatefulSets, namespace managementStrong observability practice,... 
    Postgresql
    Senior
    Relocation

    Apple

    Culver City, CA
    2 days ago
  •  ...level Python and strong SQL skills, with experience using NumPy, Pandas, Scikit-learn, TensorFlow/PyTorch, and SQL databases such as PostgreSQL or T-SQL. (R, MATLAB, C++, Java, or C# are a plus.)Deep practical expertise with tree-based algorithms and gradient boosting (... 
    Postgresql
    Senior
    16 hours
    Full time
    Local area

    CIM Group

    Los Angeles, CA
    1 day ago
  • $80k - $180k

     ...Job Description Job Description Why You're Here As a Sr. Full Stack Engineer, you'll operate with autonomy in a small, fast-moving...  ..., PartyKit, Durable Objects Database & Storage: Supabase (PostgreSQL), R2 AI Integrations: 50+ APIs (OpenAI, Anthropic, Runway,... 
    Postgresql
    Senior
    Remote work
    Relocation package
    Flexible hours

    Fuser

    Los Angeles, CA
    24 days ago
  •  ...(SSMA) and Database Migration Assistant (DMA); Competence in cross platform conversions and migrations of Client SQL, MySQL, and PostgreSQL databases between on premise data centers and Azure, Amazon Web Services (AWS), or Google Cloud Platform (GCP); Aptitude in configuring... 
    Postgresql
    Contract work
    Remote work

    Artech LLC

    Los Angeles, CA
    25 days ago
  •  ...secure software development practices. ~ Experience with databases and data platforms including MongoDB, Redis, Elasticsearch, PostgreSQL, DynamoDB, and Neptune. ~ Experience working within Agile development teams. ~ Strong written and verbal communication skills... 
    Postgresql
    Senior
    Hourly pay
    Local area

    Eliassen Group

    Burbank, CA
    7 days ago
  • $142.1k - $192.85k

     ...create reports using Microsoft SQL Server Reporting Services (SSRS); Contractor shall setup a reporting server and be responsible for all DBA functions and report development utilizing Software Systems development Architecture and Design. Our Commitment: Contact Government... 
    For contractors
    Flexible hours

    ClearanceJobs

    Los Angeles, CA
    2 days ago
  • $160k - $225k

     ...possible, with the ultimate goal of enabling human life on Mars. SR. SOFTWARE ENGINEER, COMPUTER VISION We are looking for...  ...Apache Kafka, RabbitMQ, or equivalent Database expertise in PostgreSQL or similar and data tools (Prometheus, Grafana, Jupyter) Strong... 
    Postgresql
    Senior
    Permanent employment
    Full time
    Temporary work
    Weekend work

    SpaceX

    Hawthorne, CA
    7 days ago
  •  ...transactional high performance multi-cloud hybrid cloud survivable globally distributed kubernetes distributed sql postgresql open source and scalable About the Role The Company is seeking a Vice President of Sales to lead a regional... 
    Postgresql

    Confidential

    Los Angeles, CA
    3 days ago
  • $110.7k - $218.3k

    Position Summary Today’s CFOs and financial leaders face increasing demands to enhance business performance, drive shareholder value, and optimize operational efficiency. As an Oracle Senior Consultant at Deloitte, you will help clients define their cloud strategy...
    Senior
    Local area
    Visa sponsorship

    Deloitte

    Los Angeles, CA
    4 days ago
  • $56.81 - $60.6 per hour

     ...Have Technical / Functional Skills •8 years of full-stack software development experience. •Next.js, TypeScript, Python. •PostgreSQL, Drizzle and/or SQLAlchemy ORM. •REST APIs and microservices. •SQL / NoSQL databases. •Azure and/or GCP cloud services (one... 
    Postgresql
    Senior

    Varite, Inc

    Rosemead, CA
    25 days ago
  •  ...full-stack software development experience. Strong experience with Next.js, TypeScript, and Python. Experience with PostgreSQL and Drizzle ORM and/or SQLAlchemy ORM. Strong knowledge of REST APIs and microservices architecture. Experience working... 
    Postgresql
    Senior

    Talent Software Services, Inc.

    Rosemead, CA
    25 days ago
  • $150k - $175k

     ...design and quality is embedded before code reaches production. Full Stack Validation: Validate React interfaces, GraphQL APIs, and PostgreSQL data integrity to ensure system-wide reliability. CI/CD Optimization: Architect and refine test pipelines in GitHub Actions (... 
    Postgresql
    Senior
    Contract work
    Temporary work
    Work at office
    Local area
    Remote work
    Flexible hours
    2 days per week
    3 days per week

    Renesas Electronics

    Los Angeles, CA
    8 days ago
  • $180k - $240k

     ...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.Preferred... 
    Postgresql
    Work experience placement

    HeyGen

    Los Angeles, CA
    4 days ago
  •  ...database performance. Maintain data integrity and consistency across platform services. Work with databases such as MySQL or PostgreSQL. Support integrations with NoSQL databases or analytical warehouses when required. 5. AI-Assisted Software Development... 
    Postgresql
    Senior
    Full time
    Remote work

    Veracity Ventures Inc.

    Los Angeles, CA
    a month ago
  • $139.9k - $199.3k

     ...data integration Data Quality Data Governance ~5 years of hands-on development experience with Relational DBs (MS SQL Server PostgreSQL Oracle etc.); experience with complex stored procedures and functions using SQL optimization of SSIS packages and Redshift database... 
    Postgresql
    Full time
    Work at office
    Immediate start
    Remote work
    3 days per week

    Green Dot

    Los Angeles, CA
    6 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Sr PostgreSQL DBA. Be the first to apply!