PostgreSQL Developer – L2

Bharathcloud; Hyderabad; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Bharathcloud is seeking a skilled PostgreSQL Developer (Level 2) with 4–5 years of hands-on experience to design, build, and optimize PostgreSQL-based database solutions for high-performance applications.

The role involves collaborating with architects and developers to craft efficient schemas, performing in-depth performance tuning, and implementing robust backup/recovery and DR plans. You will mentor peers and contribute to CI/CD processes within a cloud-enabled environment.

Qualifications

• 4–5 years of hands-on experience in database development and optimization.
• Experience developing PostgreSQL-based database solutions for high-performance applications.
• Experience with architecture and automation initiatives.

Responsibilities

• Design, develop, and optimize complex SQL queries, stored procedures, triggers, and PL/pgSQL functions.
• Collaborate with architects and 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.

Skills

PostgreSQL SQL PL/pgSQL

Query optimization

Partitioning & parallel queries

Replication concepts

Performance tuning

Automation scripting

Agile / Scrum

Education

Bachelor's degree in CS/IT

Tools

pgBaseBackup

pgBackRest

Barman

Prometheus

Grafana

Zabbix

Job description

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.