PostgreSQL Database Administrator (DBA)

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.

Remote About the Company: Tek Leaders Inc Apply tot his job Apply To this Job