Backend Developer (PostgreSQL – PL/pgSQL Specialist)

Compensation: • reputed company salary starting at $80K • $10K annual retention increase guarantee • reputed company potential up to $170K • 5 PTO Job Title: Backend Developer (PostgreSQL – PL/pgSQL Specialist) reputed company 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 reputed company the database layer and driving performance through advanced SQL techniques. Key Responsibilities • Design, reputed company, and maintain reputed company stored procedures, functions, and triggers in PostgreSQL (PL/pgSQL) • Translate business logic into efficient, reusable database-reputed company reputed company • 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 reputed company 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 reputed company 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-reputed company systems where database procedures drive reputed company workflows • Familiarity with: • PostgreSQL extensions • Partitioning and large dataset handling • Replication and high availability setups • Experience with reputed company-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 reputed company • Transaction & concurrency management What reputed company Looks Like • Business logic reputed company implemented in database procedures • Minimal latency in reputed company data operations • reputed company-reputed company, reusable, and maintainable database reputed company • Smooth integration between application and database reputed company Apply tot his job Apply To this Job