Senior Cloud Database Engineer (PostgreSQL)

As a Database Engineer at Motive, your main responsibility will be to ensure that the databases are performant, reliable, scalable, and automated. You will be overseeing more than 100 databases, mostly Postgres, and will also contribute to the expanded use of AWS managed data layer services like DynamoDB, Elasticsearch, and Redshift. Your role will involve partnering with product team engineers to analyze database and system performance, provide optimizations, and assist in query tuning to support safe scaling. Additionally, you will play a crucial part in maintaining zero-downtime upgrades and maintenance as Motive aims for 99.99% SLAs, emphasizing the reliability focus of the Database Engineering team. Responsibilities: - Design and implement high availability database architecture in AWS - Collaborate with developers and SREs to automate infrastructure provisioning - Monitor and enhance database performance through query and index tuning, schema updates, and partitioning - Work with Data and ML teams on Kafka and Snowflake integrations and data flows - Perform Database Administrator tasks and maintenance for database table health - Plan and execute disaster recovery scenarios - Create dashboards for database health and alerting - Deploy database instances, users, groups, and permissions using Terraform - Manage database upgrades and migrations with minimal to zero downtime - Take on-call duty to address production incidents Requirements: - B.S. or M.S. in Computer Science or a related field, or equivalent work experience - 5+ years of overall experience with 3+ years working specifically with PostgreSQL - Experience in building and maintaining mission-critical production PostgreSQL databases - Strong understanding of PostgreSQL database architecture - Familiarity with AWS managed services like Aurora - Proficiency in high-availability, backup, and recovery solutions - Advanced knowledge of query tuning and optimization - Experience provisioning PostgreSQL databases in AWS using tools like Terraform, CloudFormation, and Ansible - Familiarity with monitoring and logging tools such as Datadog, New Relic, Sumo Logic - Experience with other databases like DynamoDB, Redshift, Elasticsearch, Snowflake is a plus Creating a diverse and inclusive workplace is one of Motive's core values. They are an equal opportunity employer that values different backgrounds, experiences, abilities, and perspectives.,