PostgreSQL Database Specialist

Kaapro Management Solutions Pvt. Ltd.; Surat; On-site; INR 1,800,000 - 3,000,000; Full time

Benefits offered by this job

Coverage for Self + Family

Generous leave benefits

Employee referral program

Job summary

Kaapro Management Solutions Pvt. Ltd. is seeking a PostgreSQL Database Specialist to own design, performance, and operational health of our PostgreSQL estate. You will work across managed Azure/AWS services and self-managed deployments, ensuring fast, secure, and highly available systems.

You will design schemas, write complex SQL/PL/pgSQL, tune performance, and implement robust backup, replication, and HA strategies for multi-tenant financial workloads.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or related field.
• 4+ years of hands-on experience with PostgreSQL in design, development, and administration.
• Experience operating managed PostgreSQL in cloud (Azure/AWS) and self-managed deployments.
• Strong Linux and shell scripting capabilities for independent troubleshooting.
• Proficient SQL/PL/pgSQL with advanced query optimization and indexing strategies.

Responsibilities

• Design, develop and maintain PostgreSQL schemas for high-volume, multi-tenant workloads.
• Write complex SQL/PL/pgSQL, triggers, views, and materialized views for data needs.
• Tune performance, analyze slow queries, and optimize server parameters and indexing.
• Provision and manage cloud PostgreSQL in Azure/AWS and implement HA/DR.
• Build and operate HA clusters using Patroni or similar tools and manage backups.

Skills

PostgreSQL

SQL

PL/pgSQL

Linux

Patroni

Performance tuning

Cloud (Azure AWS)

Backup & Recovery

HA clustering

Replication

Education

Bachelor's degree in Computer Science / IT

Tools

pgBackRest

Barman

WAL-G

Patroni

pg_auto_failover

Job description

Role Overview

We are seeking a skilled PostgreSQL Database Specialist to own the design, performance, and operational health of our PostgreSQL estate. The ideal candidate has deep hands‑on experience running PostgreSQL in both deployment models:

• Managed cloud services Azure Database for PostgreSQL (Flexible Server) and AWS RDS for PostgreSQL / Aurora PostgreSQL.
• Self‑managed / standalone installations PostgreSQL installed and operated directly on Linux VMs, bare metal, or containers, where you own everything from the OS up.

They should be equally comfortable writing complex SQL and PL/pgSQL as they are tuning autovacuum, configuring a Patroni cluster, planning a zero‑downtime major version upgrade, or debugging a replication lag alert at 2 AM.

You will work closely with our engineering teams to ensure our multi‑tenant, high‑transaction trading and CRM platforms remain fast, secure, and highly available.

Responsibilities

• Database Design & Development: Design, develop, and maintain PostgreSQL schemas that support high‑volume, multi‑tenant financial workloads — including normalization, data modelling, constraints, declarative partitioning, and appropriate use of native types (JSONB, arrays, ranges, UUID, enums).
• SQL & PL/pgSQL Development: Write and review complex SQL, PL/pgSQL functions and procedures, triggers, views, and materialized views to support data extraction, reporting, and system integration needs.
• Performance Optimization: Analyze and tune slow queries using EXPLAIN (ANALYZE, BUFFERS), pg_stat_statements, and auto_explain. Design effective indexing strategies (B‑tree, GIN, GiST, BRIN, partial, expression, and covering indexes), manage table/index bloat, tune autovacuum, and optimize server parameters (shared_buffers, work_mem, effective_cache_size, checkpoint and WAL settings).
• Cloud Database Administration (Azure & AWS): Provision, configure, and operate managed PostgreSQL instances in the cloud, including:
  • Azure: Azure Database for PostgreSQL – Flexible Server; zone‑redundant and same‑zone HA, read replicas, server parameter groups, built‑in PgBouncer, storage/IOPS scaling, private endpoints and VNet integration, Azure Monitor and Log Analytics, Azure Backup and point‑in‑time restore.
  • AWS: Amazon RDS for PostgreSQL and Aurora PostgreSQL; Multi‑AZ deployments and failover, read replicas and Aurora reader endpoints, parameter/option groups, RDS Proxy, snapshots and PITR, Performance Insights, CloudWatch metrics and alarms, IAM database authentication, Secrets.
• Standalone / Self‑Managed PostgreSQL Administration: Install, configure, harden, and operate PostgreSQL directly on Linux servers (on‑premise, VMs, or cloud IaaS) without a managed service layer,including:
  • End‑to‑end installation and upgrade of PostgreSQL from packages or source; management of postgresql.conf, pg_hba.conf, and pg_ident.conf.
  • OS‑level tuning for database workloads — kernel parameters, hugepages, filesystem and storage layout, tablespaces, I/O scheduler, memory and swap configuration, ulimits, and systemd service management.
  • Building and operating HA clusters using tools such as Patroni, repmgr, or pg_auto_failover, with etcd/Consul, and HAProxy / Keepalived / virtual IPs for failover and connection routing.
  • Backup and recovery using pgBackRest, Barman, WAL‑G, or pg_basebackup, with WAL archiving and validated point‑in‑time recovery.
  • Independent monitoring, alerting, and log management (Prometheus + postgres_exporter, Grafana,pgBadger, Zabbix, Nagios, or similar), since no cloud‑native metrics are provided.
  • Capacity planning, patching, security hardening, and OS/database lifecycle management.
