PostgreSQL Developer – L2

We are seeking a skilled and experienced Postgre

SQL 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 Postgre

SQL-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, _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 Dev Ops teams to integrate database changes into CI/CD pipelines.

• Mentor junior developers and participate in peer code reviews.

Technical

Skills Required:

• Strong expertise in Postgre

SQL SQL and PL/pgSQL programming.

• In-depth understanding of Postgre

SQL 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 Postgre

SQL backup and recovery strategies using , pgBackRest, or Barman.

• Experience with monitoring tools like _activity, pg Badger, Prometheus + Grafana, or Zabbix.

Preferred/Additional

Skills:

• Scripting experience (Bash, Python, or Shell) for automation tasks.

• Familiarity with cloud-native Postgre

SQL (AWS RDS, Aurora, GCP Cloud SQL, Azure Postgre

SQL).

• 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.

• Postgre

SQL certifications (optional but a plus).