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. 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) 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. Analyze and fine-tune PostgreSQL database parameters (e.g., 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). Work with developers to design efficient SQL and database access patterns. 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 . 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., Familiar with cloud deployments (Azure Database for PostgreSQL, and on-prem setups). ~ 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?