100% Remote-Amazon Aurora PostgreSQL Database Administrator (DBA)

Ventures Unlimited Inc

Costa Mesa (CA)

On-site

USD 120,000 - 160,000

Full time

45 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Ventures Unlimited Inc. seeks a seasoned PostgreSQL DBA to manage Amazon Aurora PostgreSQL and Amazon RDS in AWS, ensuring high availability, performance tuning and secure operations.

You will implement automation, IaC, and CI/CD processes, while leading migrations to Aurora PostgreSQL and maintaining robust backup strategies for business continuity.

Qualifications

  • Minimum 5+ years of hands-on database administration experience.
  • Strong experience administering PostgreSQL databases in AWS environments.
  • Proven experience with Amazon Aurora PostgreSQL and Amazon RDS services.

Responsibilities

  • Provision, configure, monitor and maintain Amazon Aurora PostgreSQL and Amazon RDS databases.
  • Perform database installation, upgrades, patching and lifecycle management.
  • Monitor database health, capacity and performance metrics.
  • Analyze and optimize SQL queries and database workloads.
  • Implement indexing strategies and query tuning best practices.
  • Manage connection pooling and resolve infrastructure bottlenecks.
  • Troubleshoot and resolve database performance issues.
  • Design and implement Multi-AZ deployments and cross-region replication.
  • Develop, test, and maintain backup and disaster recovery processes.
  • Ensure database availability and business continuity objectives are met.
  • Lead or support database migration initiatives to Aurora PostgreSQL.
  • Utilize AWS DMS and SCT for migration projects.
  • Perform migration assessments, validations and post-migration optimization.
  • Develop automation scripts for routine database administration activities.
  • Support CI/CD pipeline integration for database deployments and schema changes.
  • Implement security controls, database encryption and access management.
  • Apply database patches and vulnerability remediation activities.
  • Ensure compliance with organizational and regulatory security standards.
  • Perform periodic security reviews and audit support activities.

Skills

PostgreSQL architecture
AWS RDS
Database performance tuning
Scripting: Python/Bash/PowerShell
IaC: Terraform/Ansible/CloudFormation
CI/CD/DevOps

Tools

Amazon RDS
AWS DMS
AWS SCT
CloudWatch
IAM
KMS
Terraform
Ansible
CloudFormation
Python
PowerShell
Bash

Job description

Must Have Technical/Functional Skills
Technical Skills
  • Strong expertise in PostgreSQL architecture, replication, backup and recovery.
  • Deep knowledge of AWS database services, including:
    • Amazon RDS
    • AWS DMS
    • AWS SCT
    • CloudWatch
    • IAM
    • KMS
  • Experience with database performance tuning and troubleshooting.
  • Proficiency in scripting languages such as Python, Bash, or PowerShell.
  • Experience with Infrastructure-as-Code tools including Terraform, Ansible or CloudFormation.
  • Familiarity with CI/CD tools and DevOps practices.
Experience
  • Minimum 5+ years of hands‑on database administration experience.
  • Strong experience administering PostgreSQL databases in AWS environments.
  • Proven experience with Amazon Aurora PostgreSQL and Amazon RDS services.
Database Administration
  • Provision, configure, monitor and maintain Amazon Aurora PostgreSQL and Amazon RDS databases.
  • Perform database installation, upgrades, patching and lifecycle management.
  • Monitor database health, capacity and performance metrics.
Performance Optimization
  • Analyze and optimize SQL queries and database workloads.
  • Implement indexing strategies and query tuning best practices.
  • Manage connection pooling and resolve infrastructure bottlenecks.
  • Troubleshoot and resolve database performance issues.
High Availability & Disaster Recovery
  • Design and implement Multi‑AZ deployments and cross‑region replication.
  • Develop, test, and maintain backup and disaster recovery processes.
  • Ensure database availability and business continuity objectives are met.
  • Lead or support database migration initiatives to Aurora PostgreSQL.
  • Utilize AWS Database Migration Service (DMS) and Schema Conversion Tool (SCT) for migration projects.
  • Perform migration assessments, validations and post‑migration optimization.
Automation & Infrastructure as Code (IaC)
  • Develop automation scripts for routine database administration activities.
  • Support CI/CD pipeline integration for database deployments and schema changes.
Security & Compliance
  • Implement security controls, database encryption and access management.
  • Apply database patches and vulnerability remediation activities.
  • Ensure compliance with organizational and regulatory security standards.
  • Perform periodic security reviews and audit support activities.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Aurora PostgreSQL Database Administrator (DBA)
Aurora PostgreSQL Database Administrator (DBA)

Talent Software Services, Inc. • Seven Hills (OH)

On-site
USD 120,000 - 170,000
Aurora PostgreSQL DBA - Migration, Tuning & HA Expert
Aurora PostgreSQL DBA - Migration, Tuning & HA Expert

TechDigital Group • Norfolk (VA)

On-site
USD 110,000 - 160,000
PostgreSQL DBA
PostgreSQL DBA

TechDigital Group • Norfolk (VA)

On-site
USD 110,000 - 160,000
Database Administrator
Database Administrator

Experion Technologies • United States

On-site
USD 90,000 - 120,000
PostgreSQL Database Administrator
PostgreSQL Database Administrator

Dataquest • Harrisburg

On-site
USD 100,000 - 130,000
Medical insurance
Vision insurance
401(k)
+1
DBA – AWS PostgreSQL
DBA – AWS PostgreSQL

Gravity IT Resources • Knoxville (TN)

Remote
USD 110,000 - 160,000
Senior PostgreSQL DBA: AWS RDS, Performance & Reliability
Senior PostgreSQL DBA: AWS RDS, Performance & Reliability

Compunnel Inc. • Des Moines (IA)

Hybrid
USD 120,000 - 180,000
PostgreSQL DBA
PostgreSQL DBA

Softcom Systems Inc • Irvine (CA)

On-site
USD 80,000 - 120,000
PostgreSQL Database Administrator
PostgreSQL Database Administrator

Drillo.AI • St. Louis (MO)

On-site
USD 90,000 - 115,000
Engineer
Engineer

Tata Consultancy Services Limited • Costa Mesa (CA)

On-site
USD 110,000 - 125,000
Discretionary Annual Incentive
Comprehensive Medical Coverage
Family Support: Parental Leaves
+4