We seek 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 the reliability, performance, and scalability of the criticality of database infrastructure - leveraging PGPool for load balancing.
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.
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.
Qualifications:
• 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 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