JD :
We are looking for an experienced PostgreSQL Developer with deep expertise in SQL development, schema design, query optimization, stored procedures, and application integration . The ideal candidate will have a strong background in building scalable database solutions, writing complex queries, and collaborating with backend / frontend teams to ensure efficient and reliable data access. This role is focused on development and engineering within PostgreSQL.
Roles and Responsibilities
o Design normalized and denormalized database schemas for high-performance applications.
o Develop complex SQL queries, functions, views, triggers, and stored procedures to support application needs.
o Write highly efficient queries , ensuring performance and scalability.
o Conduct query tuning and indexing strategies to reduce latency.
o Optimize data retrieval processes for real-time and batch processing workloads.
o Collaborate with backend developers to build seamless integrations with PostgreSQL.
o Support APIs and microservices by designing effective database interaction layers .
o Work on ETL pipelines and data transformation tasks.
o Write unit tests for queries and procedures using tools like pgTAP .
o Ensure data consistency and accuracy across environments.
o Perform code reviews for SQL scripts and database logic.
o Partner with product teams to translate business requirements into efficient database solutions .
o Document database designs, queries, and logic for maintainability.
o Provide technical guidance to junior developers and peers on best practices in SQL coding .
Primary Skills :
Secondary Skills :
Software Engineer • vijayawada, andhra pradesh, in