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.

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.