Senior PostgreSQL DBA Architect

Job description

Sonata Software Overview

In today's market, there is a unique duality in technology adoption.

On one side, extreme focus on cost containment by clients, and on the other, deep motivation to modernize their Digital storefronts to attract more consumers and B2B customers.

As a leading Modernization Engineering company, we aim to deliver modernization-driven hypergrowth for our clients based on the deep differentiation we have created in Modernization Engineering, powered by our Lightening suite and 16-step Platformation™ playbook.

In addition, we bring agility and systems thinking to accelerate time to market for our clients.

Headquartered in Bengaluru, India, Sonata has a strong global presence, including key regions in the US, UK, Europe, APAC, and ANZ.

We are a trusted partner of world-leading companies in BFSI (Banking, Financial Services, and Insurance), HLS (Healthcare and Lifesciences), TMT (Telecom, Media, and Technology), Retail & CPG, and Manufacturing space.

Our bouquet of Modernization Engineering Services cuts across Cloud, Data, Dynamics, Contact Centers, and around newer technologies like Generative AI, MS Fabric, and other modernization platforms.

Senior PostgreSQL Database Administrator (DBA)

About:

We are looking for a Senior PostgreSQL DBA with deep expertise in database performance tuning, production stability, and advanced configuration management .

The ideal candidate will take ownership of Postgres optimization across production workloads , ensuring high performance, reliability, and scalability of mission-critical systems.

You will work closely with application teams, DevOps, and infrastructure engineers to provide data-driven recommendations , identify bottlenecks , and fine-tune PostgreSQL server parameters, indexes, and queries for optimal performance.

Key Responsibilities

• Analyze and fine-tune PostgreSQL database parameters (e.g., shared_buffers, work_mem, effective_cache_size, autovacuum, checkpoint settings, etc.) to improve throughput and stability.
  
  
• Perform query and index optimization and recommend schema or partitioning strategies for large-scale data.
  
  
• Conduct comprehensive performance audits using pg_stat_statements, EXPLAIN ANALYZE, and OS-level metrics (I/O, CPU, memory, connections).
  
  
• Review and recommend best practices for connection pooling (e.g., PgBouncer, PgPool) and replication setups.
  
  
• Proactively monitor production environments , identify anomalies, and implement tuning adjustments or corrective actions.
  
  
• Work with developers to design efficient SQL and database access patterns.
  
  
• Establish and maintain maintenance plans (vacuum, analyze, reindex, etc.) and backup/recovery strategies .
  
  
• Provide recommendations on HA (High Availability) , failover , and disaster recovery architectures.
  
  
• Benchmark and test PostgreSQL versions, extensions, and configurations for performance impact before production rollout.
  
  
• Collaborate with SRE/DevOps teams to automate monitoring, scaling, and alerting using tools like Prometheus, Grafana, or pgMonitor .
  
  
• Document findings, create tuning guides, and mentor junior DBAs or developers.
  
  

Required Skills and Experience

• 12+ years of DBA experience, with 5+ years in PostgreSQL administration on Linux-based systems.
  
  
• Proven expertise in Postgres configuration tuning and performance optimization .
  
  
• Strong SQL and query plan analysis skills.
  
  
• Hands-on experience with replication (streaming, logical) and partitioning strategies .
  
  
• Familiar with PostgreSQL internals , transaction management, vacuum processes, and WAL configuration.
  
  
• Experience with large datasets and high-traffic production environments .
  
  
• Proficiency with pg_stat_statements , EXPLAIN/EXPLAIN ANALYZE , and pgBadger or similar analysis tools.
  
  
• Working knowledge of Linux performance tuning , file systems , and I/O subsystems .
  
  
• Experience with backup/recovery tools (e.g., pgBackRest, Barman) and HA solutions (Patroni, repmgr, etc.).
  
  
• Familiar with cloud deployments (Azure Database for PostgreSQL, and on-prem setups).
  
  
• Excellent problem-solving and communication skills.
  
  

Preferred Qualifications

• Knowledge of database observability tools (Prometheus, Grafana, pg_stat_monitor, etc.).
  
  
• Experience with CI/CD for database schema management (Liquibase, Flyway).
  
  
• Exposure to PostgreSQL extensions (pg_partman, pg_stat_kcache, timescaledb, etc.).
  
  
• Experience tuning OLTP and analytical (OLAP) workloads.
  
  
• Contributions to the PostgreSQL community or open-source tools.
  
  

Why join Sonata Software?

At Sonata, you´ll have an outstanding opportunity.

The chance to use your skills and imagination to push the boundaries of what´s possible.

To build never seen before solutions to some of the world’s toughest problems.

You´ll be challenged, but you will not be alone.

You´ll be joining a team of diverse innovators, all driven to go beyond the status quo to craft what comes next.

Required Skill Profession

Prb