Software Engineer

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

• Database Design & Development

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 :