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