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.
JOB 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.
Preferred Qualification:
Experience with cloud-managed PostgreSQL services (e.g., Amazon RDS, Aurora, Google Cloud SQL, or Azure Database for PostgreSQL).
Familiarity with containerization and orchestration (Docker, Kubernetes).
Knowledge of other database systems (e.g., Redis, MongoDB, MySQL) or data warehousing solutions.
