概要

• 給与

  40,000 PHP ~ 80,000 PHP

• 業界

  Financial Service

• 仕事内容

  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.