Postgre DB Developer

Overall Experience: 6+
Location: Bangalore
Notice Period: 0-30 Days only
Job Requirements*
 6+ years of hands-on experience in PostgreSQL Database Development.
 Strong expertise in PostgreSQL, SQL, and PL/pgSQL programming.
 Experience in creating and maintaining Stored Procedures, Functions, Triggers, Views, and Materialized Views.
 Expertise in query optimization, performance tuning, and execution plan analysis using EXPLAIN ANALYZE.
 Strong knowledge of PostgreSQL architecture, MVCC, WAL, Vacuum, and Autovacuum.
 Experience with indexing strategies, partitioning, normalization, and database design.
 Knowledge of Backup & Recovery, Replication, High Availability, and Disaster Recovery.
 Experience working with JSON/JSONB data types and advanced PostgreSQL features.
 Familiarity with Git, Agile/Scrum methodologies, and CI/CD practices.
 Exposure to cloud-hosted PostgreSQL databases is preferred.
Key Responsibilities*
 Develop, maintain, and optimize PostgreSQL database solutions.
 Design and implement complex SQL queries, stored procedures, functions, and triggers.
 Monitor and tune database performance for large-scale applications.
 Analyze and resolve database bottlenecks and production issues.
 Design scalable and efficient database schemas.
 Implement backup, recovery, replication, and high availability solutions.
 Collaborate with application development and infrastructure teams.
 Ensure database security, integrity, and compliance standards.
 Support deployment, migration, and release activities.
 Create technical documentation and promote knowledge sharing.

Work arrangement
No