System Administrator

Synctalents International Corporation; Makati; On-site; PHP 1,228,501 - 1,842,751; Part time

Job summary

Synctalents International Corporation is hiring a part-time Database Administrator based in Makati, Philippines. The ideal candidate should have at least 3 years of experience mainly with PostgreSQL, focusing on installation, configuration, and performance tuning of database systems. Responsibilities include ensuring database high availability, implementing security measures, and collaborating with backend engineers. Candidates must possess strong Linux skills and be skilled in scripting languages like Bash and Python.

Qualifications

• 3+ years of hands-on experience as a Database Administrator specifically focused on PostgreSQL.
• Deep understanding of PostgreSQL architecture, MVCC, vacuuming, indexing, and partitioning.
• Proven experience setting up and managing PostgreSQL replication and clustering.

Responsibilities

• Install, configure, upgrade, and maintain PostgreSQL database systems.
• Monitor database performance and optimize query execution plans.
• Design, implement, and test Backup/Restore strategies.

Skills

PostgreSQL

Database Performance Tuning

Linux/Unix Administration

Scripting

Problem Solving

Education

Bachelor's degree

Tools

Ansible

Terraform

pgAdmin

Prometheus

Grafana

Job description

Hybrid - Makati 3-5 Yrs Exp Bachelor Part-time

Job Description

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.