PostgreSQL Developer – L2

Job Summary

We are seeking a skilled and experienced PostgreSQL Developer (Level 2) with 4–5 years of hands-on experience in database development and optimization. The ideal candidate will be responsible for developing, maintaining, and improving PostgreSQL-based database solutions, supporting high-performance applications, and assisting with architecture and automation initiatives.

Key Responsibilities

• Design, develop, and optimize complex SQL queries, stored procedures, triggers, and PL/pgSQL functions.
• Collaborate with architects and application developers to define efficient schema designs and data models.
• Perform advanced performance tuning using EXPLAIN, ANALYZE, pg_stat_statements, and indexing strategies.
• Implement and maintain ETL processes for structured and semi-structured data.
• Manage large-scale data migrations and version-controlled schema deployments.
• Conduct capacity planning and monitoring to maintain database health and scalability.
• Implement and manage backup/restore policies, disaster recovery testing, and high availability configurations.
• Work with DevOps teams to integrate database changes into CI/CD pipelines.
• Mentor junior developers and participate in peer code reviews.

Technical Skills Required

• Strong expertise in PostgreSQL SQL and PL/pgSQL programming.
• Deep understanding of PostgreSQL internals: query planner, indexing, vacuum/analyze, and WAL.
• Experience with partitioning, parallel queries, table inheritance, and advanced types (JSONB, ARRAY).
• Proficient in performance tuning, database normalization/denormalization, and query optimization.
• Experience with replication mechanisms: streaming replication, logical replication, or BDR.
• Good knowledge of PostgreSQL backup and recovery strategies using pg_basebackup, pgBackRest, or Barman.
• Experience with monitoring tools like pg_stat_activity, pgBadger, Prometheus + Grafana, or Zabbix.

Preferred / Additional Skills

• Scripting experience (Bash, Python, or Shell) for automation tasks.
• Familiarity with cloud-native PostgreSQL (AWS RDS, Aurora, GCP Cloud SQL, Azure PostgreSQL).
• Exposure to Kubernetes-managed database environments.
• Experience working in Agile environments and participating in Scrum ceremonies.

Soft Skills

• Excellent problem-solving and root cause analysis capabilities.
• Strong written and verbal communication skills.
• Ability to work independently and as part of a cross-functional team.
• Mentorship and collaboration with junior team members.
• Customer-focused mindset with strong multitasking ability.

Education

• Bachelor's degree in Computer Science, Information Technology, or related field.
• PostgreSQL certifications are a plus.