System Administrator

Orange and Bronze Software Labs Ltd, Co.; Metro Manila; Hybrid; PHP 600,000 - 900,000; Full time

Job summary

Orange and Bronze Software Labs Ltd, Co. seeks a skilled PostgreSQL Administrator to join our team in Makati City. The role focuses on performance, security, and high availability of our PostgreSQL databases, with collaboration across engineering to optimize queries and scale data infrastructure.

Ideal candidates have 3+ years of hands-on PostgreSQL experience, strong Linux skills, and a passion for automation and reliability. Hybrid work setup offered.

Qualifications

• 3+ years hands-on experience with PostgreSQL databases.
• Deep understanding of PostgreSQL architecture, MVCC, vacuuming and partitioning.
• Experience with replication, clustering and connection pooling.
• Proficiency in backup and restore tools (pgBackRest, Barman, WAL-G).
• Strong Linux/Unix administration and command-line skills.
• Scripting ability in Bash, Python, or Go for automation.
• Analytical mindset with track record of solving performance issues.

Responsibilities

• Install, configure, upgrade, and maintain PostgreSQL across dev, staging, and prod.
• Monitor performance, identify bottlenecks, and optimize queries and indexes.
• Design and implement backup/restore and PITR; ensure HA architectures.
• Manage security, access controls, encryption, and compliance.
• Set up monitoring and alerting using Prometheus, Grafana and related tools.
• Automate routine tasks using scripting and IaC tools like Ansible/Terraform.
• Collaborate with backend engineers on migrations and best practices.
• Serve as on-call lead for database incidents and 24/7 uptime.

Skills

PostgreSQL expertise

Linux/Unix

Automation scripting

Query optimization

High availability

Backup & recovery

Replication clustering

Monitoring tools

Tools

pgBackRest

Barman

WAL-G

Prometheus

Grafana

PgBouncer

HAProxy

Ansible

Terraform

Job description

Job Description

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