Simple Logic - Database Administrator - PostgreSQL

Job Description

Required Skills & Experience: PostgreSQL DBA (Level 3)

- 2+ years of hands-on PostgreSQL DBA experience in production environments.

- Deep knowledge of PostgreSQL internals, architecture, and tuning.

- Proven experience with pgBackRest, Barman, pg_basebackup, pg_dump.

- Strong expertise with HA and replication solutions (Patroni, repmgr).

- Hands-on experience with PITR, disaster recovery, and cluster rebuilds.

- Proficiency in Linux/Unix environments, shell scripting, and automation.

- Solid understanding of database security and compliance best practices.

- Excellent troubleshooting skills and experience handling critical incidents.

- Monitor and optimize performance, tune queries and indexes, manage vacuuming and bloat,

implement pooling (PgBouncer), and maintain robust monitoring and alerts.

- Diagnose and recover from cluster corruption using advanced tools and procedures, leveraging backups and replicas to ensure business continuity.

- Plan and execute major upgrades (pg_upgrade, logical replication), cross-version and cross-platform migrations (on-prem ? cloud), ensuring minimal downtime and data integrity.

- Strong hands-on experience with AWS PostgreSQL services like RDS and Aurora, including parameter groups, snapshot management, performance insights, and multi-AZ failover.

- Experience with monitoring tools (Prometheus, Grafana, or similar) is a plus.

- Good communication skills and ability to work collaboratively in a 24x7 production support environment.

- Experience with logical replication and foreign data wrappers.

- Familiarity with cloud-managed PostgreSQL services.

- Familiarity with connection pooling and proxy tools (PgBouncer, HAProxy).

- Maintain SOPs, runbooks, and knowledge base articles.

- Automate routine tasks and checks using scripts or scheduling tools (cron, pg_cron).

- Mentor junior DBAs and conduct knowledge-sharing sessions.

MySQL DBA Responsibilities (Secondary) :

- Good knowledge of MySQL architecture and installation.

- Perform MySQL backup and restore operations.

- Manage MySQL users, roles, and permissions.

- Setup and troubleshoot MySQL replication.