Senior PostgreSQL / AWS Aurora DBA - remote

Knack
Posted 2 years ago
Hi, thanks for reading about our Senior PostgreSQL / AWS Aurora DBA opportunity! We're glad you're here.

 We're Knack, a no-code productivity platform that’s redefining how work gets done. Knack is used by thousands of customers — from non-profits to the world’s biggest organizations — to run processes, departments, and even entire companies.

 We need a capable Senior PostgreSQL / AWS Aurora DBA to help us deliver an outstanding and reliable product.

 We’re looking for someone who is positioned to help us scale the performance / scalability of our DB clusters through the next phase of our product evolution.

 And did I mention self-motivated and independent? This is a 100% remote role that gives you the autonomy to define how you can do the best work of your career.

 In this role, you will: 
  •  Identify and implement monitoring solutions that will pinpoint poor SQL and help us understand how to remediate
  •  Look for opportunities to improve performance by observing how Knack interfaces with database
  •  Work closely with engineering teams on SQL/DDL organization and optimization
  •  Review/Update/Create node.js code that generates SQL
  •  Maintain and enhance our AWS Aurora PostgreSQL implementation
  •  Collaborate with infrastructure and engineering teams to create robust auto scaling solutions
  •  Maintain internal documentation on PostgreSQL best practices and troubleshooting approaches
  •  Participate in code reviews and provide feedback on SQL queries
  •  Identify and implement indexing opportunities for specific customers

 We're looking for someone who is: 
  •  A logical and critical thinker. You can quickly get up to speed and understand complex domain knowledge.
  •  Experienced communicator who can work with cross-functional teams to create and execute plans.
  •  Passionate about process and structure. You can prioritize what is most important and create repeatable processes to improve common workflows.
  •  Focused on the problem. You can go heads down to understand the root cause of a bug.
  •  You embrace a dynamic and fast paced environment. You have experience balancing multiple projects and priorities.
  •  Humble but opinionated. You have lots of ideas, yet you are happy to shift directions when a better path emerges. You take your work much more seriously than you take yourself.
  •  Engaging beyond the DB. You understand that empathizing with our customers, building relationships with your co-workers, and going deep on the product makes you a better teammate and a better engineer.

 Our Stack: 
  • Back-end: JavaScript, Node.js, ES6
  • Data: Both SQL and NoSQL, PostgreSQL, Mongo, Redis, Solr, ElasticSearch
  • DevOps &Deployment: All things AWS, Jenkins, Github
  • Testing: Playwright, Mocha, Jest
  • Front-end: Vue.js, Webpack, SCSS