PostgreSQL Database Engineer

A typical PostgreSQL Database Engineer job description includes the following responsibilities and skills:ResponsibilitiesDesign, develop, and maintain PostgreSQL databases for production applications.Create and optimize database schemas, tables, indexes, constraints, and partitions.Write efficient SQL queries, stored procedures, functions (PL/pgSQL), and triggers.Monitor and tune database performance using query analysis and indexing strategies.Configure replication, backup, recovery, and high-availability solutions.Perform database migrations, upgrades, and patching.Troubleshoot production issues and ensure database reliability and security.Collaborate with backend developers, DevOps, and SRE teams on application integration and database design.Required SkillsStrong experience with PostgreSQL administration and development.Advanced SQL and PL/pgSQL programming.Query optimization and performance tuning using EXPLAIN/EXPLAIN ANALYZE.Indexing techniques (B-tree, GIN, GiST, BRIN, Hash).Backup and recovery tools (pg_dump, pg_restore, PITR).Replication (Streaming Replication, Logical Replication).Linux administration and shell scripting.Experience with Python, Go, Java, or Node.js for database integration.Version control (Git).