PostgreSQL Dba

**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**:
**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.