Job Description
About Us:
Linnk Group is a Global STEM Recruitment Consultancy with established local entities in the UAE, KSA, Qatar, India, and London. We specialize in providing expert talent for next- generation initiatives across the globe. We focus on on-site and remote resources in Digital Transformation, AI, ML, Data Science, DevOps, Cloud, Security, Products, Project Management, Business Analysis, Architecture, Product Development, and Engineering specialties.
Role Overview:
We are seeking a highly experienced and hands-on
Senior PostgreSQL Database Developer
with 10+ years of experience managing and optimizing mission-critical database systems. The ideal candidate will have deep expertise in PostgreSQL (9.5+), AWS RDS, performance tuning, disaster recovery architectures, and automation. This role requires strong ownership, production support experience, and the ability to collaborate effectively with application, DevOps, and ML teams to ensure scalable, secure, and high-performing database environments.
Key Responsibilities:
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 cross–data center 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.
·
Optimize 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 optimize PostgreSQL schemas, queries, functions, and indexes.
·
Analyze 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.
