System Administrator

Orangeandbronze; Makati; Hybrid; PHP 669,600 - 892,800; Full time

Job summary

A technology company is seeking a skilled PostgreSQL Administrator in the Philippines. You will manage and optimize PostgreSQL databases, ensuring performance, security, and high availability. The ideal candidate will have over 3 years of experience with PostgreSQL, strong Linux skills, and the ability to automate tasks using scripts. Collaboration with engineering teams and troubleshooting database issues are key responsibilities.

Qualifications

• 3+ years of hands-on experience specifically with PostgreSQL.
• Deep understanding of PostgreSQL architecture and indexing.
• Proven experience in setting up PostgreSQL replication.

Responsibilities

• Install, configure, upgrade, and maintain PostgreSQL databases.
• Monitor performance and optimize query execution plans.
• Design and test high availability and disaster recovery solutions.
• Implement security measures and ensure data compliance.
• Set up monitoring tools to maintain system health.
• Automate routine tasks using scripting and configuration management.
• Collaborate with backend engineers on database best practices.
• Serve as the primary contact for database-related incidents.

Skills

PostgreSQL performance tuning

Database security management

Linux/Unix administration

Automation with scripting

Problem solving

Tools

Prometheus

Grafana

pgAdmin

Ansible

Terraform

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

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.

Seniority Level

Mid‑Level

Employment Type

Full‑time

Job Function

Information Technology, Quality Assurance, and Business Development

IT Services, IT Consulting, and Software Development