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

📌 PostgreSQL Database Developer (Bengaluru)
🏢 Tata Consultancy Services
📍 Bengaluru