PostgreSQL Database Administrator

Planning, development, deployment, and continuous execution of technical support activities for ICT users and Infrastructure Support Services, both remote and on-site, including guidance and troubleshooting, receiving, registering, analyzing, diagnosing, handling client requests, problem resolution, service implementation, migrations and technology transfers, executing periodic procedures, and controlling and updating documentation aimed at supporting the ICT infrastructure. Exclusive and Advanced Specialization in PostgreSQL Environment Management: Complete and exclusive management of corporate PostgreSQL ecosystems. Tuning and Performance: Advanced mastery of vacuum/autovacuum routines, performance optimization, and detailed analysis of execution plans (EXPLAIN, ANALYZE). Connection Management (PgBouncer): Installation, configuration of pooling modes, advanced connection monitoring, and diagnosis of saturation issues. Automation and Development: Ability to create, read, and review complex scripts in PL/pgSQL. Linux Infrastructure, Resilience, and Continuity Operating System Support: Support and tuning in Linux environments (RHEL, Debian, and Ubuntu), focusing on storage and file systems for high database performance. High Availability (HA) and DR: Hands-on experience with physical and logical replication, preventive monitoring with alerts, and strategies...