• Perform deep query analysis and testing to identify opportunities for query refactoring to improve performance of our backend
• Review and refactor Node.js code that dynamically generates SQL queries
• Work closely with engineering teams on SQL/DDL organization and optimation
• Identify and implement monitoring solutions that will pinpoint poor SQL and help us understand how to remediate
• Aggregate and analyze data across many database clusters to identify query patterns, pinpointing poor performance affecting Knack customer experience
• Create internal tooling to aggregate metrics, providing actionable insights to our backend engineers
• Maintain and enhance our AWS Aurora PostgreSQL implementation
• Collaborate with infrastructure and engineering teams to optimize our RDS architecture
• 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 and applications

• A logical and critical thinker. You can quickly get up to speed and understand complex domain knowledge
• Experience 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.
• Strong opinions loosely held. You have lots of ideas, yet you are happy to shift directions when a different path emerges that better aligns with Knack’s goals. 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.

• Back-end: JavaScript/TypeScript, Node.js, ES6, GoLang
• Data: Aurora PostgreSQL, Redis, ElasticSearch
• DevOps & Deployment: All things AWS, Terraform (and Terraform Cloud), Jenkins, CircleCI, Github, Datadog, New Relic, GrayLog
• Testing: Playwright, Mocha, Jest
• Front-end: Vue.js, Webpack, SCSS
  

✨ Benefits ✨

• Define your work: find the location, environment, and schedule that is best for your life and work. It's not about separation, it's about optimization. Our only rule is an overlap zone of 11am to 4pm EST.
• Unlimited Paid Vacation: take the time you need to stay motivated, charged, and balanced. You'll get required days off for birthdays and knackiversaries.
• Paid Corporate Retreats: we get together once a year at an amazing location to do normal human being things in person. We pay for your flight, lodging, and meals.
• HealthCare: we offer health, vision, and dental, covering 75% of the premium for you and your dependents (spouse + children).
• 401(k): we give you the option to automatically deduct funds from your pay to stash them away for your golden years (currently non-matching, but stay tuned!)
• Equal opportunity: we push everyone to maximize their impact on our product and company-we strongly value all of our people, regardless of title or seniority.
• Learning Credits - An annual allowance is provided to stay on top of your game with classes, books, and conferences.
• Family support: we offer a generous paid family leave to welcome any new additions to your family.
• Tech: we provide a top-of-the-line MacBook.
• Referral Bonus: we think you're great which means you know awesome people! we offer a referral bonus to anyone you refer for an open position once they are hired as an official Knackster!
• Workstation Allowance: we want your work from home space to have everything you need! we offer a workstation allowance to help with that!

1

2