Postgres SQL DBA

Postgres SQL DBA

St Louis, MO – Onsite

Full-Time Permanent

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 long-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.