Database Administrator

Database Administrator / Database Developer (PostgreSQL)

Kochi, Kerala (On-Site)

Database Administrator (DBA) Responsibilities

• Manage end-to-end PostgreSQL lifecycle: provisioning, configuration, upgrades/downgrades, and maintenance.
• Hands-on experience with multiple PostgreSQL versions (9.5+) in production environments.
• Implement and manage backup, recovery, and PITR strategies; regularly test restores.
• Design and operate crossdata centre DR and backup architectures.
• Perform data migrations during version upgrades/downgrades with minimal downtime.
• Administer PostgreSQL on AWS RDS, including monitoring, parameter tuning, backups, and failover.
• Handle schema management, database sizing, and capacity planning.
• Optimise performance through query tuning, indexing, autovacuum, and bloat management.
• Automate operational tasks using shell scripting on Linux and Windows.
• Ensure database security using RBAC, TLS, encryption, and audit logging.

Database Developer Responsibilities

• Design, develop, and optimise PostgreSQL schemas, queries, functions, and indexes.
• Analyse and improve query performance using execution plans and indexing strategies.
• Work with advanced PostgreSQL features, including partitioning and replication.
• Develop and maintain database-related automation and data pipelines using SQL and Python.
• Collaborate with application, DevOps, and ML teams to support scalable data access patterns.
• Experience with pgvector or vector-based retrieval systems is a plus.

Required Qualifications

• 10+ years of hands-on experience with PostgreSQL as a DBA and/or DB Developer.
• Strong expertise in PostgreSQL internals, performance tuning, and operations.
• Experience with AWS RDS for PostgreSQL in production.
• Proficiency in SQL, shell scripting, and working knowledge of Python.
• Strong troubleshooting, ownership, and production support mindset.
• Tech Stack: PostgreSQL (9.5+), AWS RDS, Linux/Windows, Shell Scripting, SQL, Python