Database Administrator (PostgreSQL)

Job Description :

Job title : Data Base Administrator (DBA)

Location : Remote

We are a fast-paced startup building a multi-tenant SaaS platform with heavy analytics and real-time reporting needs. We are looking for a hands-on Senior Data Platform Engineer who can own our PostgreSQL + AWS data stack end-to-end – from OLTP operations to OLAP analytics, including production upgrades, performance tuning, and DevOps-oriented database operations.

This is not a pure “analytics engineer” role. We need someone who is equally comfortable:

• Running production database upgrades and migrations with minimal downtime,

• Designing and tuning multi-tenant PostgreSQL schemas and queries, and

• Owning RDS / Aurora operations, connection pooling, and high availability in a startup environment.

Key Responsibilities

1. Database Operations & Reliability

• Own PostgreSQL instances (self-managed or AWS RDS/Aurora) for a multi-tenant SaaS environment.

• Plan and execute production engine upgrades, minor/major version upgrades, and patch rollouts with near-zero downtime.

• Configure and manage RDS Proxy and/or pgBouncer for efficient connection pooling across application services.

• Implement and maintain backup strategies, point-in-time recovery (PITR), replication, and failover (single-region and/or multi-region).

• Ensure high availability, resilience, and operational continuity during peak traffic and releases.

2. Performance Tuning & Query Optimization

• Continuously monitor performance using PostgreSQL stats/pg_stat_statements, system catalogs, and monitoring tools (e.g., Datadog, CloudWatch).

• Identify and optimize long-running and high-cost queries; design indexes, partitions, and materialized views where needed.

• Tune work_mem, shared_buffers, effective_cache_size, and other key parameters according to workload patterns.

• Implement strategies like read replicas, query routing, and workload separation to handle heavy analytical queries without impacting OLTP.

3. Data Architecture – OLTP + OLAP

• Design and maintain hybrid OLTP-OLAP architecture:

◦ OLTP for real-time transactions.

◦ OLAP layer (e.g., S3 + Athena/Iceberg or warehouse) for historical analytics.

• Build near-real-time data pipelines using CDC (Change Data Capture) tools (e.g., AWS DMS) to replicate data from PostgreSQL into data lake/warehouse.

• Design gold-layer tables and pre-aggregations to support low-latency dashboards and reports (e.g., < 30-minute freshness).

• Implement union views or query patterns that combine OLTP + OLAP data for seamless user experience.

4. AWS & DevOps Collaboration

• Work closely with DevOps to maintain infrastructure as code (CloudFormation/Terraform/CDK) for database and analytics infrastructure.

• Own the DB side of deployments: schema migrations, rollbacks, environment promotion (dev → staging → prod).

• Define and enforce runbooks for upgrades, failover, incident handling, and capacity planning.

• Implement and refine monitoring, alerting, and dashboards (Datadog/Prometheus/Grafana/CloudWatch) for CPU, IO, connections, deadlocks, queue length, etc.

5. Security, Multi-Tenancy & Best Practices

• Design and enforce tenant isolation strategies (schema-per-tenant, row-level security, or hybrid patterns).

• Implement access control, encryption at rest/in transit, and audit logging for compliance.

• Establish database coding standards (no SELECT *, safe joins, effective indexing patterns, etc.) and review queries produced by the engineering team.

Must-Have Skills & Experience

• 7–10+ years of hands-on experience with PostgreSQL in production environments.

Speak with Employer

+91 9629311599

aswini.u@applogiq.org

Job Types: Full-time, Permanent

Benefits:

• Health insurance

Work Location: Remote