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(TM) 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, youll have an outstanding opportunity. The chance to use your skills and imagination to push the boundaries of whats possible. To build never seen before solutions to some of the world's toughest problems. Youll be challenged, but you will not be alone. Youll be joining a team of diverse innovators, all driven to go beyond the status quo to craft what comes next.