We seek a highly skilled Postgre SQL Database Engineer to join our dynamic team.
The ideal candidate will have a strong background in database administration, with a deep understanding of Postgre SQL and experience deploying and managing high-availability database clusters using Docker Swarm on Red Hat Linux.
This role will be instrumental in the reliability, performance, and scalability of the criticality of database infrastructure - leveraging PGPool for load balancing.
Key Responsibilities:

• Design, implement, and maintain high availability Postgre SQL database clusters on Docker Swarm running on Red Hat Linux.

• Configure and optimize Postgre SQL databases for performance, scalability, and security.

• Deploy and manage pgpool for load balancing in Postgre SQL clusters.

• Troubleshoot and resolve database-related issues promptly.

• Develop and maintain database backup and recovery procedures.

• Collaborate with development teams to ensure database compatibility and performance.

• Stay up-to-date with the latest Postgre SQL, Docker Swarm, Red Hat Linux, and PGPool technologies and best practices.

Troubleshooting Skills:

• Error analysis: Develop skills in analyzing logs and error messages related to database connection I/O errors.

• Network diagnostics: Understand how to use tools like ping, traceroute, and netstat to identify connectivity issues.

• Resource monitoring: Learn to monitor server resources (CPU, memory, I/O) that can affect database connections.

• Database configuration: knowledge of Postgre SQL and Pg Pool configurations that could cause connection bottlenecks or timeouts.

• Performance profiling: Techniques for profiling database performance to identify issues related to connection latency or timeouts.

General Skill Requirements:
1) Kubernetes

• Understand cluster architecture, management, scaling, and networking.

• Implement RBAC, network policies, and security best practices.

2) Docker

• Create, manage, and optimize containers.

• Use Docker Compose and understand Docker networking.

3) Pg Pool

• Configure connection pooling, load balancing, and failover.

• Monitor Pg Pool performance and implement security controls.

4) Postgre SQL (Pg SQL)

• Database design, SQL, backups, and tuning.

• Implement access control, encryption, and security measures.

5) Database Administration

• Automate tasks, manage roles and monitor database health.

• Implement backup strategies and disaster recovery.

6) Networking and Security

• Understand TCP/IP, firewalls, VPNs, and secure connections.

• Troubleshoot network issues and secure database communications.

Qualifications:

• Bachelor's degree in Computer Science, Computer Engineering, or a related field.

• Minimum of 3 years of experience as a Postgre SQL Database Administrator.

• Strong understanding of Postgre SQL architecture, internals, and performance tuning.

• Proficiency in Docker and Docker Swarm for containerization and orchestration.

• Experience with high-availability database solutions, such as replication and failover.

• Knowledge of PGPool for load balancing in Postgre SQL clusters.

• Experience with the Red Hat Linux operating system and its administration.

• Knowledge of scripting languages (e.g., Bash, Python) for automation tasks.

• Excellent problem-solving and analytical skills.

• Ability to work independently and as part of a team.

Good to have skills:

• Experience with infrastructure security implementation.

• Experience with network implementation (LAN/WAN/WLAN/VPN)

• Experience with penetration testing (VAPT).

• Experience with cloud platforms (AWS)

• Experience with virtualization (Hyper-V, VMWARE)

Work set up is full-onsite, our new office location is in Greenfield Tower, Mandaluyong.
We are working Monday to Friday, 9 AM to 6 PM.
Initial Online Interview then F2F Final Interview
Job Type: Permanent
Pay: Php40,000.00 - Php80,000.00 per month
Benefits:

• Additional leave
• Company Christmas gift
• Health insurance
• Opportunities for promotion
• Paid training
• Promotion to permanent employee

Schedule:

• 8 hour shift
• Day shift
• Holidays
• Monday to Friday
• Overtime
• Weekends

Supplemental Pay:

• 13th month salary
• Overtime pay
• Performance bonus

Experience:

• Postgre SQL Database Administrator: 5 years (Required)
• Postgre SQL architecture, internals, and performance tuning: 5 years (Required)
• Docker and Docker Swarm: 5 years (Required)
• database solutions, such as replication and failover: 5 years (Required)
• PGPool for load balancing in Postgre SQL clusters: 5 years (Required)
• Red Hat Linux operating system and its administration: 5 years (Required)
• scripting languages (e.g., Bash, Python): 5 years (Required)
• Problem-solving and analytical skills: 5 years (Required)
• infrastructure security implementation: 3 years (Required)
• network implementation (LAN/WAN/WLAN/VPN): 3 years (Required)
• penetration testing (VAPT): 3 years (Required)
• cloud platforms (AWS): 3 years (Required)
• virtualization (Hyper-V, VMWARE): 3 years (Required)