As a Database Engineer at Motive, you will ensure that our databases are performant, reliable, scalable, and automated. While overseeing more than 100 databases, almost all of which are PostgreSQL, you will also have a hand in the success of Motive’s expanded use of AWS managed data layer services (such as MySQL, DynamoDB, Elasticsearch, and Redshift, etc.). Working with product team engineers across a great variety of use cases, you will analyze the performance of databases and systems to provide optimizations and partner with product engineers on query tuning to help us keep scaling safely. As a member of Database Engineering team, you will execute zero-downtime upgrades and maintenance helping Motive to achieve 99.99% SLAs.
Responsibilities:
- Design and implement high availability database architecture in AWS
- Partner with developers and SREs to build and automate the provisioning of new infrastructure
- Continuously monitor and improve database performance via proactive database maintenance, schema updates, table partitioning, etc.
- Collaborate with developers to optimize database queries
- Automate routine database administration and maintenance tasks ensuring the health of databases
- Plan and execute disaster recovery scenarios
- Build dashboards for database health and alerting
- Perform Terraform deployments of database instances and clusters
- Manage database upgrades and migrations with minimal to zero-downtime
- Requirements:
- B.S. or M.S. in Computer Science or a related field, or equivalent work experience
- 5+ years of experience working with PostgreSQL
- Experience building and maintaining mission-critical production PostgreSQL databases
- Solid understanding of PostgreSQL database architecture (locking, consistency, transaction logging, etc)
- AWS database services experience (RDS/Aurora, 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