Senior PostgreSQL / AWS Aurora DBA

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