Postgres DBA

$85,000 - $140,000/Yr

American Express - Phoenix, AZ

Full-time - Mid Level

Phoenix, AZ

Credit Intermediation and Related Activities

About the position

The Postgres DBA at American Express is responsible for managing and automating database administration tasks across both on-premises and public cloud environments, specifically AWS and GCP. This role involves ensuring the performance, reliability, and security of PostgreSQL databases while actively participating in incident management and process improvements. The DBA will work in a collaborative and inclusive environment, leveraging the latest technologies to enhance database operations and support the broader engineering community.

Responsibilities

• Automation of regular DBA tasks like monitoring, backup, recovery, and query automation.
• Identify automation opportunities, resource savings, and process improvement avenues.
• Utilize automation and database monitoring tools such as Ansible, Python, GitHub, and shell scripting.
• Integrate PostgreSQL monitoring tools with ServiceNow, Slack, and other alert generation tools.
• Provide first-line support for PostgreSQL databases and manage tickets.
• Perform backup and recovery of PostgreSQL databases.
• Monitor and handle alerts related to database performance.
• Build, monitor, and troubleshoot database replication.
• Conduct performance monitoring and tuning of databases.
• Participate in major incident management troubleshooting calls.
• Manage and monitor databases using PgAdmin, Patroni, and Pgbackrest tools.
• Perform maintenance activities like vacuuming and analyzing databases.
• Engage in day-to-day change, incident, and problem management, exploring options for optimization and high availability.
• Enhance observability dashboards and improve alerting mechanisms.
• Be flexible to work on weekends on a rotational basis.

Requirements

• Bachelor's degree in Computer Science, Computer Engineering, or a related field.
• 4+ years of experience as a Database Administrator focusing on PostgreSQL.
• Experience with public cloud platforms such as AWS, GCP, and/or Azure.
• Proficiency in Linux as it pertains to database and OS performance monitoring.
• Strong communication skills and ability to collaborate effectively with team members.

Nice-to-haves

• Experience with OEM for PostgreSQL monitoring is a plus.

Benefits

• Paid parental leave
• Health insurance
• Dental insurance
• Vision insurance
• Life insurance
• Retirement plan