Postgres SQL DBA

2 weeks ago

St Louis, MO, United States Diverse Lynx Full time
Job Title: Postgres SQL DBA
Location: St Louis, MO
Duration: Fulltime

Skills: Database Administration | PostgreSQL

Roles and Responsibilities:

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 Enterprise DB.
  • 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.


Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.

  • Postgres DBA

    2 weeks ago

    St Louis, MO, United States Diverse Lynx Full time

    Role: Postgres DBA Location: St Louis , MO- Onsite Experience: 8+ Year Duration: 6-12 Months 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...

  • Postgres DBA

    1 week ago

    St Louis, MO, United States Diverse Lynx Full time

    Role: Postgres DBA Location: St Louis , MO- Onsite Experience: 8+ Year Duration: 6-12 Months 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...

  • Postgres DBA

    3 days ago

    St Louis, MO, United States Diverse Lynx Full time

    Role: Postgres DBA Location: St Louis , MO- Onsite Experience: 8+ Year Duration: 6-12 Months 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...

  • Postgres DBA

    17 hours ago

    St Louis, MO, United States Diverse Lynx Full time

    Role: Postgres DBA Location: St Louis , MO- Onsite Experience: 8+ Year Duration: 6-12 Months 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...

  • PostgreSQL DBA

    24 hours ago

    St Louis, MO, United States CData Software Full time

    Job Title - PostgreSQL DBA Location - St. Louis, MO Must Have Technical/Functional Skills Experience in the design, maintenance, and administration of EDB Postgres, Postgres Distributed and AWS RDS. Deep understanding of EDB Postgres architecture and internals. Proficient in PostgreSQL installation and configuration, especially PostgreSQL Plus Advanced...

  • Postgresql DBA

    1 week ago

    St Louis, MO, United States Purple Drive Full time

    Postgresql DBA Job Description: 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...

  • EDB PostgreSQL DBA

    1 week ago

    St Louis, MO, United States Infosys Limited Digital Full time

    Job details Job Role Technology Lead - US Work Location St Louis, MO State / Region / Province Missouri Country USA Skills Technology|Database Administration|PostGreSQL, Technology|Ruby on Rails|MySql,Postgres,Oracle,cucumber Domain Delivery Interest Group Infosys Limited Company ITL USA Requisition ID 140287BR Infosys is seeking EDB PostgreSQL DBA, this...

  • PostgreSQL DBA

    5 days ago

    St Louis, MO, United States Purple Drive Full time

    PostgreSQL DBALocation: St. Louis, MO (Onsite) Type: Contract Role Role Overview We are seeking an experienced PostgreSQL Database Administrator (DBA) to manage, optimize, and support enterprise-level PostgreSQL environments. The role involves ensuring high availability, performance tuning, security, and disaster recovery while also supporting developers...

  • PostgreSQL DBA

    7 days ago

    St Louis, MO, United States Purple Drive Full time

    PostgreSQL DBALocation: St. Louis, MO (Onsite) Type: Contract Role Role Overview We are seeking an experienced PostgreSQL Database Administrator (DBA) to manage, optimize, and support enterprise-level PostgreSQL environments. The role involves ensuring high availability, performance tuning, security, and disaster recovery while also supporting developers...

  • PostgreSQL DBA

    3 days ago

    St Louis, MO, United States Purple Drive Full time

    PostgreSQL DBALocation: St. Louis, MO (Onsite) Type: Contract Role Role Overview We are seeking an experienced PostgreSQL Database Administrator (DBA) to manage, optimize, and support enterprise-level PostgreSQL environments. The role involves ensuring high availability, performance tuning, security, and disaster recovery while also supporting developers...