PostgreSQL Database Engineer (46956) - Mandaluyong

Salary : 40,000 - 80,000

• 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)RESPONSIBILITIES : 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.