SQL Database Administrator

Role: PostgreSQL DBA

Location: St Louis, MO (Onsite)

Job Description

PostgreSQL

Overview

• Represent Database Engineering team as a subject matter expert in EDB Postgres, Postgres Distributed (PGD), and AWS relational database services. Expectation is Level 3 and above with good AWS Experience

• Continuously seek opportunities to improve efficiency and integrate technologies and platforms within the Postgres and related domains.

• Provide leadership and contribute to technology roadmaps supporting vision for Postgres and other relational database technologies.

• Possess experience with data migration and integration across multiple systems.

Roles and Responsibilities

• Excellent interpersonal and communication skills.

• Strong collaboration skills to work effectively across cross-functional teams.

• Forward-thinking approach to infrastructure automation and scripting.

• Ability to work with global teams across multiple time zones.

• Self-motivated with the ability to work independently and seek guidance when needed.

• Ability to understand application data requirements and recommend appropriate database solutions.

• Responsible for designing, deploying, and maintaining EDB Postgres, PGD and AWS RDS database clusters to support large-scale platforms and applications.

• Create and manage fully functional database clusters across development, QA, and production environments, with experience in performance tuning.

• Review existing configurations and recommend improvements.

• Assist with planning and executing Postgres database upgrades and migrations.

• Provide day-to-day administrative support and maintenance for Postgres and AWS Aurora databases.

• Participate in production support and on-call rotations as needed.

• Collaborate with Postgres and cloud vendors and utilize their support channels.

• Develop and implement backup strategies, perform upgrades, and apply patches.

• Identify inefficiencies and implement optimized solutions.

• Design and execute data and database migrations to new hardware or platforms.

• Lead best practices and database solution strategies

• Work with management to plan and implement new tools and data services.

• Represent Database Engineering in strategic planning and long-term direction.

• Support both internal and future cloud-managed Postgres systems, define best practices, and drive automation and innovation.

• Collaborate with multiple application teams and developers.

• Assist in defining lon g-term strategic goals for database development in alignment with stakeholders.

Required Skills:

• Experience in the design, maintenance, and administration of EDB Postgres, Postgres Distributed and AWS RDS.

• Deep understanding of EDB Postgres architecture and internals.

• Expertise in Table Partitioning on Large Data sets

• Proficient in PostgreSQL installation and configuration, especially PostgreSQL Plus Advanced Server and Postgres Distributed from EnterpriseDB.

• Skilled in PostgreSQL monitoring and alerting tools, particularly PEM. Familiarity with observability tools like Splunk and Dynatrace is a plus.

• Experienced in setting up, configuring, and monitoring PostgreSQL binary and logical replication (e.g., Binary Streaming, Bi-Directional Replication - BDR).

• Strong skills in collecting diagnostics and tuning PostgreSQL and SQL performance.

• Proficient in PostgreSQL procedural languages (PL/pgSQL, PL/Tcl, PL/Perl, PL/Python) and SQL.

• Excellent troubleshooting and debugging skills.

• Experience in performance tuning and automation for Postgres and AWS platforms.

• Proficient in Linux, especially Oracle Linux Enterprise.

• Familiarity with scripting languages such as Bash, KSH, and Perl.