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.