Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

VIEW WINNERS
- ABECA 2025
  
  VIEW WINNERS
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
Participate in ABECA 2026

Add office photos

Employer? Claim Account for FREE

Data Dynamics Software Solutions

Compare

3.8

based on 51 Reviews

11 Data Dynamics Software Solutions Jobs

PostgreSQL Architecture & Design

Data Dynamics

3.8

based on 51 Reviews

8-10 years

Pune

1 vacancy

PostgreSQL Architecture & Design

Data Dynamics Software Solutions

posted 3+ weeks ago

Job Role Insights

Flexible timing

Key skills for the job

Python SQL Automation Testing CCTV Monitoring Postgresql Disaster Recovery

+ 3 more

Job Description

We are seeking a highly experienced PostgreSQL Database Architect & Designer with 8-10 years of relevant experience to design, implement, and optimize high-performance, scalable, and secure PostgreSQL database solutions. The ideal candidate will be responsible for database architecture, high availability, query optimization, performance tuning, and database security. You will play a key role in designing robust data solutions while ensuring high availability and disaster recovery strategies.

Key Responsibilities

Architect and implement scalable, resilient, and high-performance PostgreSQL databases.
Define and optimize database schema, indexing strategies, and partitioning techniques.
Design and manage multi-node PostgreSQL deployments for high availability.

Optimize SQL queries, indexing, and caching to improve database performance.
Perform query execution plan analysis and optimization.
Fine-tune PostgreSQL settings (vacuum, autovacuum, connection pooling) for better resource utilization.

High Availability & Replication

Implement Streaming Replication, Logical Replication, and Failover mechanisms using Patroni or other HA tools.
Develop disaster recovery and backup strategies using pgBackRest, Barman, and PITR (Point-in-Time Recovery).

Implement Role-Based Access Control (RBAC), SSL/TLS encryption, and auditing.
Ensure compliance with GDPR, HIPAA, and other data security standards.

Set up database monitoring, logging, and alerting using pg_stat_statements, pgAudit, Prometheus, and Grafana.
Proactively conduct database health checks, performance tuning, and maintenance.

Deploy and manage PostgreSQL on AWS RDS, Aurora PostgreSQL, Azure Database for PostgreSQL, or Google Cloud SQL.
Automate database provisioning and scaling using Terraform, Ansible, Kubernetes, and Helm.

Implement Sharding, Table Partitioning, and Read Replicas for scaling PostgreSQL.
Use PgBouncer, Pgpool-II for connection pooling and load balancing.

Work with JSONB, Full-Text Search (tsvector), and GIN/GiST indexing for advanced search capabilities.
Implement PostGIS for geospatial data processing.
Leverage pgvector for AI-driven similarity search.