Apply on Employer Site

Apexon · 4 months ago

PostgreSQL Database Administrator

St. Louis, MO

Full-time

Onsite

Mid, Senior Level

$103K/yr - $124K/yr

5+ years exp

Apexon is seeking an experienced PostgreSQL Database Administrator with deep expertise in database performance tuning, backup and recovery, and high availability. The role involves monitoring and troubleshooting database performance, managing upgrades and migrations, and ensuring security and compliance for PostgreSQL databases.

Information Technology & Services

H1B Sponsor Likely

Responsibilities

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

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

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

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

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

Implement encryption methods at rest and in transit for PostgreSQL databases

Ensure compliance with organizational and industry security standards

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

Work with AWS Aurora PostgreSQL, understanding its replication model and optimizations

Compare and leverage Aurora’s replication vs. traditional BDR methods

Qualification

PostgreSQLexperiencePerformance tuningBackup & recoveryReplication & high availabilityQuery optimizationVacuum processesAWS Aurora PostgreSQLTroubleshooting skillsLinux system administrationAutomation ShellAutomation PythonAutomation AnsibleAutomation Terraform

Required

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

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

Benefits

401(k)

Dental insurance

Health insurance

Paid time off

Vision insurance

Company

Apexon

Glassdoor4.0

Apexon is a digital-first technology services firm, accelerating business transformation and delivering human-centric digital experiences.

Founded in 1996

Santa Clara, California, USA

5001-10000 employees

https://www.apexon.com/

H1B Sponsorship

Apexon has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (117)

2024 (73)

2023 (83)

2022 (106)

2021 (99)

2020 (135)