One stop solution to your remote job hunt!

By signing up you get access to highly customizable remote jobs newsletter, An app which helps you in your job hunt by providing you all the necessary tools.

Try RemoteJobHuntBuddy commitment free for 7 days, no credit card necessary.
OR
Subscribe to our highly customizable newsletter to get remote jobs from top remote job boards delivered to your inbox.
Knack over 1 year ago
devops and sysadminfull-timeusa only
Apply Now

Time zones: EST (UTC -5), CST (UTC -6), MST (UTC -7), PST (UTC -8), AKST (UTC -9), HST (UTC -10)

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