Job
Description
Role Overview: As a Senior PostgreSQL Database Administrator (DBA) at Sonata Software, you will be responsible for optimizing Postgres performance across production workloads to ensure high performance, reliability, and scalability of mission-critical systems. You will collaborate 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 like shared_buffers, work_mem, effective_cache_size, autovacuum, and checkpoint settings to enhance throughput and stability. - Perform query and index optimization and suggest schema or partitioning strategies for large-scale data. - Conduct comprehensive performance audits using tools like pg_stat_statements, EXPLAIN ANALYZE, and OS-level metrics (I/O, CPU, memory, connections). - Review and advise on 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. - Collaborate 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. - Work 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. Qualification Required: - 12+ years of DBA experience, with at least 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. - Familiarity 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.). - Familiarity with cloud deployments (Azure Database for PostgreSQL, and on-prem setups). - Excellent problem-solving and communication skills. Note: No additional details about the company were provided in the job description.,
