Postgres Database Administrator (DBA)

Responsibilities:

• PostgreSQL Database Administration: Collaborate with teams to integrate PostgreSQL databases into the infrastructure and ensure their optimal performance.
• Perform PostgreSQL database backups, recovery, and restoration activities.
• Optimize PostgreSQL configurations and query performance for transactional workloads.
• Design and implement PostgreSQL data models and SQL scripts for transactional workloads.
• Manage PostgreSQL databases in GCP environments (preferred).
• Diagnose and troubleshoot PostgreSQL production incidents and resolve performance bottlenecks.

Requirements:

• PostgreSQL: 5+ years of experience in PostgreSQL database administration.
• Expertise in installing, configuring, and monitoring PostgreSQL databases.
• Proficiency in PostgreSQL data modeling and SQL scripting.
• Strong experience in performance tuning PostgreSQL databases to optimize writes and reads.
• Hands-on experience with PostgreSQL in GCP environments (preferred).
• Proven ability to evaluate database performance, isolate bottlenecks, and implement optimizations in transactional setting.