Job Title: PostgreSQL Developer – L2
Experience: 4 to 5 Years
Job Type: Full-time
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.
• In-depth understanding of PostgreSQL internals: query planner, indexing, vacuum/analyze, and WAL.
• Experience with partitioning, parallel queries, table inheritance, and advanced types (JSONB, ARRAY).
• Proficient with 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.
• Ability to work independently and as part of a cross-functional team.
• Mentorship and collaboration with junior team members.
• Customer-focused and able to manage multiple priorities in a fast-paced environment.
Education:
• Bachelor’s degree in Computer Science, Information Technology, or related discipline.
• PostgreSQL certifications (optional but a plus).