Senior Database Developer

Linnk Group; Ernakulam; On-site; INR 4,000,000 - 7,000,000; Full time

Job summary

Linnk Group in India seeks a Senior Database Administrator and Developer with 10+ years' PostgreSQL experience, including performance tuning and production support, and hands-on exposure to vector-based search with pgvector.

This role focuses on optimizing schemas, queries, and HA strategies, managing Amazon RDS for PostgreSQL, and collaborating with DevOps, ML, and application teams to enable scalable data access.

Qualifications

• 10+ years of hands-on experience as a PostgreSQL DBA/Developer.
• Strong expertise in PostgreSQL internals, performance tuning, and production support.
• Experience with pgvector or vector-based retrieval systems.
• Proficiency in SQL, shell scripting, and working knowledge of Python.
• Strong troubleshooting skills with ownership mindset.

Responsibilities

• Design, develop, and optimize PostgreSQL schemas, queries, functions, and indexing strategies.
• Analyze and improve query performance using execution plans and tuning techniques.
• Implement partitioning, replication, and high-availability strategies.
• Manage and optimize Amazon RDS for PostgreSQL in production environments.
• Develop database automation and data pipelines using SQL and Python.
• Collaborate with DevOps, application, and ML teams to support scalable data access and vector search use cases.

Skills

PostgreSQL DBA/Developer

Performance tuning

pgvector

SQL

Shell scripting

Python

Production support

Tools

PostgreSQL

Amazon RDS

pgvector

Python

SQL

Shell scripting

Job description

Employment Type: Permanent

Role Overview

We are seeking a highly experienced Senior Database Administrator & Developer with deep expertise in PostgreSQL to optimize, scale, and support our product's database architecture. The ideal candidate will have strong performance tuning experience and hands-on exposure to pgvector for vector-based search capabilities in production environments.

Key Responsibilities

• Design, develop, and optimize PostgreSQL schemas, queries, functions, and indexing strategies.
• Analyze and improve query performance using execution plans and tuning techniques.
• Implement partitioning, replication, and high-availability strategies.
• Manage and optimize Amazon RDS for PostgreSQL in production environments.
• Develop database automation and data pipelines using SQL and Python.
• Collaborate with DevOps, application, and ML teams to support scalable data access and vector search use cases.

Required Qualifications

• 10+ years of hands-on experience as a PostgreSQL DBA/Developer.
• Strong expertise in PostgreSQL internals, performance tuning, and production support.
• Experience with pg vector or vector-based retrieval systems.
• Proficiency in SQL, shell scripting, and working knowledge of Python.
• Strong troubleshooting skills with a proactive, ownership-driven mindset.