System Administrator

We are looking for a highly skilled and proactive PostgreSQL Administrator to join our team. In this role, you will be responsible for the performance, integrity, and security of our PostgreSQL databases. You will design, implement, and maintain database architectures, ensure high availability, and work closely with our engineering teams to optimize queries and scale our data infrastructure. The ideal candidate is deeply passionate about database internals, automation, and continuous improvement.

Work Setup: Hybrid

Office Location: Makati City

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.

Preferred Qualifications

• 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.
• PostgreSQL certification.

Seniority Level

Mid-Level

Employment Type

Full-time

Industries

IT Services, IT Consulting, and Software Development