Senior Database Engineer, Jobber

• 5 to 10 years administering databases such as Postgres, Oracle or MySQL, preferably in a cloud environment
• An understanding of Postgres internals and query analysis tools like explain plan, as well as DB performance monitoring tools like RDS Performance (Database) Insights
• Experience with Disaster Recovery / High Availability architectures
• Familiar with some “glue” languages (eg. Bash, Python, Ruby)
• Familiarity with Infrastructure as Code, preferably Terraform
• Familiarity with AWS technologies including: RDS Aurora, RDS Proxy and Database Migration Services or their non-AWS equivalents
• Understanding of caching technologies like Redis and Memcache

Desirable

• Reporting to a Manager, Software Engineering, the Senior Database Engineer will work, along with the operations team and the rest of the engineering organization, to build and maintain an industry leading product that helps our customers and their small businesses be successful
• We’re looking for someone who is ready to solve problems that millions of entrepreneurs are facing, using their experience to drive solutions and help ensure our infrastructure remains available and responsive to our customers
• Your work will include ensuring the stability and scalability of our fleet of Aurora Postgres databases identifying and fixing issues such as cache optimization, query optimization, indexes, IOPS, etc
• You will also ensure we have appropriate monitoring and alerting in place to understand how our databases are performing and be able to proactively address issues as well as reactively understand what triggered an issue
• Additionally, the Senior Database Engineer will collaborate with the development teams on things like schema design and query optimization and refactoring (mostly through Rails ActiveRecord)
• Finally cost analysis and optimization of the database in the AWS cloud will be part of your duties