Senior Developer - PostgreSQL

Description :

Location : Hyderabad / Chennai WFO.

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.