Job
Description
Role Overview: As a Senior PostgreSQL Database Administrator (DBA) at Sonata Software, you will be responsible for optimizing and maintaining PostgreSQL databases to ensure high performance, reliability, and scalability of mission-critical systems. You will work closely with application teams, DevOps, and infrastructure engineers to analyze, fine-tune, and optimize database parameters, indexes, and queries. Key Responsibilities: - Analyze and fine-tune PostgreSQL database parameters such as shared_buffers, work_mem, and autovacuum 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 tools like pg_stat_statements, EXPLAIN ANALYZE, and OS-level metrics. - Review and recommend best practices for connection pooling and replication setups. - Proactively monitor production environments, identify anomalies, and implement tuning adjustments. - Work with developers to design efficient SQL and database access patterns. - Establish and maintain maintenance plans and backup/recovery strategies. - Provide recommendations on HA, failover, and disaster recovery architectures. - Benchmark and test PostgreSQL versions, extensions, and configurations for performance impact. - Collaborate with SRE/DevOps teams to automate monitoring, scaling, and alerting. - Document findings, create tuning guides, and mentor junior DBAs or developers. Qualifications Required: - 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 and partitioning strategies. - Familiarity with PostgreSQL internals, transaction management, and vacuum processes. - Experience with large datasets and high-traffic production environments. - Proficiency with pg_stat_statements, EXPLAIN/EXPLAIN ANALYZE, and pgBadger or similar tools. - Working knowledge of Linux performance tuning and file systems. - Experience with backup/recovery tools and HA solutions. - Familiarity with cloud deployments. - Excellent problem-solving and communication skills. Additional Details: Sonata Software is a leading Modernization Engineering company headquartered in Bengaluru, India, with a strong global presence. They specialize in delivering modernization-driven hypergrowth for clients in various industries, including BFSI, HLS, TMT, Retail & CPG, and Manufacturing. Sonata offers a bouquet of Modernization Engineering Services focusing on Cloud, Data, Dynamics, Contact Centers, and newer technologies like Generative AI and MS Fabric. Joining Sonata means being part of a team of diverse innovators who are driven to craft innovative solutions and push the boundaries of what's possible.,
