Overview Salary 40,000 PHP ~ 80,000 PHP
Industry Financial Service
Job Description We are seeking a highly skilled PostgreSQL Database Engineer to join our dynamic team. The ideal candidate will have a strong background in database administration, with a deep understanding of PostgreSQL and experience deploying and managing high availability database clusters using Docker Swarm on Red Hat Linux. This role will be instrumental in ensuring the reliability, performance, and scalability of our critical database infrastructure, leveraging PGPool for load balancing.
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) PgPool
• Configure connection pooling, load balancing, and failover.
• Monitor PgPool performance and implement security controls.
4) PostgreSQL (PgSQL)
• 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.
Key Responsibilities:
• Design, implement, and maintain high availability PostgreSQL database clusters on Docker Swarm running on Red Hat Linux.
• Configure and optimize PostgreSQL databases for performance, scalability, and security.
• Deploy and manage pgpool for load balancing in PostgreSQL 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 PostgreSQL, 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 PostgreSQL and PgPool configurations that could cause connection bottlenecks or timeouts.
• Performance profiling: Techniques for profiling database performance to identify issues related to connection latency or timeouts.
Qualifications Requirement • Bachelor's degree in Computer Science, Computer Engineering, or a related field.
• Minimum of 3 years of experience as a PostgreSQL Database Administrator.
• Strong understanding of PostgreSQL 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 PostgreSQL clusters.
• Experience with 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) English Level Conversational
Other Language English
Additional Information Benefit ·REGARDLESS OF EMPLOYMENT STATUS
-HMO
-Medicine Allowance
-Group Life Insurances
-13th months payment
-SL:15 days
-VL:15 days
?Each employee will earn 1.25 days of VL and 1.25 days of SL after a month of service. However, a total of fifteen (15) days VL and fifteen (15) days SL will be made available to employees at the start of the year.
-Maternity Leave : 105 Calendar Days / 120 Calendar Days-Single Parent
-Bereavement Leave:3 days
-Daily Subsistence Allowance
-Transportation Allowance
-Japanese Language Allowance (For employees with N4-N1 JLPT Certification)
-Miscellaneous Benefits
?P 2,500.00 worth of flower arrangement or mass card and P 5,000.00 Financial Aid (given to employees who have lost an immediate family member)
·UPON REGULARIZATION
-Birthday Leave:1 day
-Calamity Leave:2 days
-Loyalty Incentive
?Cash incentive amounting to 1/12 of the total basic salary on the 3rd, 5th, 7th, 10th, 13th, 15th, 17th , 20th year of tenure. Working Hour 9:00 ~ 18:00
Holiday Ph holiday
Job Function