PostgreSQL DBA

Postgres
UNITED STATES
October 2, 2026
Full Time
Apply Now

Job Description

Company: Avance Consulting
Location: San Antonio, Texas | Irvine, California
Workplace Type: On-site
Employment Type: Permanent

About the Role

Avance Consulting is seeking a PostgreSQL Database Administrator for a permanent position located on-site in San Antonio, Texas or Irvine, California. This role involves end-to-end PostgreSQL administration, legacy database migration and code remediation from SQL Server and Oracle, AWS cloud database operations, and high-availability systems management.

What You’ll Do / Key Responsibilities

  • PostgreSQL Administration: Install, configure, manage, secure, monitor, and tune PostgreSQL databases.
  • Database Maintenance: Perform regular database maintenance activities including vacuuming, indexing, and query tuning.
  • Migrations & Remediation: Lead migrations from SQL Server and Oracle databases to PostgreSQL.
  • Code Conversion: Perform hands-on remediation and conversion of stored procedures, triggers, functions, and database schemas, resolving naming convention differences including Snake Case, Pascal Case, and other standards.
  • Cross-Team Collaboration: Partner with application teams to troubleshoot and resolve functional issues during migration activities.
  • AWS Cloud Database Management: Manage PostgreSQL deployments within AWS environments and utilize AWS DMS for database migration activities.
  • AWS Services Configuration: Configure and maintain AWS services including CloudWatch, S3, and IAM to support cloud-native database operations and monitoring.
  • Performance & High Availability: Optimize database performance and scalability across multiple PostgreSQL versions, managing streaming replication, logical replication, and high availability configurations.
  • Monitoring & Architecture: Implement monitoring and proactive performance tuning strategies; ensure database resilience through robust architecture and operational best practices.
  • Backup & Disaster Recovery: Design and implement database backup and recovery strategies leveraging native PostgreSQL capabilities and AWS services.
  • Failover & Resiliency: Support Multi-AZ deployments and failover configurations to ensure disaster recovery readiness and business continuity requirements are met.
  • Security & Governance: Implement and maintain PostgreSQL security policies, roles, and privileges, while enforcing database governance, access controls, and compliance standards.
  • Health Monitoring & Documentation: Monitor database health using pgAdmin, AWS CloudWatch, and other monitoring solutions; maintain documentation for database environments, configurations, standards, and procedures.
  • Operational Support: Collaborate with development and infrastructure teams to support application requirements, provide operational troubleshooting, participate in platform improvement initiatives, and ensure reliable, secure, and scalable database services.

Requirements & Qualifications

  • Proven hands-on experience in PostgreSQL administration, installation, configuration, security, monitoring, and performance tuning.
  • Experience with database migrations from SQL Server and Oracle to PostgreSQL.
  • Hands-on proficiency in converting and remediating database objects such as stored procedures, triggers, functions, and schemas.
  • Working knowledge of database naming conventions (e.g., Snake Case, Pascal Case).
  • Experience deploying and managing databases in AWS environments, including working with AWS DMS, CloudWatch, S3, and IAM.
  • Solid experience configuring and managing streaming replication, logical replication, high availability, and Multi-AZ failover architectures.
  • Demonstrated expertise in database backup, recovery, and disaster recovery strategies using native PostgreSQL tools and AWS services.
  • Familiarity with database monitoring tools such as pgAdmin and AWS CloudWatch.
  • Strong troubleshooting, problem-solving, and operational support capabilities.

Preferred / Bonus Qualifications (if applicable)

  • Certifications (Preferred but not required):
    • PostgreSQL Certified Professional (or equivalent)
    • AWS Certified Solutions Architect – Associate/Professional

Related Jobs