PostgreSQL Database Administrator

Overview

PostgreSQL Database Administrator at Envestnet — hybrid role requiring in-office work at our Berwyn, PA or Raleigh, NC locations.

Job Summary

The PostgreSQL Database Administrator is responsible for managing and supporting highly available and secure PostgreSQL environments hosted in AWS RDS / Aurora. This mid-level role on the centralized infrastructure team combines traditional DBA responsibilities with cloud-native practices and production support. The ideal candidate will have experience in performance troubleshooting, automation via Terraform and Flyway, and hands-on involvement with access control, encryption, and auditing in AWS environments.

Job Responsibilities

• Manage and support Amazon Aurora PostgreSQL databases across production and non-production environments.
• Monitor database performance, availability, and health using CloudWatch, New Relic, and PostgreSQL-native tools.
• Diagnose and resolve database performance issues, query bottlenecks, and system-level resource concerns.
• Implement and maintain infrastructure as code using Terraform; support database deployments via Flyway.
• Participate in CI / CD workflows for schema changes and environment provisioning.
• Implement and support access controls, encryption settings, and auditing mechanisms aligned with SOC2 compliance efforts.
• Maintain and improve backup, recovery, and disaster recovery processes for Aurora PostgreSQL.
• Collaborate with developers, DevOps engineers, and application teams to advise on query optimization, schema design, and best practices.
• Contribute to automation and scripting efforts (e.g., SQL, Bash, Python) to support operations and performance monitoring.
• Participate in on-call rotation and assist with incident response related to database performance or availability.
• Document procedures, configurations, and operational runbooks for internal use.
• Adhere to and apply Envestnet policy within the role and department, including timely completion of training and awareness activities.

Required Qualifications

Preferred Qualifications

Envestnet

Be a member of an innovative and industry-leading financial technology and solutions company. Benefits include competitive compensation and a comprehensive rewards package.

Employment details

Equal Opportunity

Envestnet is an Equal Opportunity Employer

J-18808-Ljbffr