Senior PostgreSQL DBA Architect

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:

Senior PostgreSQL DBA

data-driven recommendations

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.