Hands-on maintenance of PostgreSQL databases, ensuring uptime, reliability, and performance.
Design and implement procedures for backup, failover, and recovery to deliver data integrity and business continuity.
Provide hands-on database expertise to development teams, advising on schema design, indexing, and query optimization.
Proactively monitor database health and performance; identify and resolve issues before they impact production.
Collaborate with internal teams and service providers (AWS, Enterprise DB etc.) in the resolution of issues
Work closely with DevOps and Engineering to integrate safe database change processes into delivery pipelines
Establish and document database standards, policies, and best practices.
Contribute to the broader data architecture strategy as the organization scales and evolves.
Recommend and implement best practices for data security, compliance, and scalability.
Define, agree and maintain improvement roadmap for the database estate.
Proven experience required
6+ years of hands-on experience working with PostgreSQL in complex, production environments.
Demonstrable expertise in hands-on operations, managing the ongoing hygiene of a postgreSQL estate including backup, point-in-time recovery, replication and failover - ideally with Barman and a PG load balancer.
Deep technical knowledge of PostgreSQL internals with experience in query optimization, indexing strategies, and performance tuning of DB instance and host parameters.
Experience working with cloud-based and/or containerized infrastructure
Proficient in scripting (e.g., Bash, Python) to automate database operations and maintenance tasks.
Solid understanding of Linux system administration as it relates to database performance and configuration.
Demonstrates the drive and ability to independently identify required work, negotiate priorities and efficiently deliver on agreed objectives.
Strong communication skills, with the ability to explain database concepts and trade-offs to both technical and non technical stakeholders.
Desirable:
Exposure to other database technologies (e.g., MySQL, MongoDB, Redis).
Experience with observability and monitoring tools (e.g., Prometheus, Grafana, pg_stat_statements).
Experience with infrastructure-as-code techniques (e.g. Terraform, Ansilble)
Working Conditions
Office based: 5 days in Kochi office and shift time will be from 11 am to 8pm IST
Job Types: Full-time, Permanent
Pay: ₹3,500,000.00 - ₹4,200,000.00 per year
Benefits:
Commuter assistance
Health insurance
Paid sick time
Provident Fund
Ability to commute/relocate:
Ernakulam, Kerala: Reliably commute or planning to relocate before starting work (Required)
Application Question(s):
Any experience in using Barman and a PG load balancer?
what is your Notice Period?
Experience:
total : 6 years (Required)
Database administration: 6 years (Required)
PostgreSQL database: 6 years (Required)
Work Location: In person
Job Types: Full-time, Permanent
Pay: ₹3,500,000.00 - ₹4,200,000.00 per year
Benefits:
Health insurance
Provident Fund
Application Deadline: 30/09/2025
Expected Start Date: 30/09/2025
Beware of fraud agents! do not pay money to get a job
MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.