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.