**PostgreSQL Consultant/DBA Mid/Senior** **Work Mode:** Remote **Job Description:** **Requirements and Qualifications:** * Mid/Senior DBA – PostgreSQL Job Description We are seeking a Mid/Senior DBA specialist in PostgreSQL, with practical and proven experience in critical and high-availability environments. * The professional will be responsible for the entire database lifecycle—from installation to preventive maintenance—performing optimization, security, and automation tasks to ensure maximum performance, data integrity, and availability. Responsibilities * **Administer complex PostgreSQL production environments, ensuring performance, security, and availability.** * Install, configure, upgrade, and apply version patches (major/minor upgrades). * **Perform advanced performance tuning (execution plans, indexes, partitioning, vacuum, autovacuum, hints).** * Implement and manage native replication, streaming replication, logical replication, and high-availability (HA, failover) scenarios. * **Ensure backup and recovery strategies, including periodic restoration tests.** * Automate routine tasks via scripts (SQL, Bash, PowerShell) or tools (pg\_cron). * **Implement and monitor security: roles, access policies, encryption, auditing.** * Resolve complex incidents related to performance, locking, corruption, and replication failures. Mandatory Requirements * **Advanced, hands-on production experience with PostgreSQL.** * Solid knowledge of: o Administration and troubleshooting. o Replication (streaming/logical) and high availability. o Performance tuning and execution plan analysis. o Backup, restore, and disaster recovery. * **Experience in security (roles, grants, encryption, auditing).** Automation of routines using scripts and jobs. * **Experience with PostgreSQL-specific monitoring tools. Preferred Qualifications** * Cloud experience (AWS RDS/Aurora, Azure Database, GCP CloudSQL). * **Experience with monitoring tools (Zabbix, Prometheus, Grafana).** * PostgreSQL certifications. * **Interest in contributing to the community and learning new technologies. Ideal Profile** * Analytical, proactive, detail-oriented professional with real-world experience in critical environments, capable of diagnosing and resolving complex issues quickly and effectively. Employment Type: Full-time CLT Compensation: R$6\.813,40 \- R$7\.500,00 per month