About the Job :
As a PostgreSQL DBA you will ensure that our databases are performant, resilient, and monitored. You will partner with developers and SREs across the engineering organization to solve database related issues, both in development and production.
You will help developers write efficient queries and review code that interacts with our databases as well as plan and execute major upgrades and maintenance tasks with minimal required downtime.
Design and implement high availability database architectures in AWS
Partner with developers and SREs to build new infrastructure
Continuously monitor and improve database usage via query and index tuning, schema updates, partitioning, etc.
Collaborate with developers to code optimized database queries
Plan and execute disaster recovery scenarios
Build dashboards for database health and alerting
Perform Terraform deployments of database instances, users, groups, and permissions
Manage database upgrades and migrations with minimal downtime
Take on-call duty to respond to production incidents
B.S. or M.S. in Computer Science or a related field, or equivalent work experience
3+ years of experience working with PostgreSQL 9.4+
Production experience in a high-traffic environment with PostgreSQL
Experience provisioning PostgreSQL databases in AWS with tools like Terraform, CloudFormation, Ansible
Experience with monitoring and log tools like Datadog, New Relic, Sumo Logic
Experience with other databases like DynamoDB, Redshift, Snowflake is a plus
As an equal opportunity employer, we are committed to diversity in the workforce. In accordance with applicable law, we prohibit discrimination against any applicant or employee based on any legally recognized basis, including, but not limited to;
race, color, religion, sex (including pregnancy, lactation, childbirth or related medical conditions), sexual orientation, gender identity, age (40 and over), national origin or ancestry, physical or mental disability, genetic information (including testing and characteristics), veteran status, uniformed service member status or any other status protected by federal, state or local law.