• High Availability, Backup & Recovery: Design and regularly test backup, restore, and disaster recovery procedures. Manage streaming and logical replication, WAL archiving, PITR, failover/switchover runbooks, and defined RPO/RTO targets.
• Upgrades & Migrations: Plan and execute PostgreSQL major and minor version upgrades with minimal downtime. Support migrations to PostgreSQL from other engines (e.g., SQL Server, MySQL, Oracle) and between clouds, using tools such as AWS DMS, Azure Database Migration Service, pglogical, or logical replication.
• Connection & Scale Management: Implement and tune connection pooling (PgBouncer, pgpool‑II, RDS Proxy), read/write splitting, and workload isolation for high‑concurrency application traffic.
• Data Security & Compliance: Implement and maintain role‑based access control, row‑level security (RLS), TLS enforcement, encryption at rest via Azure Key Vault / AWS KMS, pgcrypto, and auditing via pgaudit. Ensure database practices meet financial‑industry security and compliance requirements.
• Extensions & Tooling: Evaluate and manage PostgreSQL extensions relevant to our workloads (pg_stat_statements, pg_partman, pgaudit, pgcrypto, postgres_fdw, pg_repack, TimescaleDB, PostGIS, Citus as applicable).
• Collaboration: Work closely with software developers, DevOps, data analysts, and IT teams to review schema changes and queries before release, and to translate business requirements into sound database solutions.
• Troubleshooting: Diagnose and resolve database issues including lock contention and deadlocks, long‑running transactions, transaction ID wraparound risk, replication lag, bloat, connection exhaustion, and network/connectivity problems.
• Documentation: Maintain comprehensive documentation of schemas, ER diagrams, query patterns, tuning decisions, runbooks, and administrative procedures.

Requirements

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 4+ years of hands‑on experience with PostgreSQL, covering design, development, and administration in production environments.
• Proven experience operating managed PostgreSQL in the cloud is required — Azure Database for PostgreSQL (Flexible Server) and/or Amazon RDS / Aurora PostgreSQL. Experience with both Azure and AWS is strongly preferred.
• Proven experience running standalone / self‑managed PostgreSQL on Linux is required — installation, configuration, OS‑level tuning, HA cluster setup (Patroni / repmgr / pg_auto_failover), and self‑managed backup tooling (pgBackRest / Barman / WAL‑G).
• Working proficiency in Linux administration and shell scripting (Bash), sufficient to operate and troubleshoot a database host independently.
• Strong command of SQL and PL/pgSQL, including window functions, CTEs, and advanced query constructs.
• Deep understanding of PostgreSQL internals: MVCC, vacuum and autovacuum, the query planner and statistics, WAL, transaction isolation levels, and locking behaviour.
• Solid experience with indexing strategy, query plan analysis, and end‑to‑end query optimization.
• Practical experience with backup/restore, PITR, replication, and high‑availability configurations.
• Experience with schema version control and migration tooling (Flyway, Liquibase, Alembic, or similar).
• Experience with SQL Server, MySQL, or other relational database systems is a plus.
• Experience with ETL processes and tools is a plus.
• Excellent problem‑solving skills and attention to detail.
• Ability to work independently and collaboratively in a team environment.
• Strong written and verbal communication skills.

Preferred Skills

• PostgreSQL certification (EDB, or equivalent cloud database certifications such as Azure Database Administrator Associate / AWS Database Specialty).
• Experience with Infrastructure as Code for database provisioning and configuration management (Terraform, Bicep, ARM, CloudFormation, Ansible).
• Experience running PostgreSQL in containers or Kubernetes (Docker, CloudNativePG, Crunchy Postgres Operator, Zalando Postgres Operator).
• Familiarity with DevOps practices and CI/CD pipelines for database changes (Azure DevOps, GitHub Actions, Jenkins).
• Monitoring and observability experience with tools such as pgwatch2, Prometheus + Grafana, Datadog, pgBadger, Azure Monitor, or CloudWatch.
• Experience with data warehousing and BI tools (Azure Synapse, Amazon Redshift, Power BI, Tableau).
• Experience with distributed or time‑series PostgreSQL extensions (Citus, TimescaleDB).
• Knowledge of NoSQL databases (e.g., MongoDB, Redis, Cassandra) is an advantage.
• Exposure to big data technologies (e.g., Spark) is a plus.
• Prior experience in FinTech, trading, or other high‑transaction, regulated domains.

Benefits

• Unique experience in the Fin-Tech industry, with a leading, fast‑growing company.
• Good atmosphere at work and a comfortable working environment.
• Coverage for Self + Family (Spouse and up to 2 Children).
• Attractive leave benefits including Maternity, Paternity Benefit, Vacation Leave & Leave Encashment.
• Reward & Recognition – Monthly, Quarterly.
• Loyalty benefits & Leaves.
• Employee referral program.