Contenterra Software Pvt Ltd
Sr PostgreSQL Database Administrator
Company
Role
Sr PostgreSQL Database Administrator
Location
Job type
Full-time
Found on Mokaru
3 months ago
Salary
Job description
Job Description: Job Title: Senior PostgreSQL Database Administrator Location: Hyderabad Industry: IT Services & Consulting Employment Type: Full-Time Role Category: DBA / Database Engineering Note: Based on business requirements, this role may involve working in different shift timings. Job Summary We are seeking a Senior PostgreSQL Database Administrator to manage, optimize, and support PostgreSQL databases deployed across distributed and edge-node environments. The role requires strong hands-on expertise in PostgreSQL operations, replication, performance tuning, and high availability in production systems. Key Responsibilities Install, configure, upgrade, and maintain PostgreSQL databases across multiple environments Manage PostgreSQL databases deployed at edge nodes and central systems Design and maintain replication, synchronization, and data consistency mechanisms Monitor and tune database performance, queries, and indexes Implement and manage backup, recovery, and disaster recovery strategies Ensure database security, access controls, and compliance best practices Automate routine DBA tasks using scripting and tooling Troubleshoot production issues and perform root cause analysis Collaborate with application and platform teams on schema and query design Required Skills & Experience 7+ years of DBA experience with 4+ years on PostgreSQL in production Strong knowledge of PostgreSQL internals, MVCC, WAL, vacuuming, and indexing Hands-on experience with PostgreSQL replication and high availability setups Proven expertise in performance tuning and query optimization Experience with backup and recovery tools (pg_dump, pg_restore, pg_basebackup) Proficiency in scripting (Shell, Python, or equivalent) Experience supporting distributed or multi-node database deployments Nice to Have Experience with edge computing or geographically distributed systems Exposure to cloud or containerized PostgreSQL deployments Prior experience migrating from SQL Server or other RDBMS to PostgreSQL


