Duties and Responsibilities

• Database Management: Install, configure, upgrade, and maintain PostgreSQL database systems across development, staging, and production environments.
• Performance Tuning: Monitor database performance, identify bottlenecks, and optimize query execution plans, indexing strategies, and database parameters.
• High Availability & Disaster Recovery: Design, implement, and test Backup/Restore strategies, Point-in-Time Recovery (PITR), and High Availability (HA) architectures using streaming replication and tools like Patroni or repmgr.
• Security & Compliance: Manage database access, user roles, and permissions. Implement encryption at rest and in transit, and ensure compliance with relevant data security standards.
• Monitoring & Alerting: Set up and maintain database monitoring tools (e.g., Prometheus, Grafana, pgAdmin, Datadog) to ensure system health and proactively address issues before they impact users.
• Automation & Infrastructure as Code: Automate routine database tasks (provisioning, backups, patching) using scripting (Python, Bash) and configuration management tools (Ansible, Terraform).
• Collaboration: Partner with backend engineers to review schema designs, assist with complex database migrations, and educate the team on database best practices.
• Troubleshooting: Serve as the primary point of contact for database-related incidents, participating in an on-call rotation to ensure 24/7 uptime.

Required Skills & Qualifications

• Experience: 3+ years of hands-on experience as a Database Administrator specifically focused on PostgreSQL.
• Core Knowledge: Deep understanding of PostgreSQL architecture, MVCC, vacuuming, indexing, and partitioning.
• High Availability: Proven experience setting up and managing PostgreSQL replication, clustering, and connection pooling (e.g., PgBouncer, HAProxy).
• Backup Solutions: Proficiency with PostgreSQL backup and recovery tools such as pgBackRest, Barman, or WAL-G.
• Operating Systems: Strong Linux/Unix administration skills and familiarity with the command line.
• Scripting: Ability to write and maintain scripts in Bash, Python, or Go for automation.
• Problem Solving: Excellent analytical skills with a track record of resolving complex database performance issues.