PostgreSQL Database Developer

We are seeking an experienced PostgreSQL Database Developer with strong expertise in PostgreSQL, SQL, PL/pgSQL, Database Performance Tuning, Query Optimization, and Database Design. The ideal candidate will be responsible for designing, developing, optimizing, and maintaining enterprise-grade PostgreSQL database solutions supporting business-critical applications.

The role requires deep understanding of PostgreSQL architecture, database performance tuning, high availability, replication, backup & recovery, and advanced database development techniques.

Key Responsibilities

Database Development

• Design, develop, and maintain PostgreSQL database solutions for enterprise applications.
  
• Create and optimize:
  
• Stored Procedures
• Functions
• Triggers
• Views
• Materialized Views
• Develop efficient SQL and PL/pgSQL code following best practices.
  
• Support database migrations, deployments, and release activities.
  

Database Design & Architecture

• Design scalable, secure, and high-performance database schemas.
• Implement data modeling, normalization, and database design best practices.
• Design partitioning strategies and indexing structures for large-scale databases.
• Work closely with development and architecture teams to support application requirements.

Performance Optimization

• Analyze and optimize complex SQL queries.
• Perform execution plan analysis using EXPLAIN ANALYZE.
• Troubleshoot database performance bottlenecks and production issues.
• Optimize indexing, query execution, and database resource utilization.

PostgreSQL Administration & Operations

• Manage and support:
  
• Backup & Recovery
• Replication
• High Availability Solutions
• Disaster Recovery Planning
• Monitor database health and implement proactive maintenance activities.
  
• Work with PostgreSQL internals including:
  
• MVCC
• WAL
• Vacuum
• Autovacuum

Security & Governance

• Ensure database security, integrity, and compliance standards.
• Implement access controls, security policies, and database governance practices.
• Support audit and compliance requirements.

Collaboration & Documentation

• Collaborate with application development, DevOps, and infrastructure teams.
• Participate in Agile ceremonies and sprint activities.
• Create technical documentation and knowledge-sharing materials.
• Support incident resolution and production support activities.

Required Skills

• 6+ years of experience in PostgreSQL Database Development.
  
• Strong expertise in:
  
• PostgreSQL
• SQL
• PL/pgSQL
• Hands-on experience with:
  
• Stored Procedures
• Functions
• Triggers
• Views
• Materialized Views
• Strong experience in:
  
• Query Optimization
• Performance Tuning
• Execution Plan Analysis
• Deep understanding of:
  
• PostgreSQL Architecture
• MVCC
• WAL
• Vacuum
• Autovacuum
• Experience with:
  
• Indexing
• Partitioning
• Database Design
• Normalization
• Knowledge of:
  
• Backup & Recovery
• Replication
• High Availability
• Disaster Recovery
• Experience working with JSON and JSONB data types.
  
• Familiarity with Git, Agile, Scrum, and CI/CD practices.
  

Preferred Skills

• Cloud-hosted PostgreSQL databases (AWS RDS, Azure PostgreSQL, GCP Cloud SQL).
• Database Migration projects.
• DevOps and Database Automation.
• Monitoring and Observability tools.
• Enterprise-scale database environments.

Desired Candidate Profile

• Strong analytical and troubleshooting skills.
• Excellent communication and collaboration skills.
• Ability to work independently and manage production-critical environments.
• Strong attention to detail and database reliability.
• Experience working in Agile delivery teams.