Database Administrator

Want more jobs like this?

Get Data and Analytics jobs in United States delivered to your inbox every week.

Get Jobs

Send me The Muse newsletters for the best in career advice and job search tips.

By signing up, you agree to our Terms of Service & Privacy Policy.

About the Job: 

As a PostgreSQL DBA you will ensure that our databases are performant, highly available, and reliable. You will partner with other engineers across the org to build and administer databases using code and automation. You will analyze the performance of databases and systems to provide optimizations and build scalable infrastructure. You will help developers write efficient queries and review code that interacts with our databases. You will plan and execute major upgrades and maintenance tasks with minimal downtime.

Qualifications:

• B.S. or M.S. in Computer Science or a related field, or equivalent work experience
• 3+ years of experience working with PostgreSQL 9.6+
• Experience building and maintaining mission-critical production PostgreSQL databases 
• Solid understanding of PostgreSQL database architecture (locking, consistency, transaction logging, etc)
• Experience with high-availability, backup and recovery solutions and strategies
• Advanced knowledge of query tuning and optimization techniques
• 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

Responsibilities:

• Design and implement high availability database architecture 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 tune and optimize 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