System Administrator, Makati
-
Makati, Philippines
-
Posted: less than a month ago
-
Save
- 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.
- 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.
-
Company nameSynctalents International Corporation
-
Job positionSystem Administrator
System Administrator has been posted in the Bel-Air Administrative & Support category on Locanto.
If you’re still wanting to browse, there is so much to explore in the Administrative & Support category! Take a look at the ads HIRING SALES COORDINATOR, Makati City, HIRING PROJECT COORDINATOR, Makati City and Administrative Staff in 8747 Paseo de Roxas Avenue, Makati to discover more of what you’re looking for. Currently, there are 3 ads posted in the Administrative & Support category in Bel-Air.
Interested in more? Widen your search to view ads in nearby areas of Bel-Air. This includes Administrative & Support in Makati, San Isidro and Mandaluyong City. There are more ads within a 15 km radius for this category. If you want to view those ads, click here.