Senior Database Administrator (PostgreSQL)

We are looking for a hands-on DBA / Database Developer who will be an integral part of our development pipeline. You will not only manage the health of our PostgreSQL clusters but also actively contribute code to the database layer. You will write and maintain complex Stored Procedures (PL/pgSQL) to handle critical transactional logic directly within the DB, ensuring high performance and data integrity for our payment gateway.

Responsibilities:
Database Development: Write, optimize, and version-control Stored Procedures (PL/pgSQL) and functions to encapsulate complex business logic (e.g., recursive payment cascading, financial reconciliation) within the database.
Pipeline Integration: Participate in the GitLab development workflow. You will review migration scripts created by developers and commit your own database code (procs, views, triggers).
OLTP Management: Manage AWS RDS/Aurora PostgreSQL instances for the core payment gateway, ensuring High Availability (HA) and Disaster Recovery (DR).
Performance Tuning: Analyze slow queries, optimize execution plans, and refactor existing SQL/PL/pgSQL to maximize throughput.
Data Warehouse Ops: Maintain the DW schema and oversee data pipelines using Airbyte, dbt, and Kestra.
Security & Compliance: Implement strict access controls, auditing, and row-level security where needed to satisfy PCI DSS.

Requirements:
PostgreSQL Expert: Deep knowledge of Postgres internals and advanced SQL.
PL/pgSQL Proficiency: Strong experience writing complex Stored Procedures, Triggers, and Functions. You treat database logic as code (versioning, testing).
Data Engineering Tools: Experience with dbt and ETL/ELT tools like Airbyte or Kestra.
Cloud Infrastructure: Experience managing databases in AWS (RDS, Aurora).
Security: Proven experience with database encryption and PCI DSS compliance.
Tech Stack: PostgreSQL (PL/pgSQL), AWS RDS, dbt, Airbyte, Kestra, GitLab.