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