Compensation:

• Base salary starting at $80K
• $10K annual retention increase guarantee
• Growth potential up to $170K
• 5 PTO

Job Title: Backend Developer (PostgreSQL – PL/pgSQL Specialist)

Overview

We are looking for a Backend Developer with deep expertise in PostgreSQL, specifically in building and optimizing stored procedures and database functions (PL/pgSQL). This role is ideal for someone who is passionate about encapsulating business logic within the database layer and driving performance through advanced SQL techniques.

Key Responsibilities

• Design, develop, and maintain complex stored procedures, functions, and triggers in PostgreSQL (PL/pgSQL)
• Translate business logic into efficient, reusable database-side code
• Optimize queries and procedural logic for performance and scalability
• Analyze and tune execution plans for high-performance workloads
• Build and maintain data processing pipelines using SQL and procedural logic
• Implement robust error handling, logging, and transaction management within procedures
• Collaborate with application developers to ensure efficient integration with database logic
• Design schemas and data models that support procedural workflows
• Manage schema changes and versioning of database objects
• Troubleshoot and resolve database performance bottlenecks

Required Qualifications

• 3-5+ years experience in backend or database development
• Strong hands-on experience with PostgreSQL
• Deep expertise in:
• PL/pgSQL (stored procedures, functions, triggers)
• Writing complex SQL (joins, window functions, CTEs)
• Query optimization and indexing strategies
• Transaction handling and concurrency
• Experience implementing business logic inside the database layer
• Proficiency in at least one backend language (Python, Java, Node.js, Go, etc.)
• Strong debugging and performance tuning skills

Preferred Qualifications

• Experience designing large-scale systems where database procedures drive core workflows
• Familiarity with:
• PostgreSQL extensions
• Partitioning and large dataset handling
• Replication and high availability setups
• Experience with cloud-managed PostgreSQL (AWS RDS, Azure, GCP)
• Exposure to ETL/data processing frameworks
• Understanding of API-to-database interaction patterns and ORM limitations

Key Skills

• PL/pgSQL mastery (must-have)
• Advanced SQL & data manipulation
• Query performance tuning
• Data modeling & schema design
• Debugging procedural database code
• Transaction & concurrency management

What Success Looks Like

• Business logic efficiently implemented in database procedures
• Minimal latency in complex data operations
• Well-structured, reusable, and maintainable database code
• Smooth integration between application and database layers