Software Engineer

Job Description

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. ? Performance Optimization 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. ? Application Development Integration 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. ? Testing & Quality Assurance 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. ? Collaboration & Delivery 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 . o Primary Skills: ? Strong expertise in PostgreSQL development (schemas, functions, triggers, views, stored procedures). ? Advanced skills in SQL query writing and optimization . ? Hands-on experience with query execution plans and indexing strategies . ? Experience in data modeling, relational design, and query performance tuning . ? Strong knowledge of transactions, concurrency control, and isolation levels . ? Exposure to application development with PostgreSQL (integration with Java, Python, or other languages). ? Exposure to cloud-hosted PostgreSQL services (AWS RDS/Aurora, GCP Cloud SQL/Spanner). ? Extensive experience in database performance improvement . ? Experience in Migration from Legacy DB to Postgres DB ? Hands-on experience with shell scripting ? knowledge on Elastics Search Secondary Skills: ? Working knowledge of unit testing frameworks for SQL logic (pgTAP, DbUnit). ? Experience with PostgreSQL extensions (PostGIS, pg_stat_statements, pg_trgm, TimescaleDB) ? Experience with database backup, recovery, and high availability solutions ? Proficiency in database security best practices and access control ? Knowledge of ETL tools (Apache Airflow, Talend, dbt) and data pipelines . ? Familiarity with message brokers like Kafka/ActiveMQ for streaming integration. ? Good understanding of CI/CD pipelines for database code deployment.