PostgreSQL Database Administrator (DBA)
Akaasa TechnologiesLake St Louis, MO, United States7 hours ago
Job type
- Full-time
- Quick Apply
Job descriptionAnalyze 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 Understand and manage vacuum, vacuum full, and analyze operations. Handle table / index bloat issues and minimize vacuum impact on running queries. Database Upgrades & Migration Validate and fix query execution plan changes post-upgrade. Run vacuum full / analyze after migrations to ensure optimal performance. High Availability & Failover 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 Schedule and automate backups. Configure BSR (Block Streaming Replication) and ensure backup integrity. Restore corrupted WAL files and manage recovery.conf settings. Security & Encryption Ensure compliance with organizational and industry security standards. Cluster & Instance Management Troubleshoot cluster installation issues and handle cases of shared data directories. Manage pg_resetwal operations and database restart issues. Cloud & Aurora PostgreSQL Compare and leverage Aurora's replication vs. traditional BDR methods. 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. 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.
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.
Configure, monitor, and tune auto-vacuum parameters (thresholds, scale factor, max workers, etc.).
Support PostgreSQL version upgrades (e.g., PG 13 PG 14), ensuring query plan stability.
Configure and manage PostgreSQL failover / recovery mechanisms with tools like EDB Failover Manager (EFM) .
Implement backup strategies including physical (pg_basebackup), logical (pg_dump / pg_restore), and point-in-time recovery (PITR).
Implement encryption methods at rest and in transit for PostgreSQL databases.
Install, configure, and manage multiple PostgreSQL instances on a single server.
Work with AWS Aurora PostgreSQL , understanding its replication model and optimizations.
Required Skills & Experience
Preferred Qualifications
Create a job alert for this search
Dba • Lake St Louis, MO, United States
Related jobs
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...Show moreLast updated: 30+ days ago
Overview : TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutio...Show moreLast updated: 1 hour ago
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...Show moreLast updated: 5 days ago
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...Show moreLast updated: 21 hours ago
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 ...Show moreLast updated: 30+ days ago
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...Show moreLast updated: 30+ days ago
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...Show moreLast updated: 13 days ago 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...Show moreLast updated: 18 days ago 
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...Show moreLast updated: 30+ days ago
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 ...Show moreLast updated: 30+ days ago
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...Show moreLast updated: 7 hours ago
DBA is responsible for supporting SQL server databases and ensuring their performance, availability, and security within both the production and development environments.
PRINCIPAL RESPONSIBILITIES ...Show moreLast updated: 3 days ago
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...Show moreLast updated: 7 days ago
Job Title : Database Architect Location : St.Louis, MO (Onsite) Job Type : Long-term ContractShow moreLast updated: 30+ days ago
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...Show moreLast updated: 3 days ago 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...Show moreLast updated: 30+ days ago 
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...Show moreLast updated: 4 hours ago
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...Show moreLast updated: 30+ days ago
SQL Database Administrator
Perceptive Recruiting, LLCBridgeton, Missouri, United StatesFull-time
Quick Apply
- New!
IT Data Engineer (Entry)
TekWissen LLCChesterfield, MO, United StatesFull-time
Quick Apply
- Promoted
Vice President, Data & AI
MastercardO Fallon, MO, USFull-time +1
- Promoted
- New!
Encompass Administrator
Flat Branch Home Loans IncChesterfield, MO, USFull-time
Software Engineer Integrations
SahlSmart VillageFull-time
- Promoted
Field Energy Solution Specialist (Hiring Immediately)
CLAE SOLUTIONSOld Jamestown, Missouri, USPart-time
- Promoted
Director Business Intelligence
AcostaChesterfield, MO, USFull-time
- Promoted
Senior Analyst, Financial Planning and Analysis
MastercardO Fallon, MO, USFull-time +1
- Promoted
AVP, Data Strategy and Enablement
W.R. BerkleyChesterfield, MO, USFull-time
- Promoted
Full Stack Software Developer
LeidosColumbia, IL, USFull-time
- New!
ITCD Specialist
Compass Health NetworkUSA, Missouri, WentzvilleFull-time
- Promoted
SQL Database Administrator
iBrain Technologies, IncSaint Louis, MO, USFull-time
Cassandra Database Engineer
OmegaHiresSt. Louis, MO, USFull-time
Quick Apply
Database Architect
Stellar IT Solutions LLCSaint Louis, MO, Missouri, USATemporary
- Promoted
Manager- IT Enterprise Analytics
Midland States Bank CareersWeldon Spring, MO, United StatesFull-time
- Promoted
Exploitation Specialist / Data Scientist - Senior
LeidosFenton, MO, USFull-time
- Promoted
- New!
Manager- IT Enterprise Analytics
Midland States BankWeldon Spring, Missouri, USFull-time
- Promoted
Data Operations Internship (Summer 2026)
Vertiv HoldingsSaint Louis, MO, USInternship