Backend Developer (PostgreSQL – PL/pgSQL Specialist)
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