Talent.com
PostgreSQL Database Administrator (DBA)

PostgreSQL Database Administrator (DBA)

Akaasa TechnologiesLake St Louis, MO, United States
job_description.job_card.variable_hours_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
  • serp_jobs.filters_job_card.quick_apply
job_description.job_card.job_description

Job Description : PostgreSQL Database Administrator (DBA)

Position Overview

We are seeking an experienced PostgreSQL Database Administrator with deep expertise in database performance tuning, backup and recovery, high availability, replication, and troubleshooting. The ideal candidate should have hands-on experience with Postgres (EDB, Open Source, or AWS Aurora Postgres) in enterprise-scale environments, with the ability to diagnose and resolve complex database issues.

Responsibilities

  • Database Administration & Performance

Monitor and troubleshoot high CPU usage, memory bottlenecks, and long-running queries.

  • Analyze query execution plans, detect sequential scans, and optimize query / index usage.
  • Rebuild and manage indexes; investigate cases where indexes are not being used.
  • Perform database tuning, parameter optimization, and query performance improvements.
  • Vacuum & Auto-Vacuum Management
  • Configure, monitor, and tune auto-vacuum parameters (thresholds, scale factor, max workers, etc.).

  • Understand and manage vacuum, vacuum full, and analyze operations.
  • Handle table / index bloat issues and minimize vacuum impact on running queries.
  • Database Upgrades & Migration
  • Support PostgreSQL version upgrades (e.g., PG 13 PG 14), ensuring query plan stability.

  • Validate and fix query execution plan changes post-upgrade.
  • Run vacuum full / analyze after migrations to ensure optimal performance.
  • High Availability & Failover
  • Configure and manage PostgreSQL failover / recovery mechanisms with tools like EDB Failover Manager (EFM) .

  • Investigate failover delays and optimize failover times.
  • Configure and manage replication (physical, logical, streaming, BDR, Aurora, etc.).
  • Ensure seamless synchronization between primary and standby clusters.
  • Backup & Recovery
  • Implement backup strategies including physical (pg_basebackup), logical (pg_dump / pg_restore), and point-in-time recovery (PITR).

  • Schedule and automate backups.
  • Configure BSR (Block Streaming Replication) and ensure backup integrity.
  • Restore corrupted WAL files and manage recovery.conf settings.
  • Security & Encryption
  • Implement encryption methods at rest and in transit for PostgreSQL databases.

  • Ensure compliance with organizational and industry security standards.
  • Cluster & Instance Management
  • Install, configure, and manage multiple PostgreSQL instances on a single server.

  • Troubleshoot cluster installation issues and handle cases of shared data directories.
  • Manage pg_resetwal operations and database restart issues.
  • Cloud & Aurora PostgreSQL
  • Work with AWS Aurora PostgreSQL , understanding its replication model and optimizations.

  • Compare and leverage Aurora's replication vs. traditional BDR methods.
  • Required Skills & Experience

  • 5+ years of hands-on experience as a PostgreSQL DBA / Engineer .
  • Strong expertise in performance tuning, query optimization, and execution plans .
  • Deep understanding of vacuum processes, autovacuum tuning, and index management .
  • Experience with backup & recovery strategies including PITR, pg_basebackup, WAL management.
  • Proficiency in replication, failover, and high availability configurations .
  • Hands-on experience with PostgreSQL upgrades and migrations .
  • Strong knowledge of B-tree, BRIN, and other indexing methods .
  • Familiarity with AWS RDS / Aurora PostgreSQL and replication differences.
  • Good troubleshooting skills with ability to handle production incidents.
  • Preferred Qualifications

  • Experience with EDB Postgres Advanced Server .
  • Knowledge of Linux system administration for database environments.
  • Experience in automation (Shell, Python, Ansible, Terraform) for DBA tasks.
  • Prior exposure to large-scale, mission-critical production environments .
  • Strong problem-solving skills; ability to identify and prevent production risks.
  • serp_jobs.job_alerts.create_a_job

    Dba • Lake St Louis, MO, United States

    Job_description.internal_linking.related_jobs
    SQL Database Administrator

    SQL Database Administrator

    Perceptive Recruiting, LLCBridgeton, Missouri, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Hybrid Senior Database Administrator opportunity with an enterprise organization in St Louis, MO.In this role you will ensure the performance, reliability, and security of critical SQL Server datab...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.new
    IT Data Engineer (Entry)

    IT Data Engineer (Entry)

    TekWissen LLCChesterfield, MO, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Overview : TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutio...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Vice President, Data & AI

    Vice President, Data & AI

    MastercardO Fallon, MO, US
    serp_jobs.job_card.full_time +1
    Vice President, Data & AI Overview.Mastercard powers economies and empowers people in 200+ countries and territories worldwide. Together with our customers, we're helping build a sustainable economy...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Encompass Administrator

    Encompass Administrator

    Flat Branch Home Loans IncChesterfield, MO, US
    serp_jobs.job_card.full_time
    Provide Encompass and mortgage software support to all internal teams including handling questions related to all applicable systems. Complete assigned project work related to Encompass and other mo...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    Software Engineer Integrations

    Software Engineer Integrations

    SahlSmart Village
    serp_jobs.job_card.full_time
    Sahl is expanding its suite of consumer services, and we are looking for a Junior Software Engineer – Integrations to join our team. This role is perfect for early-career engineers who are eager to ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Field Energy Solution Specialist (Hiring Immediately)

    Field Energy Solution Specialist (Hiring Immediately)

    CLAE SOLUTIONSOld Jamestown, Missouri, US
    serp_jobs.job_card.part_time
    Clae Goldman Team is seeking a proactive and results-driven Field Sales Representative to join our team.Our mission is to protect customers from rising energy costs, offer discounts, and promote gr...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Director Business Intelligence

    Director Business Intelligence

    AcostaChesterfield, MO, US
    serp_jobs.job_card.full_time
    Director of Business Intelligence.As the Director of Business Intelligence, you will lead a high-impact team focused on delivering data-driven insights and strategic solutions that drive business p...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Senior Analyst, Financial Planning and Analysis

    Senior Analyst, Financial Planning and Analysis

    MastercardO Fallon, MO, US
    serp_jobs.job_card.full_time +1
    Senior Analyst, Financial Planning and Analysis.Mastercard's Global Business Solutions Center (GBSC) is dedicated to helping the organization transform their business operations to achieve higher e...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    AVP, Data Strategy and Enablement

    AVP, Data Strategy and Enablement

    W.R. BerkleyChesterfield, MO, US
    serp_jobs.job_card.full_time
    AVP Of Data Strategy And Enablement.The AVP of Data Strategy and Enablement drives the segment's data and analytics strategy in close collaboration with senior leadership.This role ensures strategi...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Full Stack Software Developer

    Full Stack Software Developer

    LeidosColumbia, IL, US
    serp_jobs.job_card.full_time
    The Leidos FS2 Aero team has an opening for an experienced Full Stack Software Developer r to modify existing code and integrate software solutions for the Aeronautical Navigation Office.The ideal ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.new
    ITCD Specialist

    ITCD Specialist

    Compass Health NetworkUSA, Missouri, Wentzville
    serp_jobs.job_card.full_time
    The ITCD specialist is responsible for providing specialized services for the treatment of co-occurring substance use and mental illness to individuals enrolled in the Community Psychiatric Rehabil...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    SQL Database Administrator

    SQL Database Administrator

    iBrain Technologies, IncSaint Louis, MO, US
    serp_jobs.job_card.full_time
    DBA is responsible for supporting SQL server databases and ensuring their performance, availability, and security within both the production and development environments. PRINCIPAL RESPONSIBILITIES ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    Cassandra Database Engineer

    Cassandra Database Engineer

    OmegaHiresSt. Louis, MO, US
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Cassandra Database Engineer Location : St.Louis, MO (Hybrid (3 days from client office per week) JD : .Deep understanding of Cassandra internals, including repair mechanisms.Proficiency in NoSQL...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    Database Architect

    Database Architect

    Stellar IT Solutions LLCSaint Louis, MO, Missouri, USA
    serp_jobs.job_card.temporary
    Job Title : Database Architect Location : St.Louis, MO (Onsite) Job Type : Long-term Contractserp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Manager- IT Enterprise Analytics

    Manager- IT Enterprise Analytics

    Midland States Bank CareersWeldon Spring, MO, United States
    serp_jobs.job_card.full_time
    Position Title : Manager- IT Enterprise Analytics.Req ID : JR1204-Weldon Spring_MO.At Midland, we’re proud to be a little different. You can see it in our bright orange signs-but there’s more to it th...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Exploitation Specialist / Data Scientist - Senior

    Exploitation Specialist / Data Scientist - Senior

    LeidosFenton, MO, US
    serp_jobs.job_card.full_time
    Leidos is actively hiring for an Exploitation Specialist / Data Scientist (Senior) to join our team in St.This work requires staff to perform deep data investigations on complex problems using applie...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Manager- IT Enterprise Analytics

    Manager- IT Enterprise Analytics

    Midland States BankWeldon Spring, Missouri, US
    serp_jobs.job_card.full_time
    Position Title : Manager- IT Enterprise Analytics Locations : Weldon Spring_MO Time Type : Full time Req ID : JR1204-Weldon Spring_MO At Midland, we're proud to be a little different.You can see it...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Data Operations Internship (Summer 2026)

    Data Operations Internship (Summer 2026)

    Vertiv HoldingsSaint Louis, MO, US
    serp_jobs.job_card.internship
    We are seeking a proactive and detail-oriented individual to join our Operations team as an Operations Intern.This internship offers exposure to various facets of operations management and provides...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30