Role & responsibilities
7+ years of hands-on experience in PostgreSQL Database Development.
Robust 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.
Robust knowledge of PostgreSQL architecture, MVCC, WAL, Vacuum, and Autovacuum.
Experience with indexing strategies, partitioning, normalization, and database design.