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