
Senior Software Engineer, PostgreSQL Specialist
Applause
full-time
Posted on:
Location Type: Remote
Location: Arizona • Utah • United States
Visit company websiteExplore more
Job Level
Tech Stack
About the role
- Own the design, structure, and optimization of all PostgreSQL databases across the platform.
- Implement indexing, partitioning, caching, and query optimization strategies to improve performance and reliability.
- Work cross-functionally to architect and evolve data models that support new features while maintaining efficiency and data integrity.
- Collaborate with the backend engineering team to ensure backend services integrate seamlessly with database systems.
- Monitor and tune database performance using metrics and profiling tools.
- Develop, test, and release backend code that meets Applause’s high engineering standards, delivering 90%+ on-time releases.
- Establish and document conventions and best practices for working with data and backend services.
- Lead backend initiatives from concept to release—providing technical direction, mentorship, and quality oversight.
Requirements
- 7–12 years of backend engineering experience.
- 5+ years of production experience with PostgreSQL (including advanced indexing, schema design, and performance tuning).
- Strong knowledge of scaling databases in a high-traffic SaaS environment.
- Proficiency with Node.js or a comparable backend environment.
- Experience with query optimization, replication, partitioning, and migrations.
- High personal standards for code quality, documentation, and maintainability.
- Thrives in a fully remote, fast-moving startup environment.
- Bonus: Experience with database observability tools (e.g., pg_stat_statements, pganalyze, New Relic) or infrastructure-as-code tools for database management.
Benefits
- 100% remote w/ no office mandate
- Unlimited PTO
- 20 official company holidays
- Health care
- Life insurance
- Stock options
- Amazing colleagues
- Energetic culture that is positive and celebrates together
- Inspiring mission & software product
- Ability to grow your career by being early in a fast-growing tech startup
- Ability to ship a lot of new features and make a real impact
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
PostgreSQLindexingpartitioningcachingquery optimizationschema designperformance tuningNode.jsreplicationmigrations
Soft Skills
technical directionmentorshipquality oversighthigh personal standardscollaborationefficiencydata integrity