Backend Developer (PostgreSQL – PL/pgSQL Specialist)
ARCHIVED
We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.
Compensation: Base salary starting at $80K$10K annual retention increase guarantee
Growth potential up to $170K5 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 PostgreSQLDeep 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