Talent.com
PostgreSQL Database Administrator (DBA)
PostgreSQL Database Administrator (DBA)Tek Leaders Inc • San Francisco, CA, California, USA
PostgreSQL Database Administrator (DBA)

PostgreSQL Database Administrator (DBA)

Tek Leaders Inc • San Francisco, CA, California, USA
3 days ago
Job type
  • Full-time
Job description

PostgreSQL Database Administrator (DBA) - AWS Aurora

Location : Remote Northern California Preferred

Working Hours : Pacific Time Zone

Position Overview

We are seeking a highly skilled PostgreSQL Database Administrator (DBA) with deep

expertise in AWS Aurora PostgreSQL to design, optimize, and maintain high-

performance, secure, and scalable database systems. The successful candidate will play

a key role in defining and implementing PostgreSQL best practices, supporting CI / CD

automation, and ensuring system reliability across multiple environments.

Key Responsibilities

  • Create data structures such as tables, views, and schemas based on technical specifications.
  • Develop and maintain stored procedures, triggers, and functions to support application

logic.

  • Implement authorization-level security using PostgreSQL roles and privileges.
  • Maintain compliance with organizational and regulatory data protection standards.
  • Implement physical performance optimizations through indexes, partitions, and
  • materialized views.

  • Conduct logical performance tuning through SQL optimization and query analysis.
  • Configure and tune AWS Aurora performance and scalability features to ensure efficient
  • database operation.

  • Identify and implement PostgreSQL and AWS cost optimization opportunities.
  • Design and implement high availability (HA) and disaster recovery (DR) architectures
  • leveraging AWS Aurora features.

  • Conduct cross-environment data cloning and synchronization.
  • Work with DevOps teams to implement PostgreSQL CI / CD pipelines for automated
  • deployment and versioning.

  • Develop code generators to automate recurring administration tasks using PostgreSQL
  • metadata tables.

  • Define and enforce PostgreSQL best practices including deployment processes, performance
  • baselines, and security standards.

  • Document architectures, procedures, and data models using Confluence and Lucidchart.
  • Mandatory Qualifications

  • 5+ years of experience administering PostgreSQL databases.
  • 2+ years of hands-on experience administering AWS Aurora PostgreSQL.
  • 4+ years performing physical and logical performance tuning for PostgreSQL.
  • Proven experience implementing AWS Aurora high availability features.
  • Demonstrated ability to work with DevOps teams to design and deploy PostgreSQL CI / CD
  • pipelines.

  • Hands-on experience developing PostgreSQL code generators using metadata tables.
  • Desirable Qualifications

  • Experience working in regulated environments (e.g., HIPAA, FERPA, PCI).
  • Prior experience tuning performance for Talend-generated SQL statements.
  • Experience with PostgreSQL CI / CD automation tools (e.g., Liquibase, Flyway, or equivalent).
  • Preferred Skills

  • Deep understanding of PostgreSQL internals and Aurora architecture.
  • Proficiency in AWS services such as CloudWatch, IAM, and CloudFormation.
  • Familiarity with infrastructure as code (IaC) tools such as Terraform or Ansible.
  • Strong analytical and problem-solving abilities with attention to detail.
  • Excellent written documentation and communication skills.
  • Create a job alert for this search

    Database Administrator • San Francisco, CA, California, USA

    Related jobs
    Database Administrator

    Database Administrator

    Supermicro • San Jose, CA, United States
    Full-time
    Supermicro is a Top Tier provider of advanced server, storage, and networking solutions for Data Center, Cloud Computing, Enterprise IT, Hadoop / Big Data, Hyperscale, HPC and IoT / Embedded customers...Show more
    Last updated: 30+ days ago • Promoted
    Database Engineer II

    Database Engineer II

    VirtualVocations • San Francisco, California, United States
    Full-time
    A company is looking for a Database Engineer II to support Navy operations by managing enterprise-level databases.Key Responsibilities Install, upgrade, configure, and maintain Oracle databases, ...Show more
    Last updated: 5 days ago • Promoted
    Cassandra Database Administrator_San jose, CA (4 days onsite in a week, W2 Only)

    Cassandra Database Administrator_San jose, CA (4 days onsite in a week, W2 Only)

    Quantaleap • San Jose, CA, US
    Full-time
    Quick Apply
    C2C not allowed for this position) Role : .Sr Cassandra Database Administrator Location : San Jose , CA (Hybrid, 1 day remote in a week) Duration : Contract (W2 Only) Job Description : In this h...Show more
    Last updated: 30+ days ago
    Database Administrator

    Database Administrator

    University of California - San Francisco Campus and Health • San Francisco, CA, United States
    Full-time
    The Database Administrator will be an integral member of the Database Services team within the Platform Services domain.The Database Administrator will partner with diverse and talented team member...Show more
    Last updated: 30+ days ago • Promoted
    Senior Database Architect

    Senior Database Architect

    VirtualVocations • Santa Clara, California, United States
    Full-time
    A company is looking for a Senior Database Architect to design and maintain scalable database solutions.Key Responsibilities Collaborate with stakeholders to translate business requirements into ...Show more
    Last updated: 30+ days ago • Promoted
    Database Administrator

    Database Administrator

    University of California - San Francisco • San Francisco, CA, United States
    Full-time
    The Database Administrator will be an integral member of the Database Services team within the Platform Services domain.The Database Administrator will partner with diverse and talented team member...Show more
    Last updated: 30+ days ago • Promoted
    Senior SQL Database Administrator

    Senior SQL Database Administrator

    VirtualVocations • Concord, California, United States
    Full-time
    A company is looking for a Senior SQL Database Administrator.Key Responsibilities Monitor daily operations and perform critical Oracle patching Conduct database security assessments and address ...Show more
    Last updated: 30+ days ago • Promoted
    Database Administrator with DOD Clearance

    Database Administrator with DOD Clearance

    VirtualVocations • Concord, California, United States
    Full-time
    A company is looking for a Database Administrator with a current DOD Secret clearance.Key Responsibilities Design, configure, and maintain database environments using MySQL / MariaDB and / or Microso...Show more
    Last updated: 1 day ago • Promoted
    ADABAS Database Specialist

    ADABAS Database Specialist

    VirtualVocations • San Francisco, California, United States
    Full-time
    A company is looking for an ADABAS Database Specialist / DB2.Key Responsibilities Install, configure, and upgrade ADABAS and DB2 database systems Maintain high availability and troubleshoot produc...Show more
    Last updated: 29 days ago • Promoted
    Senior Oracle Database Administrator

    Senior Oracle Database Administrator

    VirtualVocations • Fremont, California, United States
    Full-time
    A company is looking for a Senior Oracle Database Administrator.Key Responsibilities Monitor daily operations and perform critical Oracle patching Conduct database security assessments and addre...Show more
    Last updated: 1 day ago • Promoted
    Database Administrator

    Database Administrator

    VirtualVocations • Santa Clara, California, United States
    Full-time
    A company is looking for a Database Administrator.Key Responsibilities Provide database support, including troubleshooting connectivity and performance issues Perform scheduled releases and mont...Show more
    Last updated: 30+ days ago • Promoted
    Lead Database Engineer

    Lead Database Engineer

    VirtualVocations • Fremont, California, United States
    Full-time
    A company is looking for a Lead Database Engineer who will design, build, and oversee the deployment and operation of technology architecture and solutions for data management.Key Responsibilities ...Show more
    Last updated: 22 hours ago • Promoted • New!
    PostGreSQL Engineer

    PostGreSQL Engineer

    VirtualVocations • Santa Clara, California, United States
    Full-time
    A company is looking for a PostGreSQL Engineer.Key Responsibilities Perform advanced PostgreSQL performance tuning and optimization Manage disk interactions and handle semi / aggregated data Util...Show more
    Last updated: 5 days ago • Promoted
    Senior Database Administrator

    Senior Database Administrator

    VirtualVocations • Concord, California, United States
    Full-time
    A company is looking for a Senior Database Administrator (SQL / Oracle).Key Responsibilities Administer, maintain, and optimize SQL Server and Oracle databases and clustered environments Troublesh...Show more
    Last updated: 30+ days ago • Promoted
    ADABAS Database Engineer

    ADABAS Database Engineer

    VirtualVocations • Concord, California, United States
    Full-time
    A company is looking for an ADABAS Database Specialist / DB2.Key Responsibilities Install, configure, and upgrade ADABAS and DB2 database systems Maintain high availability and troubleshoot produc...Show more
    Last updated: 3 days ago • Promoted
    Database Administrator

    Database Administrator

    TradeJobsWorkForce • 94163 San Francisco, CA, US
    Full-time
    Responsibility for the evaluation of database software purchases Supervision of modifications to any existing database software to meet the needs of their employer Responsibility for maintaining th...Show more
    Last updated: 30+ days ago • Promoted
    Database Engineer

    Database Engineer

    VirtualVocations • San Francisco, California, United States
    Full-time
    A company is looking for a Database Engineer to ensure the performance, scalability, and reliability of their databases.Key Responsibilities : Design and implement high-performance database schema...Show more
    Last updated: 30+ days ago • Promoted
    Senior Discovery Database Administrator (DBA) (Top Secret Clearance Required)

    Senior Discovery Database Administrator (DBA) (Top Secret Clearance Required)

    Medium • San Francisco, CA, United States
    Full-time
    Senior Discovery Database Administrator (DBA).Employment Type : Full‑Time, Executive‑Level.CGS is seeking a dedicated Senior Discovery Database Administrator to join a fast‑paced and hard‑working te...Show more
    Last updated: 21 days ago • Promoted